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»ÊÇÔڴ󲿷ֳÇÊж¼ÊÇÓÐÐèÇóµÄ£¿£¿£¿
ÏëÒª´ó²¿·Ö³ÇÊж¼ÓÐÐèÇó£¬ÄãÒª¿¼ÂÇ×öjava»òÕßÓÎÏ·¶¯»ÁË¡£¡£¡£
plsql?½ö½ö»áplsqlÄÜ×öʲô£¿ÏëרÃÅ×öÊý¾Ý¿âÄ¿±êÖÁÉÙÊÇDBA¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......