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Óï¾äÖ´ÐÐʱ´ò¿ª£¬½áÊøÊ±¾ÍÁ¢¼´¹Ø±Õ¡£
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
......
ÒÔǰ³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
::CoInitialize(NULL);
hr=m_pConnection.Creat ......