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

Oracle ERP²ÆÎñϵͳ——¹Ì¶¨×ʲú

1 ×ʲúÀàÐÍ
×ʲúÀàÐÍ£º×ʱ¾»¯¡¢CIP¡¢·ÑÓÃÐÔ
×ʱ¾»¯£ºÊÇÖ¸ÐèÒª¼ÆËãÕ۾ɵÄ×ʲú
CIP£ºÊÇÔÚ½¨¹¤³Ì×ʲú£¬Éв»ÐèÕ۾ɣ¬´ýÆä×ʱ¾»¯Ö®ºóÔÙ¿ªÊ¼ÕÛ¾É
·ÑÓÃÐÔ£ºÊDz»¼ÆËãÕ۾ɣ¬¸Ã×ʲúµÄ³É±¾¶¼×÷Ϊ·ÑÓô¦Àí
 
2 ×ʲúÔö¼Ó
×ʲúÔö¼ÓÓÐÁ½ÖÖ·½Ê½£ºÊÖ¶¯Ôö¼Ó£¬×Ô¶¯Ôö¼Ó¡£
×Ô¶¯Ôö¼ÓÊÇÖ¸ÓÉÆäËûÄ£¿é£¨APÄ£¿é»òPAÄ£¿é£©´«µÝµ½×ʲúÄ£¿é£¬È»ºóÐγɹ̶¨×ʲú¡£
a) ×ʲú×Ô¶¯Ôö¼Ó²½Ö裨APÖÁFA£©
£¨1£©Ó¦¸¶Ä£¿é¼È뷢Ʊ£¬½«·¢Æ±·ÖÅäµ½×ʲú½áËãÕÊ»§£¨Ò»°ãÇé¿öΪ“¹Ì¶¨×ʲú-ÖÐת”Õâ¸ö¿ÆÄ¿£©£¬ÑéÖ¤·¢Æ±£¬²¢Éú³É»á¼Æ·Ö¼¡£
£¨2£©ÔËÐГӦ¸¶ÕÊ¿î¹ÜÀíϵͳ»á¼ÆºËËãÁ÷³Ì”ÇëÇ󣬽«Ó¦¸¶µÄ·¢Æ±£¨¸¶¿î£©µ¼Èë×ÜÕÊ£»
£¨3£©ÔËÐГ´´½¨³ÉÅúÔö¼Ó”ÇëÇ󣬽«Ó¦¸¶Ä£¿éµÄ×ʲú·¢Æ±µ¼Èë×ʲúÄ£¿é¡£
×¢Ò⣺½«Ó¦¸¶µÄ·¢Æ±µ¼Èë×ʲúÄ£¿éµÄÇ°ÌáÌõ¼þÖ®Ò»ÊÇÒªÉèÖúÃ×ʲúÀà±ð¡£²»Í¬µÄ×ʲúÀà±ð¿É¶ÔÓ¦²»Í¬µÄ×ʲú½áËãÕÊ»§ÓëÕ۾ɷ½·¨¡£
£¨4£©ÔÚ×ʲúÄ£¿éÖдò¿ª“×¼±¸³ÉÅúÔö¼Ó”£¬Ñ¡Ôñ´ÓÓ¦¸¶Ä£¿éÖе¼¹ýÀ´µÄ×ʲú£¬½«¶ÓÁиÄΪ“¹ýÕÊ”²¢Ìí¼ÓÏàÓ¦µÄÐÅÏ¢¡£
£¨5£©¹ýÕʳÉÅúÔö¼Ó
 ÕâÑù¾ÍÄÜ´Ó×ʲú¹¤×÷̨Öп´µ½ÐÂÔöµÄ×ʲúÁË
 
to be continue ...
 
3 ×ʲúÕÛ¾É
a£©Õ۾ɷ½·¨
¹Ì¶¨×ʲúµÄÕ۾ɷ½·¨Ò»°ãÓУº
l         ƽ¾ùÄêÏÞ·¨/Ö±Ïß·¨
l         ¹¤×÷Á¿·¨
l         Ë«±¶Óà¶îµÝ¼õ·¨
l         ÄêÊý×ܺͷ¨
¶øÔÚEBSÖУ¬Ê¹ÓõÄÕ۾ɷ½·¨ÀàÐÍΪ£ºÖ±Ïß·¨¡¢¹Ì¶¨±ÈÂÊ·¨¡¢²úÁ¿Õ۾ɷ¨¡£¾ßÌåµÄ¼ÆËã·½·¨¿É×Ô¶¨ÒåÉèÖá£
ÔÚFAÖУ¬Í¨¹ý“ÔËÐÐÕ۾ɔÀ´¼ÇÌáÕ۾ɡ£±¾ÆÚÒ»µ©ÔËÐÐÁËÕÛ¾ÉÖ®ºó£¬ÄÇôÔÚδ¹Ø±Õ±¾ÆÚ¼äµÄÇé¿öϾͲ»ÄÜÔÙ¶Ô×ʲú½øÐÐÊÂÎñ´¦ÀíÁË¡£ÈôÒª½øÐÐÊÂÎñ´¦ÀíÔòÐèÒª»Ø¹öÒÑÔËÐÐÕ۾ɡ£
±¾ÎÄת×Ô:http://blog.vsharing.com/wuxl/A562727.html
 


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

oracle online documentation

oracle 9i online documentation:
http://www.oracle.com/pls/db92/db92.docindex?remark=homepage
oracle 10g online documentation:
http://www.oracle.com/pls/db102/homepage
oracle 11g online documentation:
http://www.oracle.com/pls/db111/homepage ......

OracleÓû§È¨ÏÞ¿ØÖÆ

1£©¡¢¹¹ÔìʵÀý£º
ÎÒÃÇÒѾ­´´½¨ºÃÊý¾Ý¿âÓû§test_user£¬Ï±ߴæÔÚtest_table±íºÍtest_procedure´æ´¢¹ý³Ì¡£ÎÒÃÇÒѾ­´´½¨ºÃÒ»¸ö¿ÕµÄ´úÀíÊý¾Ý¿âÓû§agent_user¡£
2£©¡¢µÇ¼test_userÓû§£¬½«test_userϱíµÄselectȨÏ޺ʹ洢¹ý³ÌµÄexcuteȨÏÞ¸³¸ø´úÀíÓû§agent_user¡£
SQL>GRANT select ON test_table TO agent_user;
SQL ......

oracle %type

1¡¢Ê¹ÓÃ%TYPE
ÔÚÐí¶àÇé¿öÏ£¬PL/SQL±äÁ¿¿ÉÒÔÓÃÀ´´æ´¢ÔÚÊý¾Ý¿â±íÖеÄÊý¾Ý¡£ÔÚÕâÖÖÇé¿öÏ£¬±äÁ¿Ó¦¸ÃÓµÓÐÓë±íÁÐÏàͬµÄÀàÐÍ¡£ÀýÈ磬students±íµÄfirst_nameÁеÄÀàÐÍΪVARCHAR2(20),ÎÒÃÇ¿ÉÒÔ°´ÕÕÏÂÊö·½Ê½ÉùÃ÷Ò»¸ö±äÁ¿
DECLARE
v_FirstName VARCHAR2(20);
µ«ÊÇÈç¹ûfirst_nameÁеĶ¨Òå¸Ä±äÁ˻ᷢÉúʲô£¨±ÈÈç˵±í¸Ä±äÁË£¬first ......

¡¾×ª¡¿¼òµ¥ËµÒ»Ëµ Oracle¿âµÄHang

·Ç³£ÉÙµÄÇé¿öÏ£¬ÎÒÃÇ»á¸Ð¾õÎÒÃǵĿ⡱Hang¡±ÁË£¬¼ÓÁËÒþºÅµÄÒâ˼ÊÇ˵ÓÐʱÕæµÄÊÇHangÁË£¬ÓÐһЩÔò²»ÊÇ£¬ÊÇÓÉÓÚÐÔÄܵÄÎÊÌâÒýÆðµÄ¡£ÎÒÓöµ½¹ý¼¸´ÎHangµÄÇé¿ö£¬½áºÏ×ÅÍøÉÏһЩÎÄÕ£¬°Ñ¿ÉÄܵÄÔ­Òò¡¢µ±Ê±ÎÒÃÇÓ¦¸Ã×öµÄһЩ²Ù×÷½øÐÐÁËÈçϵÄ×ܽᣬ²»¶ÔµÄµØ·½´ó¼Ò¿ÉÒÔ·¢Mail¸øÎÒ:crane@storren.net ¡£
Ò»¡¢Êý¾Ý¿âHangʱ¿ÉÄܵÄÏÖÏó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ