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

oracleÖе÷Óôø²ÎÊýµÄ´æ´¢¹ý³Ì

create or replace procedure proc_test
( a in number, b out number )
as
begin
b:=a+1;
end    proc_test;
ÏÖÔÚÒªµ÷Óõϰ¾ÍÊÇÕâÑù
SQL> c number;
SQL>exec proc_test(1,:c);
ǧÍòҪעÒâ±ðÍüÁËдðºÅ


Ïà¹ØÎĵµ£º

oracle³£¼ûÓï¾ä(×ªÔØ)

--==================================== Ò».sqlÓï¾ä·½Ãæ ====================================================
--========================================================================================================
1.Ôö¼ÓÖ÷¼ü
   alter table TABLE_NAME add constraint KEY_NAME primary key ......

½â¾öOracleÎÞ¼àÌý´íÎó

ÔÚÓÃPL/SQL DeveloperÁ¬½ÓÊý¾Ý¿âʱ³öÏÖ
“ORA-12541:TNS:ÎÞ¼àÌý³ÌÐò”´íÎó¡£
1¡¢¼ì²élistener.logÈÕÖ¾
·¢ÏÖÏÂÃæ´íÎó£º
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-9ÔÂ -2008 10:25:26
Copyright (c) 1991, 2005, Oracle. All rights reserved.
ϵͳ²ÎÊýÎļþΪD:\oracle\product\1 ......

OracleÊý¾Ý¿âµ¼Èë±ÃºÍµ¼³ö±ÃimpdpºÍexpdp£¨1£©

OracleÊý¾Ý¿âµ¼Èë±ÃºÍµ¼³ö±ÃimpdpºÍexpdp£¨1£©
 
Oracleµ¼Èëµ¼³ö¹Ù·½¶¨Òå
 
ÈçºÎ²é¿´ImpdpºÍExpdpÃüÁ
ǰÌ᣺°²×°OracleÊý¾Ý¿â£¨µ¼Èë±ÃºÍµ¼³ö±ÃÖ»ÄÜÔÚOracleÊý¾Ý¿â·þÎñÆ÷¶ËʹÓã©¡£
Ò»¡¢             IMPDPÃüÁî
1.     ......

OracleÖ±·½Í¼µÄÏêϸ½âÎö

OracleÖ±·½Í¼½âÎö
Ò»¡¢    ºÎνֱ·½Í¼£º
Ö±·½Í¼ÊÇÒ»ÖÖͳ¼ÆÑ§ÉϵŤ¾ß£¬²¢·ÇOracleרÓС£Í¨³£ÓÃÓÚ¶Ô±»¹ÜÀí¶ÔÏóµÄij¸ö·½ÃæµÄÖÊÁ¿Çé¿ö½øÐйÜÀí£¬Í¨³£Çé¿öÏÂËü»á±íÏÖΪһÖÖ¼¸ºÎͼÐÎ±í£¬Õâ¸öͼÐαíÊǸù¾Ý´Óʵ¼Ê»·¾³ÖÐËùÊÕ¼¯À´µÄ±»¹ÜÀí¶ÔÏóij¸ö·½ÃæµÄÖÊÁ¿·Ö²¼Çé¿öµÄÊý¾ÝËù»æÖƳɵģ¬Í¨³£»á»­³ÉÒÔÊýÁ¿Îªµ×±ß£¬ÒÔÆ ......

.netÔÚweb.configÖÐÁ¬½ÓoracleÊý¾Ý¿â

1.asp.netÁ¬½Óoracle·þÎñÆ÷ÐèÒªÌí¼ÓSytem.Data.OracleClientÃüÃû¿Õ¼ä£¬½«System.Data.OracleClient.dll¼ÓÈëµ½ÏîÄ¿ÖС£
2.Á¬½ÓʱÐèÒªConnectionString×Ö·û´®£¬³öÏÖÔÚweb.configÎļþÖУ¬ÈçÏÂËùʾ£º
<connectionStrings>
   <add name="ConnectionString" connectionString="Data Source=(DESCRIPTION=( ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ