oracleѧϰÊé¼®ÍÆ¼ö
ÏÖÔÚ¶ÔoracleµÄÌåϵ½á¹¹ÓÐÁË´ó¸ÅµÄÁ˽â
Ïë½øÒ»²½Ñ§Ï°Ò»Ð©ÉîÈëµãµÄ¶«Î÷£ºÊý¾Ý¿âÐÔÄÜÓÅ»¯ºÍÊý¾Ý¿â±¸·ÝÓë»Ö¸´µÈÏà¹ØµÄ֪ʶ¡£
ÄÄλ´óϺÓкõÄѧϰÊé¼®ÍÆ¼öÒ»ÏÂ
²»ÊÇ˵µÄµç×ÓÊé¹þ£¬³ö°æÉç³ö°æµÄ
ллÁË
ºÜ¼±µÄ£¬ÔÚÏߵȡ£Èý¸öСʱºòÎÒ¾ÍҪȥÊéµêÁË
¡¶Oracle 10g ÐÔÄܵ÷ÕûºÍÓÅ»¯¡·
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716
ÓÐÊÊÓ¦³õѧµÄÂð£¿ÍƼöһϣ¬Ð»Ð»£¡
Oracle 9i&10g±à³ÌÒÕÊõ£ºÉîÈëÊý¾Ý¿âÌåϵ½á¹¹
Oracle 9i&10g±à³ÌÒÕÊõ ÉîÈëÊý¾Ý¿âÌåϵ½á¹¹
¸ÉÂïҪȥÊéµêÄØ£¬ÔÚÍøÉÏÂò¶àºÃ£¿
ÏÂÁËһЩ£¬¸Ð¾õÓеã³Â¾É
лл¸÷λ´óÏÀ£¬Ð¡µÜºÜÐèÒªÕâÑùµÄÊé¼®¡£
Oracle 9i&10g±à³ÌÒÕÊõ£ºÉîÈëÊý¾Ý¿âÌåϵ½á¹¹
Ïà¹ØÎÊ´ð£º
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
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 ......