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

oracleϵͳ×Ô´øµÄÁ·Ï°±íÓÐÄÄЩ£¬ÔõÑùÕÒ£¿

£¨1£©ÎÒ´ÓORACLEµÄÊéÉÏ¿´£¬ËµoracleÑù±¾Êý¾Ý¿âÖÐÓÐcustomers¡¢products¡¢salesºÍcostsÕâЩ±í¡£¿ÉÊÇÎÒÔÚÎÒµÄÊý¾Ý¿âÖÐÓÃ
¡°select * from tab;¡±ÕÒ²»µ½ÕâЩ±í°¡£¬ÇëÎÊÕâЩ±íÊÇÔÚÄĸöÕË»§Ï£¬Ôõô²ÅÄܵ÷Óõ½ÕâЩÁ·Ï°±íÄØ£¿ÎҵݲװµÄÊý¾Ý¿âÊÇ
oracle 10g 10.2.0 ×Ô½¨µÄÊý¾Ý¿âÃûÊÇ "demo"¡£
£¨2£©»¹ÓÐÎҴӱ𴦿´µ½ËµÊÇÔÚÊý¾Ý¿âÀïÓС°HR¡±Õâ¸öÓû§£¬¿ÉÊÇÎÒÔÚsysÏÂÓá° select username from all_users;¡±ÕâÌõÃüÁîûÓÐÕÒµ½Õâ¸öÓû§°¡£¬ÇëÎÊÕâ¸öÓû§ÊÇϵͳ×Ô´øµÄ»¹ÊǺó×Ô½¨µÄ°¡£¿
ÕâÎÒҲͷһ´ÎÌý˵¡£¡£¡£
µ«ÊDz»Ò»¶¨ÒªÓÃËû×Ô´øµÄ±í °¡   
×Ô¼ºËæ±ã½¨  µ½Ê±ºòɾ³ý¾ÍÊÇÁËÂï¡£

scottÓû§Ïµıí.Â¥Ö÷ÓÃÕâ¸öÓû§¾ÍÄܲ鵽ÁË.

ÔÚ°²×°Êý¾Ý¿âµÄ¹ý³ÌÖÐÓÐÈÃÄãÑ¡ÔñÊÇ·ñ°²×°Ò»Ð©Ê¾ÀýÓû§µÄ
Èç¹ûÄãûÓÐÑ¡ÔñHR  ¾ÍûÓÐà¶

»Ø¸´2Â¥£º
¶÷£¬ÎÒÊÔ¹ýÁË£¬Ã»ÓÐÄÇЩ±í
ÕâЩ±í£¬ÊDz»ÊÇÔÚ×°Êý¾Ý¿âµÄʱºòÓëËùÑ¡ÔñµÄÊý¾Ý¿âÄ£°åÓйØÄØ£¿ÎҼǵÃÎÒÑ¡ÔñµÄÊÇÊÂÎï´¦ÀíÀàÐÍ£¬²¢ÇÒÎÒ×°µÄÊÇÆóÒµ°æ¡£

»Ø¸´3Â¥£º
àÞ£¬ÓÐÕâ¸ö¹ý³ÌÂð£¿ÎÒ²»¼ÇµÃÁË£¬ºÇºÇ  ѧϰÁË 

ÓÃscottϵĠ emp¡¢dept ²î²»¶àÁË

ʲôÊ飿Oracle 9i²Î¿¼Êֲ᣿Oracle 10G²Î¿¼Êֲ᣿

»Ø¸´6Â¥£º
ºÇºÇ£¬Êǰ¡ Èç¹ûÄÜÕÒµ½¸üºÃ£¬ÕÒ²»µ½ÄÇЩ±íÒ²²»Ó°ÏìÁ·Ï°£¬ÎÒÖ»ÊÇÏëÖªµÀÄÇЩ±íµ½µ×ÓÐûÓУ¬´æÔÚÄÄ£¿

»Ø¸´7Â¥£º
ÎÒÏÖÔÚÔÚ¿´ Oracle Database 10g »ù´¡½Ì³Ì,ÊéÖÐÓÐдµ½¡£ÒÔǰÎҼǵÿ´ÆäËûµÄÊéºÍÎĵµÊ±Ò²Ëƺõ¿´µ½¹ýÓÃÕâЩ±í¾ÙÀý²Ù×÷µÄ£¬ËùÒÔÎÒÒÉ»ó¡£

ÒýÓÃ
»Ø¸´7Â¥£º
ÎÒÏÖÔÚÔÚ¿´ Oracle Database 10g »ù´¡½Ì³Ì,ÊéÖÐÓÐдµ½¡£ÒÔǰÎҼǵÿ´ÆäËûµ


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

¼±Ñ°Oracle ERPʵʩ¹ËÎÊ

3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾­Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£

ûÓÐORACLE ERPµÄ¾­Ñé,ÓÐÓÃÓѺÍTIPTOP¾­Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

ÇóÒ»Ìõoracle¶à±í²éѯµÄsql£¬Çó¸ßÊÖÃDz»ÁߴͽÌ~

table1:
uID    uName
1      СÀî 
2      СÕÅ

table2:
pID  uID  type
1    1    H1
2    ......

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ