OracleÁÙʱ±í ÓÅ»¯²éѯËÙ¶È
OracleÁÙʱ±í ÓÅ»¯²éѯËÙ¶È
1¡¢Ç°ÑÔ
Ä¿Ç°ËùÓÐʹÓÃOracle×÷ΪÊý¾Ý¿âÖ§³Åƽ̨µÄÓ¦Ó㬴󲿷ÖÊý¾ÝÁ¿±È½ÏÅÓ´óµÄϵͳ£¬¼´±íµÄÊý¾ÝÁ¿Ò»°ãÇé¿ö϶¼ÊÇÔÚ°ÙÍò¼¶ÒÔÉϵÄÊý¾ÝÁ¿¡£
µ±È»ÔÚOracleÖд´½¨·ÖÇøÊÇÒ»ÖÖ²»´íµÄÑ¡Ôñ£¬µ«Êǵ±Äã·¢ÏÖÄãµÄÓ¦ÓÃÓжàÕűí¹ØÁªµÄʱºò£¬²¢ÇÒÕâЩ±í´ó²¿·Ö¶¼ÊDZȽÏÅӴ󣬶øÄã¹ØÁªµÄʱºò·¢ÏÖÆäÖеÄijһÕÅ»òÕßij¼¸Õűí¹ØÁªÖ®ºóµÃµ½µÄ½á¹û¼¯·Ç³£Ð¡²¢ÇÒ²éѯµÃµ½Õâ¸ö½á¹û¼¯µÄËٶȷdz£¿ì£¬ÄÇôÕâ¸öʱºòÎÒ¿¼ÂÇÔÚOracleÖд´½¨“ÁÙʱ±í”¡£
ÎÒ¶ÔÁÙʱ±íµÄÀí½â£ºÔÚOracleÖд´½¨Ò»ÕÅ±í£¬Õâ¸ö±í²»ÓÃÓÚÆäËûµÄʲô¹¦ÄÜ£¬Ö÷ÒªÓÃÓÚ×Ô¼ºµÄÈí¼þϵͳһЩÌØÓй¦ÄܲÅÓõģ¬¶øµ±ÄãÓÃÍêÖ®ºó±íÖеÄÊý¾Ý¾ÍûÓÃÁË¡£OracleµÄÁÙʱ±í´´½¨Ö®ºó»ù±¾²»Õ¼Óñí¿Õ¼ä£¬Èç¹ûÄãûÓÐÖ¸¶¨ÁÙʱ±í£¨°üÀ¨ÁÙʱ±íµÄË÷Òý£©´æ·ÅµÄ±í¿ÕµÄʱºò£¬Äã²åÈëµ½ÁÙʱ±íµÄÊý¾ÝÊÇ´æ·ÅÔÚORACLEϵͳµÄÁÙʱ±í¿Õ¼äÖУ¨TEMP£©¡£
2¡¢ÁÙʱ±íµÄ´´½¨
´´½¨OracleÁÙʱ±í£¬¿ÉÒÔÓÐÁ½ÖÖÀàÐ͵ÄÁÙʱ±í£º»á»°¼¶µÄÁÙʱ±íºÍÊÂÎñ¼¶µÄÁÙʱ±í¡£
1£©»á»°¼¶µÄÁÙʱ±íÒòΪÕâÕâ¸öÁÙʱ±íÖеÄÊý¾ÝºÍÄãµÄµ±Ç°»á»°ÓйØϵ£¬µ±Ä㵱ǰSESSION²»Í˳öµÄÇé¿öÏ£¬ÁÙʱ±íÖеÄÊý¾Ý¾Í»¹´æÔÚ£¬¶øµ±ÄãÍ˳öµ±Ç°SESSIONµÄʱºò£¬ÁÙʱ±íÖеÄÊý¾Ý¾ÍÈ«²¿Ã»ÓÐÁË£¬µ±È»Õâ¸öʱºòÄãÈç¹ûÒÔÁíÍâÒ»¸öSESSIONµÇ½µÄʱºòÊÇ¿´²»µ½ÁíÍâÒ»¸öSESSIONÖвåÈëµ½ÁÙʱ±íÖеÄÊý¾ÝµÄ¡£¼´Á½¸ö²»Í¬µÄSESSIONËù²åÈëµÄÊý¾ÝÊÇ»¥²»Ïà¸ÉµÄ¡£µ±Ä³Ò»¸öSESSIONÍ˳öÖ®ºóÁÙʱ±íÖеÄÊý¾Ý¾Í±»½Ø¶Ï£¨truncate table£¬¼´Êý¾ÝÇå¿Õ£©ÁË¡£»á»°¼¶µÄÁÙʱ±í´´½¨·½·¨£ºCreate Global Temporary Table Table_Name(Col1 Type1,Col2 Type2...) On Commit Preserve Rows£»¾ÙÀýcreate global temporary table Student(Stu_id Number(5),Class_id Number(5),Stu_Name Varchar2(8),Stu_Memo varchar2(200)) on Commit Preserve Rows ;
2£©ÊÂÎñ¼¶ÁÙʱ±íÊÇÖ¸¸ÃÁÙʱ±íÓëÊÂÎñÏà¹Ø£¬µ±½øÐÐÊÂÎñÌá½»»òÕßÊÂÎñ»Ø¹öµÄʱºò£¬ÁÙʱ±íÖеÄÊý¾Ý½«×ÔÐб»½Ø¶Ï£¬ÆäËûµÄÄÚÈݺͻỰ¼¶µÄÁÙʱ±íµÄÒ»Ö£¨°üÀ¨Í˳öSESSIONµÄʱºò£¬ÊÂÎñ¼¶µÄÁÙʱ±íÒ²»á±»×Ô¶¯½Ø¶Ï£©¡£ÊÂÎñ¼¶ÁÙʱ±íµÄ´´½¨·½·¨£ºCreate Global Temporary Table Table_Name(Col1 Type1,Col2 Type2...) On Commit Delete Rows£»¾ÙÀý£ºcreate global temporary table Classes(Class_id Number(5),Class_Name Varchar2(8),Clas
Ïà¹ØÎĵµ£º
֮ǰÏîÄ¿ÓÐÓõ½µÄһЩµ¼ÈëºÍµ¼³ö£¬Ê±ÖÁÒѾÃÕûÀíһϣ¬×ö¸ö¼ÇºÅ
µ¼ÈëÎļþ£º
1. ÔÚij·¾¶ÏÂд¿ØÖÆÎļþ e:\testRegionControl.ctl £º
load data
infile e:\region.txt
truncate into table region
fields terminated by X'09'
TRAILING NULLCOLS
(
PPCC_ID&nbs ......
exp document/document2009@document owner=document rows=y compress=y buffer=65536 feedback=100000 file=D:\document.dmp log=D:\document.log
exp whd/whd2009@whddb owner=whd rows=y compress=y buffer=65536 feedback=100000 file=D:\whd.dmp log=D:\whd.log
imp document/document2009@document fromuser=docume ......
Oracleѧϰ±Ê¼ÇÈý·½°¸
——ͨ¹ýÓëSqlServer¶Ô±Èѧϰ
·½°¸£¨schema£©
ÔÚOracleÖУ¬ÎÒÃÇ¿ÉÒÔ¶ÔÊý¾Ý¿â¶ÔÏó·Ö×飬Õâ¾ÍÊÇ·½°¸£¨schema£©£¬ÊÇÊý¾Ý¿â¶ÔÏóµÄ¼¯ºÏ¡£Ò»¸öÓû§Ò»°ã¶ÔÓ¦Ò»¸öschem ......
³£ÓõÄORACLE PL/SQL¹ÜÀíÃüÁî
ÊìϤORACLE¹ÜÀíµÄÒ»¶¨¶ÔÕâЩÃüÁî²»»áÄ°Éú£¬²»¹ý¶ÔÓÚÎÒÕâ¸ö¸Õ½Ó´¥ORACLE¹ÜÀíµÄÀ´Ëµ£¬»¹ÊÇÓбØÒª×öϼǼ£¬ÒÔ±ãËæʱ²é¿´¡£
Ò» µÇ¼SQLPLUS
sqlplusÓû§Ãû/ÃÜÂë@Êý¾Ý¿âʵÀýasµÇ¼½ÇÉ«;
&nbs ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......