oracleµÄһЩ»ù±¾Óï·¨ºÍһЩÓÅ»¯ÎÊÌâ
²éѯ£º
select distinct(empno) , name , age from t_person t where (t.age between 21 and 25 or name like '%Íõ%') and
empno like '32%';
¸üУº
update t_person set name = 'ww' where empno = '321654';
update t_person set(empno,name,age) = (select empno,name,age from t_person1 where ...)
²åÈ룺
insert into t_person values(seq_person.nextval,'ww',21); -- seq_person.currval µ±Ç°ÐòÁÐÖеÄÖµ
insert into t_person(empno,name) values('321654','ww');
ɾ³ý£º
delete t_person <==> delete from t_person
´´½¨±í£º
create table t_person (
empno varchar2(6),
name varchar2(20),
age int ,
constraint pk_person primary key(empno)
);
comment on table t_person is 'Ô±¹¤±í';
comment on column empno is 'Ô±¹¤±àºÅ';
comment on column name is 'Ô±¹¤ÐÕÃû';
comment on column age is 'Ô±¹¤ÄêÁä';
create table t_person as select * from t_person1 where 1<>1; Ö»¸´ÖƱí½á¹¹
create table t_person as select * from t_person1 where 1=1; ¸´ÖƱí½á¹¹ºÍÊý¾Ý£¨¿½±´£©£¬µ«³ýÁË·Ç¿ÕÔ¼ÊøÄܱ»¸´ÖÆ£¬ÆäËüµÄÔ¼Êø¶¼²»ÄÜ¿½±´¡£
´´½¨ÊÓͼ£º
create view v_person as select * from t_person t left join t_person1 m on t.empno = m.empno where ...;
½ØÈ¡×Ö·û´®£º
select substr('wangwei',2,3) from dual; --´ÓµÚ¶þλ¿ªÊ¼½ØÈ¡È¡Èý¸ö×Ö·û£¨×¢Òâ:Êý¾Ý¿âÖеÄÊÇ´Ó1¿ªÊ¼µÄ£¬¶ø²»ÊÇ0£©
dbms_output.put_line :ang
¼ÆË㳤¶ÈµÄº¯Êý£º
select length('wangwei') from dual; --dbms_output.put_line:7
¼ÆËã×ÜÁ¿µÄº¯Êý£º
select count(1) from t_person; -- ´ËÓï¾äµÄÖ´ÐÐЧÂʱȷÇË÷Òý×ֶεÄЧÂʵÍ
select count(*) from t_person; -- ´ËÓï¾äµÄÖ´ÐÐЧÂʱȷÇË÷Òý×ֶεÄЧÂʵͣ¬±ÈµÚÒ»¸öµÄЧÂʵÍһЩ¡£
select count(name) from t_person; -- ´ËÓï¾äµÄÖ´ÐÐЧÂÊÊÇ×îµÍµÄ£¬Ç°ÌáÌõ¼þÊÇname×ֶβ»ÊÇË÷Òý¡£
select count(empno) from t_person; --´ËÓï¾äµÄÖ´ÐÐЧÂÊ×î¸ß£¬Ç°ÌáÊÇempno×Ö¶ÎÊÇË÷Òý¡£
ÔÚÆ´½ÓsqlÓï¾äµÄʱºò£¬Ò»¶¨Òª×¢Òâ×Ö·û´®ºÍ¿Õ¸ñµÄÎÊÌ⣬±ÈÈ磺
String sql = "select * from t_person t where
Ïà¹ØÎĵµ£º
Éó¼ÆÊÓͼ
STMT_AUDIT_OPTION_MAP -- Éó¼ÆÑ¡ÏîÀàÐÍ´úÂë
AUDIT_ACTIONS -- action´úÂë
ALL_DEF_AUDIT_OPTS -- ¶ÔÏó´´½¨Ê±Ä¬ÈϵĶÔÏóÉó¼ÆÑ¡Ïî
DBA_STMT_AUDIT_OPTS -- µ±Ç°Êý¾Ý¿âϵͳÉó¼ÆÑ¡Ïî
DBA_PRIV_AUDIT_OPTS -- ȨÏÞÉó ......
ÔÚÊý¾Ý¿âÖУ¬ÓÐÁ½¸öÓû§usera£¬userb£¬Èç¹ûÔÚbÖÐÓиö´æ´¢¹ý³Ì£¬ÐèÒªÓÃaµÄÓû§È¥µ÷Ó㬣¨±ÈÈçbÊÇȨÏ޺ܸߵÄÓû§£¬¶øaÖ»ÊÇÆÕͨÓû§£¬ÎªÁËÆÁ±Î¸øa×îСµÄȨÏÞÖ»ÄÜÈç´Ë£©¡£ÓÚÊÇ£¬ÎÒ¾ÍÓÃgrant execute on ´æ´¢¹ý³ÌÃû to usera¡£ÕâÑù£¬ÔÚaµÄÓû§ÏÂÃæ¾ÍÄÜ¿´µ½´æ´¢¹ý³ÌÁË£¬µ«ÊÇÎÒÖ´ÐÐÒԺ󣬻¹ÊDZ¨ora-1031£¬ËµÊÇûÓÐȨÏÞ£¬¾¹ýÓ ......
¾¹ýÊýÌ첻иµÄŬÁ¦£¬LINUXÀú¾¡Èý´Î֨װ£¬ORACLE֨װN´ÎÖÕÓÚÔÚLiNUXAS4 update6 x86_64 ϰ²×°ºÃORACLE10g R 2 (64λ) ÁË¡£
ÏÂÃæ°Ñ°²×°¹ý³ÌºÍ´ó¼Ò·ÖÏíһϣ¬ÒÔÃâ¸ü¶àÈËÏñÎÒÒ»Ñù»¨·Ñ´óÁ¿µÄʱ¼äÔÚĪÃûÆäÃîµÄÎÊÌâÉÏ¡£
Ê×ÏÈҪ˵Ã÷µÄÊÇ£¬¹Ù·½Ò²ÓÐÏàÓ¦µÄÎĵµ°²×°µ«ÊÇʵ¼Ê¹ý³ÌÖУ¬»áÓÐһЩÎÊÌâÐèÒª½â¾ö¡£
±¾Îĵµ²ÎÕÕÁËÏà¹ØËµ ......
1. NLS_LANG
²ÎÊý×é³É
NLS_LANG
²ÎÊýÓÉÒÔϲ¿·Ö×é³É:
NLS_LANG
=<Language>_<Territory>.<Clients
Characterset>
NLS_LANG
¸÷²¿·Öº¬ÒåÈçÏÂ:
LANGUAGEÖ¸¶¨:
-OracleÏûϢʹÓõÄÓïÑÔ
-ÈÕÆÚÖÐÔ·ݺÍÈÕÏÔʾ
TERRITORYÖ¸¶¨
-»õ±ÒºÍÊý×Ö¸ñʽ
-µØÇøºÍ¼ÆËãÐÇÆÚ¼°ÈÕÆÚµÄϰ¹ß
CHARACTERSET:
-¿Ø ......
exp/impÊÇOracle×Ô´øµÄµ¼Èëµ¼³öÃüÁÔËÓÃËü£¬¼´Ê¹²»ÐèÒªÄǽáUI¹¤¾ßÒ²ÄÜÇáÒ×µÄÍê³ÉÊý¾Ýµ¼³öµ¼È빤×÷£¬ÏÂÃæÊÇËüÃǵIJÎÊý£º
EXP²ÎÊýÏê½â
ʹÓõĸñʽÊÇ£ºEXP KEYWORD=value »ò KEYWORD=(value1,value2,...,valueN)
ÆäÖÐUSERIDÊDZØÐëµÄÇÒΪµÚÒ»¸ö²ÎÊý
¹Ø¼ü×Ö
±¸×¢
USERID
Óû§Ãû/¿ÚÁî
FULL
µ¼³öÕû¸öÎļþ (N)
BUFFER
......