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Ö´ÐÐÕâ¶Î³ÌÐò¾ÍºÜÈÝÒ׿´³öÀ´
Õâ¸öÔõô²ÅÄÜÏÈÊä³ö×Ö·û£¬ÔÚÊä³öÒª²åÈëµÄÖµ£¡£¿£¿
ÓÐûÓÐÌá¸ßÊä³öÓï¾äÓÅÏȼ¶µÄ·½·¨°¡£¡£¡£¡
°¡.....ÄѵÀÖ»ÄÜÕâÑùÀ²¡£¡£¡£¡£¡£
SQL code
Code highlighting produced by Actipro CodeHighli
Ïà¹ØÎÊ´ð£º
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,Ç°ÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......