oracleÐÞ¸ÄÓû§Ãû
--sqlplus
sqlplus;
sys /password as sysdba;
--²éÕÒÓû§ID£¨user#£©,Êý¾Ý¿âÀïÃæ´æ·ÅµÄÓû§¶¼ÊÇ´óд!
select user#,name,password from user$ where name ='FACT';
USER# NAME PASSWORD
91 FACT 7A0F2B316C212D67
-¸ù¾ÝÓû§ID ¸üÐÂÓû§Ãû¡£
update user$ set name= FACT where user#=91;
--Ìá½»¡£
commit;
--È·ÈÏÓû§ÃûÊÇ·ñ¸üгɹ¦¡£
select user#,name,password from user$ where USER# = 91;
USER# NAME PASSWORD
91 FACT 7A0F2B316C212D673
--ÐÞ¸ÄÓû§ÃÜÂë¡£
alter user fact identified by fact;
--ÊÖ¹¤Ö´Ðмì²éµã²Ù×÷£¬½«Database Buffer CacheÖеÄÊý¾ÝÇ¿ÖÆÐ´³öµ½Íâ´æ¡£
alter system checkpoint;
--Ç¿ÖÆË¢ÐÂShared Pool£¡ÒòΪOracleµÄÊý¾Ý×ÖµäÐÅÏ¢ÊÇ»º´æÔÚShared PoolµÄDictionary CacheÖеġ£
alter system flush shared_pool;
--È·ÈÏÃÜÂëÊÇ·ñÐ޸ijɹ¦¡£
select user#,name,password from user$ where USER# = 91;
USER# NAME PASSWORD
91 FACT 7A0F2B316C212D67
--²âÊÔÓû§ÊÇ·ñ¿ÉÓá£
conn fact/fact
Connected.
show user
USER is "FACT"
--ÖØÆôORACLE·þÎñ
Ïà¹ØÎĵµ£º
ÔÚOracleÖеÄÊ÷ÐβÙ×÷
1.È¡×ӽڵ㼰·¾¶(ÕýÊ÷):
select t.id ,t.code, t.name ,t.pid
,SYS_CONNECT_BY_PATH(t.id,'.')||'.' as IdPath
from tas_catalog t
--where id!=110
start with id=110
connect by pid = prior id
order siblings by id
2.È¡¸÷¼¶¸¸½Úµã(µ¹Ê÷)£º
select t.id ,t.code, t.na ......
²é¿´ÕýÔÚÖ´ÐеÄsqlÓï¾ä
SELECT osuser, username, sql_text from v$session a, v$sqltext b where a.sql_address =b.address order by address, piece;
²¶×½ÔËÐкܾõÄSQL
select username,sid,opname, round(sofar*100 / totalwork,0) || '%' as progress, time_remaining,sql_text from v$session_longops , v$ ......
C#ÖвÙ×÷OracleʱµÄSQLÓï¾ä²ÎÊýµÄÓ÷¨
OracleTransaction myTrans ;
conn.Open();
myTrans =conn.BeginTransaction(IsolationLevel.ReadCommitted) ......
oracle Óαê
¹Ø¼ü×Ö: oracle Óαê
1. Óαê: ÈÝÆ÷£¬´æ´¢SQLÓï¾äÓ°ÏìÐÐÊý¡£
2. ÓαêÀàÐÍ: ÒþʽÓα꣬ÏÔʾÓα꣬REFÓαꡣÆäÖУ¬ÒþʽÓαêºÍÏÔʾÓαêÊôÓÚ¾²Ì¬Óα꣨ÔËÐÐǰ½«ÓαêÓëSQLÓï¾ä¹ØÁª£©,REFÓαêÊôÓÚ¶¯Ì¬Óαê(ÔËÐÐʱ½«ÓαêÓëSQLÓï¾ä¹ØÁª)¡ ......
SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
A A ZERO &nbs ......