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

ORACLE´æ´¢¹ý³ÌµÄÎÊÌâ

´æ´¢¹ý³ÌÖеİٷֺűíʾʲôÒâ˼£¿±ÈÈç˵while  csor_company%found  loop  Äǰٷֺűíʾʲô£¿
%found  Ã²ËÆ ¶¼ÊÇÁ¬ÆðÀ´¿´µÄ      %notfound

while  csor_company%found  loop 
fetch ... into ..
end loop;

%Ç°ÃæÊÇÓαꡣµ±ÓαêÖл¹ÓÐÉÐδ±éÀúºÍfetchµÄ¼Ç¼µÄʱºò£¬Ñ­»·
¶ÔÓ¦%notfound
loop
fetch cur1 into a;
...
exit when cur1%notfound;
end;

SQL%FOUNDºÍSQL%NOTFOUND

    ÔÚÖ´ÐÐÈκÎDMLÓï¾äǰSQL%FOUNDºÍSQL%NOTFOUNDµÄÖµ¶¼ÊÇNULL,ÔÚÖ´ÐÐDMLÓï¾äºó£¬SQL%FOUNDµÄÊôÐÔÖµ½«ÊÇ£º



. TRUE :INSERT

. TRUE :DELETEºÍUPDATE£¬ÖÁÉÙÓÐÒ»Ðб»DELETE»òUPDATE.

. TRUE :SELECT INTOÖÁÉÙ·µ»ØÒ»ÐÐ

µ±SQL%FOUNDΪTRUEʱ,SQL%NOTFOUNDΪFALSE¡£



SQL%ROWCOUNT

  ÔÚÖ´ÐÐÈκÎDMLÓï¾ä֮ǰ£¬SQL%ROWCOUNTµÄÖµ¶¼ÊÇNULL,¶ÔÓÚSELECT            INTOÓï¾ä£¬Èç¹ûÖ´Ðгɹ¦£¬SQL%ROWCOUNTµÄֵΪ1,Èç¹ûûÓгɹ¦£¬SQL%ROWCOUNTµÄֵΪ0£¬Í¬Ê±²úÉúÒ»¸öÒì³£NO_DATA_FOUND.



SQL%ISOPEN

  SQL%ISOPENÊÇÒ»¸ö²¼¶ûÖµ£¬Èç¹ûÓαê´ò¿ª£¬ÔòΪTRUE, Èç¹ûÓÎ±ê¹Ø±Õ£¬ÔòΪFALSE.¶ÔÓÚÒþʽÓÎ±ê¶øÑÔSQL%ISOPEN×ÜÊÇFALSE£¬ÕâÊÇÒòΪÒþʽÓαêÔÚDMLÓï¾äÖ´ÐÐʱ´ò¿ª£¬½áÊøÊ±¾ÍÁ¢¼´¹Ø±Õ¡£ 


Ïà¹ØÎÊ´ð£º

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......

oracleÈëÃÅÅäÖÃ

oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
  (SID_LIST =
  ......

adoÁ¬½ÓoracleµÄ¹ÖÎÊÌâ

ÒÔǰ³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
        ::CoInitialize(NULL);
        hr=m_pConnection.Creat ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ