ºÍÍøÓÑ̽ÌÖ ÈçºÎѧϰOracle
http://www.inthirties.com/thread-757-1-1.html
ºÜÈÙÐÒ£¬±»ÑûÇëΪCSDNѧϰ´ó±¾ÓªÀïµÄOracleÀÏʦ¡£ÓиöÍøÓÑ·¢ÏûÏ¢¹ýÀ´£¬Ò»Æð̽ÌÖÈçºÎѧϰOracle£¬Ò»ÏÂÊǻظ´£¬ºÍ´ó¼ÒÒ»Æð̽ÌÖ¡£
Ê×ÏÈ£¬ÒªÃ÷È·ÄãµÄ·½ÏòºÍÄ¿±ê¡£
¶ÔÓÚOracleÀ´Ëµ£¬Õâ¸öÌåϵÊDZȽÏÅÓ´óµÄ£¬ËùÒÔÃ÷È·Ò»¸öÄ¿±êºÍÄãµÄ·½ÏòÊÇÔÚѧϰǰÐèҪ˼¿¼µÄÎÊÌâ¡£ ¹ÜÀí£¬¿ª·¢£¬Êý¾ÝÍÚ¾ò»òÕßÊǸü¸ß¼¶µÄÄÚÈÝ¡£
ѧϰµÄÔ½ÉîÈ룬ÐèÒªÁ˽⵽µÄ֪ʶ¾ÍÔ½ÐèÒªÉîÈë¡£
ѧϰµÄʱºò£¬¿ÉÒÔÏÈ´Ó×Ôѧ¿ªÊ¼£¬ÎÒÒ²ÊÇ´Ó×Ôѧ¿ªÊ¼µÄ£¬ÏÈ¿ÉÒÔÑ¡ÔñһЩ»ù´¡µÄÊé¼®×ÅÊÖ£¬´óÖµÄÁ˽âOracleµÄһЩ»ù±¾µÄ֪ʶ£¬¸ÅÄîºÍÌåϵ»ù´¡¡£ Èç¹ûÒ»ÉÏÊÖ£¬´ó¸´ÔÓÁË£¬ÈÝÒ×´òÏûµôÄãµÄ»ý¼«ÐÔ¡£ ´Ó¶øºÜÈÝÒ×Íü¼Ç¡£ ÕÆÎÕµ½Ò»¶¨µÄ»ù´¡ÒԺ󣬾ͿÉÒÔ°´ÄãµÄ·½Ïò½øÐиüÉîÈëµÄһЩѧϰÁË£¬ÓÉÓÚÉîÈëµÄ¹ý³ÌÖÐÊƱØÓÐһЩÄѵãºÍÒɵ㣬ÕâʱºòÄãÐèÒª½èÖúÍøÂçµÄÁ¦Á¿ Í»ÆÆËûÃÇ£¬µ±È»Èç¹ûÕâʱºòÓбȽϺõÄÒýµ¼×Å°ïÄãÒ»Æð½â¾öÕâЩÒɵ㣬ÄѵãµÄ»°£¬»áÓиüºÃµÄЧ¹û¡£
OracleµÄѧϰ²»µ¥µ¥ÊǸöѧµÄ¹ý³Ì£¬ËûÊÇÒ»¸ö·Ç³£¸´ÔÓµÄÌåϵ£¬Èç¹ûµ¥µ¥ÊÇѧ£¬½ö½öÊÇÕÆÎÕһЩµãÉϵÄ֪ʶ£¬ÕâÑùµÄ֪ʶÊÇÏÁյģ¬ÊǺÜÈÝÒ×ÈÃÄãÔÚһЩÉæ¼°µ½ÌåϵÉϵÄÎÊÌâʱ£¬²úÉúÀ§»óµÄ£¬ËùÒÔOracleµÄѧϰ£¬¸üҪͻ³ö¸ö“Ï°”£¬ ÈçºÎ×öºÃÕâ¸ö“Ï°”£¬¶ÔÓÚÄãµÄÉîÈëÊǺÜÖØÒªµÄ£¬ Òª¾³£¹á´©ÐԵĽøÐÐ˼¿¼£¬Ò»¸öÎÊÌâ³öÏÖÁËÒÔºó£¬ÓÐʱ»¹Òª¶à´ÓÃ棬²ã´ÎÉÏÈ¥½øÐÐ˼¿¼ºÍ×ܽᣬ֪ʶµã²ÅÄÜÓÐЧµÄ·á¸»ÆðÀ´£¬¶ø²»ÖÁÓÚÄÇôµ¥±¡£¬ÕâÑù²ÅÄÜÔÚÎÊÌâÖÐÓÐÒ»¸öºÜ׼ȷµÄ˼¿¼·½Ïò¡£
ѧϰOracleÊÇÒ»¸ö²»Ò׵Ĺý³Ì£¬ËùÒÔҪѧ»áÈ¥¼¤·¢×Ô¼ºÑ§Ï°µÄÐËȤ£¬ÐËȤÊÇ×îºÃµÄÀÏʦ£¬ÌرðÊÇÉîÈëµÄѧϰ£¬ÓкܶàÎÊÌâµÄ³öÏÖÊÇ»áÈÃÄã²»ÖªËù´ëµÄ£¬Èç¹ûÄãÓÐÐËȤÁË£¬ÕâÀïµÄÎÊÌâÈ´¿ÉÒÔ³ÉΪÄã²»¶Ï̽Ë÷²»¶Ï½ø²½µÄÒýÏߣ¬¶ø²»ÖÁÓÚ·ÅÆú¡£
ËÑË÷¸ü¶àÏà¹ØÖ÷ÌâµÄÌû×Ó: oracle study
ÌṩOracle¹ÜÀí/¹ÊÕÏ´¦Àí/ÓÅ»¯/°²×°/RAC/±¸·Ý»Ö¸´¼¼Êõ·þÎñ,ÌṩרҵµÄOracleÅàѵºÍ×Éѯ·þÎñ
רҵÂÛ̳ http://www.inthirties.com
¼¼Êõ²©¿Í http://blog.csdn.net/inthirties
¸öÈËÕ¾µã http://blog.inthirties.com
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
SQL*Loader ÓÃÓÚ½«´óÁ¿Êý¾Ý×°ÈëÊý¾Ý¿â¡£
¢Å¡¢¶¨¿íÊý¾Ý
´´½¨Êý¾ÝÎļþcontrol.txt£º
aaa,bbb
ccc,ddd
eee,fff
´´½¨¿ØÖÆÎļþcontrol.ctl£º
load data
infile 'c:\loader.txt'
append
into table tester.mm(
m1 position(1:3) char,
m2 position(5:7) char)
ÅúÁ¿¼ÓÔØÊý¾Ý£º
sqlldr tester/test control=c:\loade ......
½ñÌì×öÁË1¸öÊý¾Ýµ¼ÈëÐèÇó£¬Îı¾¼Ç¼ÓÐ12Íò¶àÌõ£¬TXTÎļþ´óС6M¶à£¬ÒòΪÒÔÇ°¶¼ÊÇÓÃoracleµÄtext import·½Ê½µ¼È룬¸ÕÊÔÑéÁËһϣ¬²»ÁéÑ飬µ±µ¼Èëµ½2Íò¶àÌõµÄʱºò£¬PLSQL¾Íµ±µôÁË£¬×ß²»¶¯ÁË¡£
ÒòΪ¿¼Âǵ½1´Îµ¼È룬ËùÓоö¶¨²ÉÓÃSQLLOADERµÄ·½Ê½¡£ ......