pl/sql - Oracle / ¿ª·¢
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ¥ORACLE ÔÙÂýÂýÏòDBA·½Ïò·¢Õ¹ÁË£¿£¿ ÎÒ¸öÈËÈÏΪͦÓÐǰ;µÄ£¬ÎÒÀÏÆÅ×öOracle EBS¾ÍÓÃPL/SQLÄØ¡£ Èç¹ûÄãÔÚ´óÁ¬£¬È¥°£ÉÕÜͦ²»´íµÄ ¶Ô,ORACLE µÄEBS ÓÐǰ;! ÓÐǰ; Oracle¹ÙÍøÉ쵀 sqldeveloper ÍêÈ«ºº»¯ ͦ²»´íµÄ Èç¹ûÄãûÓùýPL/SQLµÄ»° ½¨ÒéÄã¾ÍÓà sqldeveloper °É ÆäʵÎÒÒªÇóûÄãÃÇ˵µÄÄÇô¸ß£¬ÎÒÖ»ÒªÇóÒÔºóÈ¥±ðµÄÖÐС³ÇÊУ¬Ò²ÄÜÕÒµ½ÀàËÆµÄ¸Úλ ²»ÏñÎÒ±ÏÒµµÄʱºò×öFRAME COBOL£¬Á½ÄêÁ˵½±ðµÄµØ·½È¥ÕÒCOBOLÖ°Òµ£¬³ýÁËIBMµÄһЩÍâ°ü¹«Ë¾£¬¼¸ºõûÓа¡£¡£¡£¡ÈÃÈËÐĺ®£¡£¡£¡ Á½Äê¾ÑéÕÒ¸öCOBOL¹¤×÷·ÑÁ¦ÆøµÄ¡£¡£¡£ËùÒÔÎÒÏÖÔÚµÄÒªÇó¾ÍÊÇORACLE¿ª·¢ÊDz»ÊÇÔڴ󲿷ֳÇÊж¼ÊÇÓÐÐèÇóµÄ£¿£¿£¿ÒýÓà ÆäʵÎÒÒªÇóûÄãÃÇ˵µÄÄÇô¸ß£¬ÎÒÖ»ÒªÇóÒÔºóÈ¥±ðµÄÖÐС³ÇÊУ¬Ò²ÄÜÕÒµ½ÀàËÆµÄ¸Úλ ²»ÏñÎÒ±ÏÒµµÄʱºò×öFRAME COBOL£¬Á½ÄêÁ˵½±ðµÄµØ·½È¥ÕÒCOBOLÖ°Òµ£¬³ýÁËIBMµÄһЩÍâ°ü¹«Ë¾£¬¼¸ºõûÓа¡£¡£¡£¡ÈÃÈËÐĺ®£¡£¡£¡ Á½Äê¾ÑéÕÒ¸öCOBOL¹¤×÷·ÑÁ¦ÆøµÄ¡£¡£¡£ËùÒÔÎÒÏÖÔÚµÄÒªÇó¾ÍÊÇORACLE¿ª·¢ÊDz»ÊÇÔڴ󲿷ֳÇÊж¼ÊÇÓÐÐèÇóµÄ£¿£¿£¿ ÏëÒª´ó²¿·Ö³ÇÊж¼ÓÐÐèÇó£¬ÄãÒª¿¼ÂÇ×öjava»òÕßÓÎÏ·¶¯»ÁË¡£¡£¡£ plsql?½ö½ö»áplsqlÄÜ×öʲô£¿ÏëרÃÅ×öÊý¾Ý¿âÄ¿±êÖÁÉÙÊÇDBA¡£ÒýÓà ÆäʵÎÒÒªÇóûÄãÃÇ˵µÄÄÇô¸ß£¬ÎÒÖ»ÒªÇóÒÔºóÈ¥±ðµÄÖÐС³ÇÊУ¬Ò²ÄÜÕÒµ½ÀàËÆµÄ¸Úλ ²»ÏñÎÒ±ÏÒµµÄʱºò×öFRAME COBOL£¬Á½ÄêÁ˵½±ðµÄµ
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â ´óÖÂÈçÏ ½¨Á¢ÁÙʱ±í ¶¨ÒåÔ±¹¤Óαê Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾) ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý select ²¿ÃÅ,ÐÕÃû from tb ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ XML code: <folder state="unchecked" label="È«²¿"> ¡¡¡¡ <folder state="unchecked&qu ......