Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎÊ´ð£º

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

linuxÏÂCÓïÑÔ¿ª·¢oracleµÄÎÊÌâ¡£

Á½¸öÎļþ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 - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,Ç°ÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ