µãµãµÎµÎ(Oracle)
insert into
select * into t_dest from t_src; -- ÒªÇóÄ¿±ê±í²»´æÔÚ
insert into t_dest(a, b) select a, b from t_src; -- ÒªÇóÄ¿±ê±íÒÑ´æÔÚ
¶¯Ì¬SQL
execute immediate 'select ' || sq_serialnum || '.nextval from dual' into i_serialnum;
°´ÕÕÆ´Òô,²¿Ê×,±Ê»ÅÅÐò
ÏÂÃæµÄ·½·¨ÐèÒªORACLE9iºÍÒÔÉϵİ汾²ÅÖ§³Ö.
Oracle9i֮ǰ, ÖÐÎÄÊǰ´ÕÕ¶þ½øÖƱàÂë½øÐÐÅÅÐòµÄ.
ÔÚoracle9iÖÐÐÂÔöÁ˰´ÕÕÆ´Òô,²¿Ê×,±Ê»ÅÅÐò¹¦ÄÜ. ÉèÖÃNLS_SORTÖµ
SCHINESE_RADICAL_M °´ÕÕ²¿Ê×(µÚһ˳Ðò),±Ê»®(µÚ¶þ˳Ðò)ÅÅÐò
SCHINESE_STROKE_M °´Õձʻ®(µÚһ˳Ðò),²¿Ê×(µÚ¶þ˳Ðò)ÅÅÐò
SCHINESE_PINYIN_M °´ÕÕÆ´ÒôÅÅÐò, ϵͳµÄĬÈÏÅÅÐò·½Ê½ÎªÆ´ÒôÅÅÐò
select * from table_name order by nlssort(field_name, 'nls_sort=SCHINESE_STROKE_M');
È¡ºÁÃë(oracle 9i +)
select to_char(systimestamp,'yyyy-mm-dd hh24:mi:ss.ff3') from dual;
like²éѯÏ»®Ïß±¾Éí
select * from test where columnname like 'a\_%' escape '\';
-- ±íʾ½«½ô¸úÔÚescape×Ö·ûºóµÄ×Ö·û½âÊÍΪ×Ö·û±¾Éí, ¶ø·ÇתÒå×Ö·û
ÈÕÆÚ¼õÈ¥Ò»Ãë
select sysdate,sysdate - interval '1' second from dual;
Ð޸ıí½á¹¹
alter table t_employee add (remark varchar2(50)); --Ôö¼ÓÁÐ
alter table t_employee modify (sex default 0); --ÐÞ¸ÄÁеÄĬÈÏÖµ
alter table t_employee modify (remark null); --ÐÞ¸ÄÁпÉΪ¿Õ
alter table t_employee rename to t_employee_new; --Ð޸ıíÃû
&
Ïà¹ØÎĵµ£º
oracleº¯Êý´óÈ«-Êý×Ö´¦Àíº¯Êý
F.3 Êý×Öº¯Êý
º¯Êý½ÓÊÜNUMBERÀàÐ͵IJÎÊý²¢·µ»ØNUMBERÀàÐ͵ÄÊýÖµ.³¬Ô½º¯ÊýºÍÈý½Çº¯ÊýµÄ·µ»ØÖµ¾«È·µ½36λ.ACOS¡¢ASIN¡¢ATAN¡¢ATAN2µÄ½á¹û¾«È·µ½36λ.
l ABS
Óï·¨: ABS(x)
¹¦ÄÜ: µÃµ½xµÄ¾ø¶ÔÖ ......
Flashback ¼¼ÊõÊÇÒÔUndo segmentÖеÄÄÚÈÝΪ»ù´¡µÄ£¬ Òò´ËÊÜÏÞÓÚUNDO_RETENTON²ÎÊý¡£ÒªÊ¹ÓÃflashback µÄÌØÐÔ£¬±ØÐëÆôÓÃ×Ô¶¯³·Ïú¹ÜÀí±í¿Õ¼ä¡£
ÔÚOracle 10gÖУ¬ Flash back¼Ò×å·ÖΪÒÔϳÉÔ±£º Flashback Database£¬ Flashback Drop£¬Flashback Query(·ÖFlashback Query,Flashback Version Query£¬ Flashback Transaction Que ......
1. ·ÖÇø±í
Oracle
½¨ÒéÈç¹ûµ¥¸ö±í³¬¹ý2G¾Í×îºÃ¶ÔÆä½øÐзÖÇø¡£
¶Ô´ó±íµÄ²éѯ¡¢Ôö¼Ó¡¢Ð޸ĵȲÙ×÷¿ÉÒԷֽ⵽±íµÄ²»Í¬·ÖÇøÀ´²¢ÐÐÖ´ÐУ¬¿ÉʹÔËÐÐËٶȸü¿ì£»
1)
Range·ÖÇø
¡¡¡¡Range·ÖÇøÄØÊÇÓ¦Ó÷¶Î§±È½Ï¹ãµÄ±í·ÖÇø·½Ê½£¬ËüÊÇÒÔÁеÄÖµµÄ·¶Î§À´×öΪ·ÖÇøµÄ»®·ÖÌõ¼þ£¬½«¼Ç¼´æ·Åµ½ÁÐ ......
1. ½«Êý¾Ý¿âÍêÈ«µ¼³ö
Óû§Ãûsystem ÃÜÂësystem µ¼³öµ½OracleÓû§Ä¿Â¼ÏµÄtestdb20100522.dmpÎļþÖÐ
#exp system/system@testdb file=testdb20100522.dmp full=y
2. ½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ¼³ö
#exp system/system@testdb file= testdb20100522.d ......