Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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ÖеÄÊ÷ÐβÙ×÷

ÔÚ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 ......

Oracle¸ß¼¶¼¼ÇÉ

1.ÔÚɾ³ýÒ»¸ö±íÖеÄÈ«²¿Êý¾Ýʱ£¬ÐëʹÓÃTRUNCATE TABLE ±íÃû;ÒòΪÓÃDROP TABLE£¬DELETE * from ±íÃûʱ£¬TABLESPACE±í¿Õ¼ä¸Ã±íµÄÕ¼Óÿռ䲢δÊÍ·Å£¬·´¸´¼¸´ÎDROP£¬DELETE²Ù×÷ºó£¬¸ÃTABLESPACEÉϰÙÕ׵Ŀռä¾Í±»ºÄ¹âÁË¡£
¡¡¡¡
¡¡¡¡2.having ×Ó¾äµÄÓ÷¨
¡¡¡¡
¡¡¡¡having ×Ó¾ä¶Ô group by ×Ó¾äËùÈ·¶¨µÄÐÐ×é½øÐпØÖÆ,having ×Ó ......

oracle Óαê

oracle Óαê
¹Ø¼ü×Ö: oracle Óαê
1.       Óαê: ÈÝÆ÷£¬´æ´¢SQLÓï¾äÓ°ÏìÐÐÊý¡£
2.       ÓαêÀàÐÍ: ÒþʽÓα꣬ÏÔʾÓα꣬REFÓαꡣÆäÖУ¬ÒþʽÓαêºÍÏÔʾÓαêÊôÓÚ¾²Ì¬Óα꣨ÔËÐÐǰ½«ÓαêÓëSQLÓï¾ä¹ØÁª£©,REFÓαêÊôÓÚ¶¯Ì¬Óαê(ÔËÐÐʱ½«ÓαêÓëSQLÓï¾ä¹ØÁª)¡ ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç17

Êý¾ÝÀàÐÍʹÓÃ
1.ÉùÃ÷£º
a.¸ñʽ£ºVariable_name [constant] databyte [not null] [:=default expression]
b.±äÁ¿Óë³£Á¿ÉùÃ÷»ù±¾Ò»Ö£¬Ê¹ÓÃconstantÉùÃ÷µÄΪ³£Á¿£¬²»Ê¹ÓÃΪ±äÁ¿£¬²¢ÇÒ¸³ÖµÖ»ÄÜÔÚDECLAREÇøÓò¸³Öµ£»
c.ʹÓÃ%TYPEºÍ%ROWTYPEÉùÃ÷¿ÉÒÔʹ±äÁ¿µÄÀàÐÍÓë±íÖÐ×Ö¶ÎÀàÐÍ»òÕû¸ö¼Ç¼ÀàÐͱ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ