ż±È½Ï²Ë£¬ÏëÎÊÏÂOracleÆóÒµ¹ÜÀíÆ÷ÖÐÔõÑù²éѯÊý¾Ý°¡£¿
ÎÒÔõôֻÄÜ¿´µ½±íµÄÐÅÏ¢£¬¿´²»µ½¾ßÌåÊý¾ÝÄÇ£¿×¢£ºÅ¼ÖªµÀÔõôÓÃSQLÓï¾ä²é£¬ËùÒÔÇëÖ±½Ó¸æËßÎÒÔõôÔÚÆóÒµ¹ÜÀíÆ÷Öп´µ½Êý¾Ý¡£Ð»Ð»¸÷λ°ïæ¡£
ÆóÒµ¹ÜÀíÆ÷ûÓвéѯÊý¾ÝµÄµØ·½
½¨Òé×°Ò»¸öPL/SQL DEVELOPER»òÕßTOAD£¬ºÜºÃÓÃ
µ±È»,sqlplusÒ²²»´í
ÔÚEMÀïÑ¡ÖÐÄ¿±ê±í£¬ÓҲࡰ²Ù×÷¡±À¸µÄÏÂÀ¿òÀÓС°²é¿´Êý¾Ý¡±Ñ¡ÏѡÔñÖ®£¬È»ºóµ¥»÷¡°¿ªÊ¼¡±°´Å¥£¬¼´¿É¿´¼û±íÄÚ¾ßÌåÊý¾Ý¡£
ѧϰÁË
Ôڲ鿴Êý¾ÝµÄͬʱ£¬Ò²¿ÉÊÇÉè¼Æ²éѯϸ½Ú£¬¼´¹ýÂËÌõ¼þ¡£°´ÕÕÒ³ÃæÌáʾÀ´×ö¡£
oracleÀïÃæÃ»ÓÐÆóÒµ¹ÜÀíÆ÷°É£¬ÄãÔÚplsqlÀïÃæ¿ÉÒÔÓÃsql²éѯÓï¾ä¿´µ½µÄ¡£
»òÕßÔÙsqlplusÒ²¿ÉÒÔ¿´µ½µÄ¡£
2Â¥µÄ£¬Ê×ÏȸÐлÄãµÄ»Ø´ð¡£²»¹ýÎÒûÕÒµ½Å¶¡£ÎÒÓõÄÊÇ9I¡£
¶÷£¬ÎÒÒÔΪÄãÖ¸µÄÊÇ10g¡£
9iÔÚ±íÉϵãÓÒ¼ü£¬ºÃÏóÓиöʲô¡°ä¯ÀÀĿ¼ÄÚÈÝ¡±Ê²Ã´µÄÑ¡Ïî¡£ºÜ¾Ã²»ÓÃ9iÒÔ¼°ORACLEÆóÒµ¹ÜÀíÆ÷ÁË£¬Ó¡ÏóÄ£ºý¡£Äã×ÐϸÕÒÕÒÓÒ¼ü²Ëµ¥¡£
9iµÄÕâ¸öÕæÃ»ÓС£¡£¡£
ÎÞÂÛ9i»¹ÊÇ10g£¬ÆóÒµ¹ÜÀíÆ÷Àï¶¼¿ÉÒÔÖ±½Óä¯ÀÀ±íÊý¾Ý¡£
²»ÖªµÀÊDz»ÊÇÎÒÌ«±¿ÁË£¬Ã»ÓÐÕÒµ½¡£
Ī·ÇÕæµÄûÓÐÂð£¿
ºÇºÇ£¬ÎÒÔø¾ÓÃËü²é¿´¹ý±íÊý¾Ý¡£¸æËßÎÒQ£¬Ô¶³ÌÐÖú£¬³ý·ÇÄã½øµÄ²»ÊÇÆóÒµ¹ÜÀíÆ÷¡£
9iÔÚÆóÒµ¹ÜÀíÖÐÓÒ¼ü±íÃû³Æ£¬Óиö¡°±íÊý¾Ý±à¼Æ÷¡±ÀïÃæÓжÔÓ¦µÄÊý¾Ý~~~
ллsuiziguo£¬tianyihuyidao30£¬ÔÚÄãÃǵİïÖúÏÂÎÒÖÕÓÚÕÒµ½ÁË£¬ÔÚ9IÀïÓ¦¸ÃÊÇÓÒ¼ü²é¿´¡¢±à¼Ä¿Â¼¡£
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
ÏÖÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏ£¬ÓÐ3¸öÓû§£¬·Ö±ðÓÃÓÚ²»Í¨µÄϵͳ£¬ÏÖÔÚÎÒÐèÒª°ÑÕâÈý¸öϵͳµÄÊý¾Ý¿â·ÖÀ뿪À´£¬×°ÔÚ²»Í¬µÄ·þÎñÆ÷ÉÏ¡£ÓÐŪ¹ýµÄÅóÓÑÇë¸øµãÒâ¼û¡£
²»Í¬ÏµÍ³Ö®¼äÓÐÁªÏµ?
ûÓÐÁªÏµµÄ
exp, imp
ÎÒÒª°ÑÆäÖеÄÁ½ ......