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