¹ØÓÚOracleÊý¾Ý¿âÁ¬½Ó³¬Ê±ÎÊÌâ
ÎҵijÌÐòÐèÒªÁ¬½ÓÁíһ̨µçÄÔÉϵÄoracle·þÎñÆ÷£¬Èç¹û·þÎñÆ÷¿ªÆô£¬Á¬½Ó²Ù×÷Ò»ÇÐÕý³£¡£
µ«ÊÇÈç¹ûoracle·þÎñÆ÷ûÓпªÆô£¬³ÌÐòÒª½«½ü20²Å·µ»ØÎÞ·¨Á¬½ÓÊý¾Ý·¡£
VC³ÌÐòͨ¹ýADO·½Ê½·ÃÎÊoracleÊý¾Ý¿â
m_pConnection->ConnectionTimeout = 10; //10Ã볬ʱ
hr = m_pConnection->Open((_bstr_t)strConnection, "", "", adConnectUnspecified);
ÉÏÃæµÄ³¬Ê±Ê±¼äÉèÖúÃÏñ²»Æð×÷Óã¬ÎÞÂ۸ijɶàÉÙ£¬³ÌÐò¶¼Òª½«½ü20²Å·µ»Ø³¬Ê±¡£
´ò¸ö¶Ïµã£¬¿´¿´Ö´ÐÐÕâ¶Î³ÌÐòû£¿
¿Ï¶¨Ö´ÐÐÁË£¬¾ÍÔÚopenÕâ¸öº¯Êý×èÈûÁ˺ܾ㬴ó¸Å15Ãë
Ïà¹ØÎÊ´ð£º
ÂÒÂë²úÉúÊÇÓÉÓÚ¼¸¸ö×Ö·û¼¯Ö®¼äת»»²»Æ¥ÅäÔì³É£¬·ÖÒÔϼ¸ÖÖÇé¿ö£º£¨×¢£º×Ö·û¼¯Ö®¼äÈç¹û²»´æÔÚ×Ó¼¯¡¢³¬¼¯¶ÔÓ¦¹ØÏµÊ±µÄÇé¿ö²»Ó迼ÂÇ£¬ÒòΪÕâÖÖÇé¿öÏÂ×Ö·û¼¯Ö®¼äת»»±Ø²úÉúÂÒÂ룩
1£©·þÎñÆ÷¶ËÊý¾Ý¿ ......
ÓÐÁ½Õűí
1.µÚÒ»ÕÅ,ÊýÁ¿°ÙÍò¼¶
id number Ö÷¼ü
name varchar(50)
2.µÚ¶þÕÅ,ÊýÁ¿1Íò¼¶
id number Ö÷¼ü
deletename varchar(50)
ÏÖÔÚµÄÎÊÌâÊÇҪдһ¸ö´æ´¢¹ý³Ì,ɾ³ýµÚÒ»ÕűíÖеÄn ......
1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?
2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......
CREATE OR REPLACE PROCEDURE proc_ct_11(
quhao in varchar
)
IS
CURSOR ct_filter
IS
SELECT br_number, br_company ......