Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : Oracle

ORACLE Êý¾Ý¿â·ÖÀë - Oracle / »ù´¡ºÍ¹ÜÀí

ÏÖÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏ£¬ÓÐ3¸öÓû§£¬·Ö±ðÓÃÓÚ²»Í¨µÄϵͳ£¬ÏÖÔÚÎÒÐèÒª°ÑÕâÈý¸öϵͳµÄÊý¾Ý¿â·ÖÀ뿪À´£¬×°ÔÚ²»Í¬µÄ·þÎñÆ÷ÉÏ¡£ÓÐŪ¹ýµÄÅóÓÑÇë¸øµãÒâ¼û¡£
²»Í¬ÏµÍ³Ö®¼äÓÐÁªÏµ?

ûÓÐÁªÏµµÄ

exp, imp

ÎÒÒª°ÑÆäÖеÄÁ½¸ö·Åµ½ÁíÍâµÄ·þÎñÆ÷ÉÏ£¬Í¬Ê±°ÑÊý¾ÝʲôµÄ¶¼²»Òª£¬Ï£ÍûÄܹ»Ìá¸ß·þÎñÆ÷ÐÔÄÜ¡£

ûŪ¶®Ê²Ã´Òâ˼°¡

ÆäËûÒª ......

oracle²éѯ½¨±íʧ°Ü

ÓÃORACLE½¨±äµÄ²éѯºÜ¿ì³ö½á¹û£¬µ«Êǽ¨±íûÓз´Ó¦£¬ÊÇÔõô»ØÊÂà«£¿
ÀýÈç
CREATE TABLE TMP_TEST1 AS
SELECT * from AAA;
Õâ¸öÓï¾äÖ´Ðв»³öÀ´£¬µ«ÊÇÖ´ÐÐ
SELECT * from AAA;
ºÜ¿ì¾ÍÄܳö½á¹û

±íAAAÊý¾ÝÁ¿´óÂð£¿

¿´¿´²úÉúºÎÖֵȴýʼþ£¿

ÒýÓÃ
ÓÃORACLE½¨±äµÄ²éѯºÜ¿ì³ö½á¹û£¬µ«Êǽ¨±íûÓз´Ó¦£¬ÊÇÔõô»ØÊÂà«£¿ ......

C#Á¬½Óoracle ÈçºÎÁ¬½ÓµÄ£¿

string ConnectionString = "Data Source=ora92;user=icdmain;password=rhicd;"; 
ÊÇÕâÑùдµÄÂð 
ÎÒÁ¬½ÓÔ¶³ÌµÄ oracleÊý¾Ý¿â Ó¦¸ÃÔõôд°¡¡£¡£
C# code:

private void Button1_Click(object sender, System.EventArgs e)
{
string ConnectionString="Data So ......

Çë½Ì ѧϰORACLEÊé¼®

ÓÐÄÄЩÊé¼®ÊÇѧϰoracle¿ª·¢±È½ÏºÃµÄÊé¼®£¿
Oracle9iHelp
Oracle10gSQLRef
Oracleר¼Ò¸ß¼¶±à³Ì

ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ£¨µÚËİ棩¡· Íõɺ ÈøÊ¦ìÓ ¸ßµÈ½ÌÓý³ö°æÉç (ÕÆÎÕ»ù´¡ÖªÊ¶ºÍ¸ÅÄî) 
È»ºóÔÙ´ÖÂÔä¯ÀÀÒ»±éOracleµÄ¹Ù·½Êֲᡣ£¨·½±ãÒÔºó²éÕÒ£¬±ÜÃâÀàËÆÓÚ¿¼ÊÔµÄʱºò£¬¸øÄã±¾ÕþÖÎÊéÒ²²»ÖªµÀ´ð°¸ÔÚµÚ¼¸Õ£¬µÚ ......

oracleËøµÄÎÊÌâ

ÈçºÎ±ÜÃâËÀËøÄØ£¬Ê¹ÓÃËøµÄÇé¿öÃ²ËÆºÜÄѱÜÃâËÀËø°É¡£
Á½¸ö»á»°Ö®¼äÓпÉÄܻᷢÉúËÀËø£¬Õâ¸öʱºòOracle¡¢ Êý¾Ý¿â»áÔÚ¾¯¸æÈÕÖ¾ÖгöÏÖ600ºÅ´íÎó¡£

oracleºÜÄѳöÏÖËÀËø£¬Ò»¸öºÜÖØÒªµÄÔ­Òò¾ÍÊÇoracleµÄ¶Áд²Ù×÷²»»¥Ïà×èÈû¡£
³ý·ÇÒµÎñÂß¼­·Ç³£¸´ÔÓ£¬Ò»°ãoracle¹ÊÕÏÖÐËÀËøµÄ¹ÊÕϲ»³¬¹ý1£¥£¬¶ø³öÏÖËÀËø99£¥µÄÇé¿öÓÖÊÇÍâ¼üδ¼ÓË÷Ò ......

oracleÊý¾Ý¿â¡¢±í¿Õ¼ä

ÎÒÊǸöoracleµÄ³õѧÕß¡£ÒòΪÒÔǰÓõÄÊÇMySQLºÍmssql£¬ËùÒÔÔÚѧoracleµÄʱºòÓеãÎóÇø¡£Ï£Íû¸ßÊÖÃǶà°ï°ïæ¡£
1.ÎÒǰ¼¸ÌìÔÚÕâÀïÌá¹ýÎÊÌ⣬¾ÍÊÇoracleµÄÓû§ÊDz»ÊÇÏ൱ÓÚsqlµÄÒ»¸öÊý¾Ý¿â£¬»Ø´ðÊǿ϶¨µÄ£¬µ«ÊÇÎÒÔÚÍøÉϲ鵽µÄ½á¹ûȴ˵oracleµÄ±í¿Õ¼äÏ൱ÓÚsqlµÄÒ»¸öÊý¾Ý¿â£¬Õâµ½µ×ʲôÊÇÕýÈ·µÄ°¡£¿
2.ÎÒ¸Õµ½ÏÖÔڵĹ«Ë¾²»³¤Ê±¼ä ......
×ܼǼÊý:1827; ×ÜÒ³Êý:305; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [70] [71] [72] [73] 74 [75] [76] [77] [78] [79]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ