oracleµ¼ÈëÊý¾Ý¿âÐÅÏ¢²»ÍêÕû
ÓõÄÊÇplsql,ÔÚµ¼Èë±íµÄʱºòÓÐ3ÖÖÑ¡Ôñ·½Ê½£¬ÎÒÒ»°ãÑ¡ÔñplsqlµÄÄǸö£¬¿ÉÊÇÔÚ½«µ¼Èë·þÎñÆ÷ÖеIJ¿·Ö±íµ¼Èëµ½±¾µØµÄʱºò£¬
ÎÞÂÛÑ¡Ôñ3ÖÖ·½Ê½ÖеÄÈκÎÒ»ÖÖ£¬¶¼²»³É¹¦¡£ÓÃplsqlµÄÄÇÖÖ£¬ËµÊDZí»òÕßÊÓͼ£¬±í¿Õ¼ä²»´æÔÚ¡£ÎÒ²»ÏëÒªÕâÐ©Ô¼Êø£¬Ö»Òªµ¼Èë±í½á¹¹ºÍÊý¾Ý¾Í¿ÉÒÔÁË¡£¸ÃÔõô°ì£¿
ÎÒÒ»°ãÓÃoracle Import,²»¹ýµÃ¿´Äãµ¼³öµÄÊÇʲôÎļþ£¬Èç¹ûÊÇsqlÎĵϰ£¬¾ÍµÃÓÃsql inserts
ûÓùýplsqlµÄµ¼È룬µ«ÏëÏñÖÐÓ¦¸Ã¿ÉÒÔÏñimpÄÇÑùÉèÖòÎÊýµÄ£¬±ÈÈçcontains = N
Ç¿ÁÒÖ§³Ö£¡
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´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,dnam ......
Á½¸ö±í
Çë¿´ "Persons" ±í£º
name banji shunxu
yiyang 01 1
yiyang 02 1
lili 01 2
½ÓÏÂÀ´Çë¿´ "xueke" ±í£º
name kemu shunxu
yiy ......