ÔÚoracleÖÐÁÙʱ±íµÄÖÖÀà
ÁÙʱ±íµÄ¸ÅÄ
ÔÚOracleÊý¾Ý¿âÖл¹ÓÐÒ»ÖÖÀàÐÍµÄ±í£¬½Ð×öÁÙʱ±í¡£Õâ¸öÁÙʱ±í¸úÓÀ¾Ã±í×î´óµÄÇø±ð¾ÍÊDZíÖеÄÊý¾Ý²»»áÓÀÔ¶µÄ´æÔÚ¡£µ±Ò»¸ö»á»°½áÊø»òÕßÊÂÎñ½áÊøµÄʱºò£¬Õâ¸öÁÙʱ±íÖеÄÊý¾Ý£¬²»ÓÃÓû§×Ô¼ºÉ¾³ý£¬Êý¾Ý¿â×Ô¼º»á×Ô¶¯Çå³ý¡££¨±íÊÇÈ«¾Ö£¬Ö»ÊÇÊý¾ÝÏûʧ£©
OracleÊý¾Ý¿â¸ù¾ÝÁÙʱ±íµÄÐÔÖʲ»Í¬£¬¿ÉÒÔ·ÖΪÊÂÎñÁÙʱ±íÓë»á»°ÁÙʱ±í¡£ÊÂÎñÁÙʱ±íÊÇÖ¸Êý¾ÝÖ»ÓÐÔÚµ±Ç°ÊÂÎñÄÚÓÐЧ¡£Ò»°ãÇé¿öÏ£¬Èç¹ûÔÚ´´½¨Êý¾Ý±íµÄʱºò£¬Ã»ÓÐÌØÊâÖ¸Ã÷Õâ±íÊǻỰÁÙʱ±íµÄ»°£¬Ôò¸Ã±íĬÈÏΪÊÂÎñÁÙʱ±í¡£
ÊÂÎñÁÙʱ±í£º
Create global temporary table Temp_user
¡¡¡¡(ID NUMBER(12) Primary key,name varchar2(10)) ON COMMIT DELETE ROWS
;
»á»°ÁÙʱ±í£º
CREATE GLOBAL TEMPOPARY TABLE TEMP_USER
¡¡¡¡(ID NUMBER(12) Primary key,name varchar2(10))
¡¡¡¡ON COMMIT PRESERVE ROWS
;
¡¡¡¡Ò²¾ÍÊÇ˵£¬»á»°ÁÙʱ±í¸úÊÂÎñÁÙʱ±íµÄ´´½¨Óï·¨´óÖÂÏàͬ£¬Ö»ÓÐ×îºóµÄ¹Ø¼ü×ÖÓÐÇø±ð
¡£²»¹ýÁ½¸ö±íËäÈ»ÀàËÆ£¬µ«ÊÇÆäÄÚ²¿µÄ´¦Àí»úÖÆ»¹ÊÇÓбȽϴóµÄÇø±ð¡£
Çø±ð£ºÊÂÎñÁÙʱ±í£¬ÔÚÌá½»ÊÂÎñºó£¬±íÖеÄÊý¾Ý¾ÍÏûʧÁË£¬µ«ÊǻỰÁÙʱ±í²»»á£¡~
»á»°ÁÙʱ±í£¬Ìá½»ÊÂÎñºó£¬ÒÀ¾ÉÄܲéѯ£¬µ«ÊǹرÕÊý¾Ýºó£¬ÖØÐÂÁ¬½Óʱ£¬±íÖеÄÊý¾Ý²Å»áÏûʧ£¡~
´ÓÒÔÉϵķÖÎöÎÒÃÇ¿ÉÒÔ¿´ÖУ¬»á»°ÁÙʱ±íÓëÊÂÎñÁÙʱ±íÖ÷ÒªµÄ²îÒì¾ÍÔÚÓÚɾ³ýÊý¾Ýʱ»úµÄ²»Í¬¡£ÊÂÎñÐÔÁÙʱ±íÊÇÔÚÊÂÎñÌá½»µÄʱºòÇå³ýÊý¾Ý£¬¶ø»á»°ÐÔÁÙʱ±íÔòÊÇÔڹرյ±Ç°»á»°µÄʱºòÇå³ýÁÙʱ±í¡£Ö»Òªµ±Ç°»á»°Ã»Óйرգ¬¼´Ê¹ÊÂÎñÍê³ÉÁË£¬»á»°ÁÙʱ±íÖеÄÊý¾ÝÈÔÈ»´æÔÚ£¬²»»á±»Çå³ý¡£
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
À俽±¸ÁËÒ»¸öÔÓÐÊý¾Ý¿â£¬Òª°ÑËûÒÆÖ²µ½ÐµÄÊý¾Ý¿âÖÐʱ£¬Òª×¢Òâһϣº
1.Oradim -new -sid [ʵÀýÃû:demo] -intpwd [PWD] -pfile= [Òª´´½¨ÊµÀýµÄÅäÖÃÎļþ£º*.ora]
2.set Oracle_SID=[ʵÀýÃû]£¨×°Íêºó¼ÇµÃÒªÔÚ×¢²á±íÀï¼ÓÉÏ:HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1£ºORACLE_SID£¬ÖµÎªÊµÀýÃû¡££©
3.sql ......
create table test1 as select 1 id,'create table test2(id number,name varchar2(200));insert into test2 values(1,''a'');' sqltext from dual
2 union all select 2,'truncate table test2;' from dual
3 union all select 3,'insert into test2 select rownum,dbms_random.string(''l'', ......
row_number() OVER (PARTITION BY COL1 ORDER BY COL2) ±íʾ¸ù¾ÝCOL1·Ö×飬ÔÚ·Ö×éÄÚ²¿¸ù¾Ý COL2ÅÅÐò£¬¶ø´Ëº¯Êý¼ÆËãµÄÖµ¾Í±íʾÿ×éÄÚ²¿ÅÅÐòºóµÄ˳Ðò±àºÅ£¨×éÄÚÁ¬ÐøµÄΨһµÄ).
ÓërownumµÄÇø±ðÔÚÓÚ£ºÊ¹ÓÃrownum½øÐÐÅÅÐòµÄʱºòÊÇÏȶԽá¹û¼¯¼ÓÈëαÁÐrownumÈ»ºóÔÙ½øÐÐÅÅÐò£¬¶ø´Ëº¯ÊýÔÚ°üº¬ÅÅÐò´Ó¾äºóÊÇÏÈÅÅÐòÔÙ¼ÆËãÐкÅ ......