µãµãµÎµÎ(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ʵÀýÃû,·þÎñÃûµÈ¸ÅÄîÇø±ðÓëÁªÏµ
Ò»¡¢Êý¾Ý¿âÃûITPUB¸öÈË¿Õ¼äv{7x6lo\
ʲôÊÇÊý¾Ý¿âÃû£¿ITPUB¸öÈË¿Õ¼ä*s*R5LVBXZ2w$I
Êý¾Ý¿âÃû¾ÍÊÇÒ»¸öÊý¾Ý¿âµÄ±êʶ£¬¾ÍÏñÈ˵ÄÉí·ÝÖ¤ºÅÒ»Ñù¡£ËûÓòÎÊýDB_NAME±íʾ£¬Èç¹ûһ̨»úÆ÷ÉÏ×°Á˶àÈ«Êý¾Ý¿â£¬ÄÇôÿһ¸öÊý¾Ý¿â¶¼ÓÐÒ»¸öÊý¾Ý¿âÃû¡£ÔÚÊý¾Ý¿â°²×°»ò´´½¨Íê³ÉÖ®ºó£¬²Î ......
oracle8i Çý¶¯ ojdbc14.jar Õâ¸öÇý¶¯ÓÐÎÊÌ⣬·ÖҳʱҪÊÖ¶¯ д rownum<m ,Ëü×Ô¶¯³ÉÉúµÄ·ÖÒ³²»ÕýÈ·£¬ÓõÄmysqlµÄtop m
Null value was assigned to a property of primitive °ÑentityÖÐintÀàÐ͸ijÉInteger ¿âÖв»ÉèÖÃnullable
number(9) µÄid ²»ÄÜÓÃInterger,µÃÓÃBigDecimal,Òª²»È»È¡idʱ»á±¨´í ......
OracleÆô¶¯Ê±ÐèÒªµÄ·þÎñ£º
ÔÌûµØÖ·£ºhttp://www.blogjava.net/sidanzhou/archive/2008/03/03/183507.html
×¢£ºSID - Êý¾Ý¿â±êʶ
HOME_NAME - Oracle HomeÃû³Æ£¬ÈçOraHome92¡¢OraHome81
£¨1£©OracleServiceSID
Êý¾Ý¿â·þÎñ£¬Õâ¸ö·þÎñ»á×Ô¶¯µØÆô¶¯ºÍÍ£Ö¹Êý¾Ý¿â¡£Èç¹û°²×°ÁËÒ»¸öÊý¾Ý¿â£¬ËüµÄȱʡÆô¶¯ÀàÐÍΪ×Ô¶¯¡£·þÎñ½ø³ ......
insert into dts_auction_comments (id,auction_id,user_id,user_nick,comments,gmt_create,gmt_modified,status,comm_type)
values(409,127380, ......
½¨Á¢sshÐÅÈΣ¬racµÄ°²×°ÒªÓÃsshºÍscpÀ´¿½±´°²×°Îļþ¡£
ÔÚËùÓеĽڵãÉÏÔËÐУº
mkdir ~/.ssh
chmod 700 ~/.ssh
ssh-keygen -t rsa
ssh-keygen -t dsa
ÔÚrdb1½ÚµãÉÏÖ´ÐУº
ssh rdb1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh rdb1 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
ssh rdb2 ......