oracleѧϰÃÔ»ó
ÎÒÊÇÒ»¸öJava³ÌÐòÔ±£¬×öÁËÁ½ÈýÄêÁË£¬ÏÖÔÚÕýºÃÓÃoracle±È½Ï¶à£¬Ïë
¶àѧѧoracle¡£µ«ÊÇ£¬ÎÒÓÖ²»ÊÇDBAÖ®ÀàµÄÖ±½ÓºÍoracleÌìÌìÅÝÔÚÒ»ÆðµÄ£¬
µ£ÐÄѧÆðÀ´µÄ»°£¬ÓкܶàÌõ¼þ²»ÄÜÔÊÐí¡£
ÎÒÖ»ÄÜÔÚ×Ô¼º»úÆ÷ÉÏ×°ÉÏoracle·þÎñÆ÷À´Ñ§Ï°£¬µ«±¾»úȷʵ²»ÄÜÈݵÄÏÂ
Õâ¸öÅÓ´óµÄ¶«Î÷¡£Èç¹ûÕæµÄÖ»ÊÇÔÚÎҵĵçÄÔÉÏÀ´Ñ§Ï°µÄ»°£¬²»ÖªµÀÄÜѧµ½
ʲôµØ²½£¬ÈçºÎ²ÅÄÜÀ©Õ¹×Ô¼ºµÄ֪ʶ¡£
Ò²²»ÖªµÀÕâôѧ£¬ÄÜ·ñ¶Ô×Ô¼ºµÄoracleÕæÊÇÓкõİïÖú¡£
¸Ð¾õÎÒÏÖÔÚѧoracle£¬¸ü¶àµÄÊÇÔÚ¹Ø×¢sqlÓï¾ä£¨È·Êµ²»Ôõô»áÓã©£¬µ½
µ×ѧϰoracleÊÇÓÐÄÄЩ´óµÄ·½ÃæÊÇÒª¹Ø×¢µÄ£¬È»ºóÈç¹ûҪϸ»¯µÄ»°£¬¸ÃÔõô
¸ãÄØ¡£
ÏÈ¿´¿´»ù±¾µÄÎĵµ£¬´òºÃ»ù´¡¡£
³ýÁËSQL/PLSQL£¬ORACLE»¹ÓкܶණÎ÷¡£¿´ÄãÏëÏòÄÄ·½Ãæ·¢Õ¹ÁË¡£
Èç¹ûÏë×öDBA£¬°²×°/ÅäÖᢱ¸·Ý/»Ö¸´£¬ÐÔÄܵ÷Õû£¬¶¼ÊDZØÐëµÄ£¡
Ò»¸öORACLE DBMS+Ò»¸öѧϰÊý¾Ý¿â£¬Ö»ÒªÊý¾ÝÁ¿²»´ó£¬²»»á³¬¹ý10G£¬ÏÖÔÚµÄÓ²ÅÌ£¬×ã¹»ÁË¡£
²»ÖªµÀÓÐÄÄЩºÃÊéÖµµÃÍÆ¼öÄØ¡£
Áí£ºÒ»Ì¨µçÄÔÖ÷»ú¿ÉÒÔÓжà¸öÈ«¾ÖÊý¾Ý¿âÂð£¿
ORACLEµÄÎĵµ£¬¾ÍÊÇ×îºÃµÄÊé¡£µ±È»£¬ÊÇÓ¢Îĵġ£
Áí£ºÒ»Ì¨µçÄÔÖ÷»ú¿ÉÒÔÓжà¸öÈ«¾ÖÊý¾Ý¿âÂð£¿
·Ç³£¿ÉÒÔ£¡
ÕâÖÖ°ïÖúÎĵµÊDZ¾»ú°²×°µÄʱºò¾Í¸½´øÓе쬻¹ÊÇÒªÖØÐÂÏÂÔØµÄ¡£
²»¹ýÏëÏëÊÇÓ¢Îĵ쬾ÍÓеãÐÄÐéÁË¡£
ÁíÍ⣬×öjdbcÁ´½ÓµÄʱºò£¬Ê¹ÓÃSIDÃû³Æ»¹ÊÇÈ«¾ÖÊý¾Ý¿âÃû°¡¡£
¼ÙÈ磺strConn = "jdbc:oracle:thin:@china-e7ed21b49:1521:abc";
×îºóµÄÓ¦¸ÃÊÇSID Ãû³Æ£¿»¹ÊÇ È«¾ÖÊý¾Ý¿âÃû°¡£¿
ѧjava »¹×öÁËÈýÄê ¿´À´sqlÓï¾ä¶¼Ã»Ê²Ã´ÎÊÌâ
Ö÷ÒªÏÈѧѧÊý¾Ý¿âÌåϵ½á¹¹
www.itpub.net Ê
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
SQL code:
declare
v_deptno number(2);
v_dname varchar2(14);
begin
dbms_output.put_line('ÇëÊäÈ벿ÃźźͲ¿ÃÅÃû:');
v_deptno:=&deptno;
v_dname:='&dname';
insert into dept01(deptno,dnam ......