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

oracleµ¼ÈëÊý¾Ý¿âÐÅÏ¢²»ÍêÕû

ÓõÄÊÇplsql,ÔÚµ¼Èë±íµÄʱºòÓÐ3ÖÖÑ¡Ôñ·½Ê½£¬ÎÒÒ»°ãÑ¡ÔñplsqlµÄÄǸö£¬¿ÉÊÇÔÚ½«µ¼Èë·þÎñÆ÷ÖеIJ¿·Ö±íµ¼Èëµ½±¾µØµÄʱºò£¬
ÎÞÂÛÑ¡Ôñ3ÖÖ·½Ê½ÖеÄÈκÎÒ»ÖÖ£¬¶¼²»³É¹¦¡£ÓÃplsqlµÄÄÇÖÖ£¬ËµÊDZí»òÕßÊÓͼ£¬±í¿Õ¼ä²»´æÔÚ¡£ÎÒ²»ÏëÒªÕâÐ©Ô¼Êø£¬Ö»Òªµ¼Èë±í½á¹¹ºÍÊý¾Ý¾Í¿ÉÒÔÁË¡£¸ÃÔõô°ì£¿
ÎÒÒ»°ãÓÃoracle Import,²»¹ýµÃ¿´Äãµ¼³öµÄÊÇʲôÎļþ£¬Èç¹ûÊÇsqlÎĵϰ£¬¾ÍµÃÓÃsql inserts

ûÓùýplsqlµÄµ¼È룬µ«ÏëÏñÖÐÓ¦¸Ã¿ÉÒÔÏñimpÄÇÑùÉèÖòÎÊýµÄ£¬±ÈÈçcontains = N

Ç¿ÁÒÖ§³Ö£¡


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ