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 »ù´¡½Ì³Ì,ÊéÖÐÓÐдµ½¡£ÒÔǰÎҼǵÿ´ÆäËûµÄÊéºÍÎĵµÊ±Ò²Ëƺõ¿´µ½¹ýÓÃÕâЩ±í¾ÙÀý²Ù×÷µÄ£¬ËùÒÔÎÒÒÉ»ó¡£
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£
ûÓÐORACLE ERPµÄ¾Ñé,ÓÐÓÃÓѺÍTIPTOP¾Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
table1:
uID uName
1 СÀî
2 СÕÅ
table2:
pID uID type
1 1 H1
2   ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......