OracleÖбíµÄ¹éÊôÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
OracleÖУ¬ÔÚsqlplusÖÐÓÃij¸öÓû§µÇÈëºó£¬È»ºóÔÚ´´½¨Ò»¸ö±í £¬Õâ¸ö±íÊDz»ÊǾÍÊôÓÚÕâ¸öÓû§£¿
Êǵġ£Ö»ÒªÄã²»´øschemaǰ׺µÄ»°
e.g. create table abc(...)£¬ÄÇÕâ¸öabc¾ÍÊôÓÚµ±Ç°Óû§¡£
Èç¹ûÓÐÁ˺ÏÊʵÄȨÏÞÖ®ºó£¬µ±Ç°Óû§Îªscott£¬ËüÓÐȨÏÞÔÚnajiutanÏ´´½¨±í
create table najiutan.abc(...)£¬ÄÇô¸Ã±íÈÔÈ»ÊôÓÚnajiutan¡£
¿ÉÒÔÕâôÈÏΪ
Êǵģ¬ÊÇÕâÑùµÄ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£»
......