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µÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
13 NO
13 YES ......