oracle Ö´ÐÐ˳Ðò - Oracle / »ù´¡ºÍ¹ÜÀí
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,dname) values(v_deptno,v_dname); end; / Ö´Ðнá¹û£º Enter value for deptno: 67 Enter value for dname: gg ÇëÊäÈ벿ÃźźͲ¿ÃÅÃû: Ϊʲô¡°ÇëÊäÈ벿ÃźźͲ¿ÃÅÃû¡±Õâ¾ä»°×ÜÊÇÔÚºóÃæ°¡£¡£¡£¡£¡£¡
oracle ÊÇÏȱàÒ룬ÔÙÖ´ÐУ¬±àÒëʱ£¬Èç¹ûÓÐÒªÇóÊäÈëµÄ£¬¾Í»áÌáʾÄãÊäÈ룬ÕâÑù£¬²ÅÄÜÖ´ÐУ¬ËùÒÔ¡°ÇëÊäÈ벿ÃźźͲ¿ÃÅÃû¡±Õâ¾ä»°£¬×ÜÔÚºóÃæ ËüÊÇÏÈ»ñÈ¡ËùÓеÄ&µÄ±äÁ¿µÄÖµ£¬È»ºóÔÙ´¦ÀíÄãµÄ³ÌÐò¿é¡£ ¾ÍºÃÏñÊÇÏȱàÒ룬ÔÙÔËÐУ¬¶ø²»ÊDZ߽âÊͱßÖ´ÐÐ ¶÷ ÔÚÖ´ÐеÄʱºòÏÈÊÇ¿´ÀïÃæÊÇ·ñÓÐλÖñäÁ¿ ÓÐλÖñäÁ¿µÄ»° ¾ÍÏȸøÎ»ÖñäÁ¿¸³Öµ È»ºó²Å½øÐÐÆäËûµÄ²Ù×÷¡£ Enter value for..ÕâÁ½¾ä²»ËãÊä³ö£¬ ÊÇÏȸ³ÖµÈ»ºó²ÅÓÐÖ´ÐУ¬ËùÒÔ ÇëÊäÈë ÄǾä»áÔÚ×îºó Èç¹ûÓÃpl/sql developerÖ´ÐÐÕâ¶Î³ÌÐò¾ÍºÜÈÝÒ׿´³öÀ´ Õâ¸öÔõô²ÅÄÜÏÈÊä³ö×Ö·û£¬ÔÚÊä³öÒª²åÈëµÄÖµ£¡£¿£¿ÒýÓà Enter value for..ÕâÁ½¾ä²»ËãÊä³ö£¬ ÊÇÏȸ³ÖµÈ»ºó²ÅÓÐÖ´ÐУ¬ËùÒÔ ÇëÊäÈë ÄǾä»áÔÚ×îºó Èç¹ûÓÃpl/sql developerÖ´ÐÐÕâ¶Î³ÌÐò¾ÍºÜÈÝÒ׿´³öÀ´ ÓÐûÓÐÌá¸ßÊä³öÓï¾äÓÅÏȼ¶µÄ·½·¨°¡£¡£¡£¡ °¡.....ÄѵÀÖ»ÄÜÕâÑùÀ²¡£¡£¡£¡£¡£ SQL code Code highlighting produced by Actipro CodeHighli
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......