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¡£
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......