oracleµÄ×óÓÒÁ¬½Ó
¶Ô×óÁ¬½Ó¡¢ÓÒÁ¬½ÓµÄÒÉ»óµÃµ½½â¾ö¡£
ÔÚOracle PL-SQLÖУ¬×óÁ¬½ÓºÍÓÒÁ¬½ÓÒÔÈçÏ·½Ê½À´ÊµÏÖ
²é¿´ÈçÏÂÓï¾ä£º
SELECT emp_name, dept_name
FORM Employee, Department
WHERE Employee.emp_deptid(+) = Department.deptid
´ËSQLʹÓÃÁËÓÒÁ¬½Ó£¬¼´“(+)”ËùÔÚλÖõÄÁíÒ»²àΪÁ¬½ÓµÄ·½Ïò£¬ÓÒÁ¬½Ó˵Ã÷µÈºÅÓÒ²àµÄËùÓмǼ¾ù»á±»ÏÔʾ£¬ÎÞÂÛÆäÔÚ×ó²àÊÇ·ñµÃµ½Æ¥Å䣬Ҳ¾ÍÊÇ˵ÉÏÀýÖÐÎÞÂۻ᲻»á³öÏÖij¸ö²¿ÃÅûÓÐÒ»¸öÔ±¹¤µÄÇé¿ö£¬Õâ¸ö²¿ÃŵÄÃû×Ö¶¼»áÔÚ²éѯ½á¹ûÖгöÏÖ¡£
·´Ö®£º
SELECT emp_name,
dept_name
FORM Employee,Department
WHERE Employee.emp_deptid = Department.deptid(+)
ÔòÊÇ×óÁ¬½Ó£¬ÎÞÂÛÕâ¸öÔ±¹¤ÓÐûÓÐÒ»¸öÄÜÔÚDepartment±íÖеõ½Æ¥ÅäµÄ²¿Ãźţ¬Õâ¸öÔ±¹¤µÄ¼Ç¼¶¼»á±»ÏÔʾ¡£
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/MyHoliday_2008/archive/2008/10/23/3131955.aspx
Ïà¹ØÎĵµ£º
ϵÁÐÖ®Î壺ORACLE EBS ϵͳÖ÷Êý¾Ý¹ÜÀí£¨A£©
ÎïÁÏÊÇÔÚINVÄ£¿éÖж¨ÒåµÄ£¬¹©Ó¦ÉÌÊÇÔÚAPÄ£¿éÖж¨ÒåµÄ£¬¿Í»§ÊÇÔÚARÄ£¿éÖж¨ÒåµÄ
Èý¸ö³£ÓÃÖ÷Êý¾Ý£ºÎïÁÏ¡¢¹©Ó¦ÉÌÓë¿Í»§¡£ÕâÈý¸öÖ÷Êý¾Ý¶¼ÓÐÒ»¸ö¹²Í¬µÄϵͳʹÓÃÌص㣺¿ç×éÖ¯µÄÈ«¾ÖÐÔ¡£
¶ø¶ÔÓÚBOMÊý¾Ý£¬¾¡¹ÜÔÚÆóҵʵ¼Ê¹ÜÀí¹¤×÷ÖУ¬¿ÉÄܾßÓÐÒ»¶¨µÄÈ«¾ÖÐÔÌص㣨ÀýÈ粻ͬ¹¤³§Éú²úͬÑù² ......
PL/SQL
1 ¸ÅÊö
PL/SQLÊÇÒ»ÖÖ¹ý³Ì»¯±à³ÌÓïÑÔ£¬Óû§¿ÉÒÔʹÓÃPL/SQL±àд¹ý³Ì¡¢º¯Êý¡¢³ÌÐò°ü¡¢´¥·¢Æ÷²¢ÇÒ´æ´¢ÕâЩ´úÂë¡£
PL/SQL²»Çø·Ö´óСд¡£
PL/SQL·ÖΪ¼¸²¿·Ö£º
declare ¿ÉÑ¡ &nbs ......
OracleÐÔÄÜÓÅ»¯ÓëDelphi´úÂë
¸ÕѧÁ˵ãoracle·½ÃæµÄ֪ʶ£¬¸Ð¾õÒÔǰд´úÂëֻƾϲºÃд£¬ÍêȫûÓÐÉԵÓÉ£¬µ¼ÖÂÔÚÄÚÐÐÈË¿´À´£¬Ð´µÄ¶¼ÊÇÀ¬»ø´úÂ룬ÏÖÔھͰÑѧµ½µÄһЩ¶«Î÷д³öÀ´£¬Ò²ËãÊǸø¸ÕÈëÃŵÄÅóÓÑÒ»µã°ïÖú°É¡£
ÒÔÇ°£¬Ð´Êý¾Ý¿â·ÃÎÊ´úÂ룬¸Ð¾õºÜ¼òµ¥£¬²»¾ÍÊÇsqlÓï¾äÂËùÒÔʲôÓï¾ä¶¼ÊÇÕâÑùд£º
A£º
......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃü Áî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
¡¡¡¡Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
¡¡ ......
10053ʼþÊÇoracleÌṩµÄÓÃÓÚ¸ú×ÙsqlÓï¾ä³É±¾¼ÆËãµÄÄÚ²¿Ê¼þ£¬
ËüÄܼÇÔØCBOģʽÏÂoracleÓÅ»¯Æ÷ÈçºÎ¼ÆËã sql³É±¾£¬Éú³ÉÏàÓ¦µÄÖ´Ðмƻ®¡£
ÈçºÎÉèÖÃ10053ʼþ
ÉèÖñ¾sessionµÄ10053
¿ªÆô£º
Alter session set events’10053 trace name context forever[,level {1/2}]’;
¹Ø±Õ£º
Alter session set events& ......