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

¹ØÓÚ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Ãë


Ïà¹ØÎÊ´ð£º

OracleÎÊ´ðÌâ,´ð¶ÔÓзÖ,²»¶ÔÓйÄÀø·Ö

ÂÒÂë²úÉúÊÇÓÉÓÚ¼¸¸ö×Ö·û¼¯Ö®¼äת»»²»Æ¥ÅäÔì³É£¬·ÖÒÔϼ¸ÖÖÇé¿ö£º£¨×¢£º×Ö·û¼¯Ö®¼äÈç¹û²»´æÔÚ×Ó¼¯¡¢³¬¼¯¶ÔÓ¦¹ØÏµÊ±µÄÇé¿ö²»Ó迼ÂÇ£¬ÒòΪÕâÖÖÇé¿öÏÂ×Ö·û¼¯Ö®¼äת»»±Ø²úÉúÂÒÂ룩

    1£©·þÎñÆ÷¶ËÊý¾Ý¿ ......

oracle procedure ʵ¼Ê¿ª·¢Óöµ½µÄÎÊÌâ

ÓÐÁ½Õűí
1.µÚÒ»ÕÅ,ÊýÁ¿°ÙÍò¼¶
id  number Ö÷¼ü
name varchar(50)
2.µÚ¶þÕÅ,ÊýÁ¿1Íò¼¶
id number Ö÷¼ü
deletename varchar(50)


ÏÖÔÚµÄÎÊÌâÊÇҪдһ¸ö´æ´¢¹ý³Ì,ɾ³ýµÚÒ»ÕűíÖеÄn ......

OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......

OracleתÒå·ûºÅ

CREATE OR REPLACE PROCEDURE proc_ct_11(
  quhao in varchar
)
IS
  CURSOR ct_filter
  IS
      SELECT        br_number, br_company ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ