Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÖØ¸´¼Ç¼


×ܽáÁËÒ»ÏÂɾ³ýÖØ¸´¼Ç¼µÄ·½·¨£¬ÒÔ¼°Ã¿ÖÖ·½·¨µÄÓÅȱµã¡£
¼ÙÉè±íÃûΪTbl£¬±íÖÐÓÐÈýÁÐcol1£¬col2£¬col3£¬ÆäÖÐcol1£¬col2ÊÇÖ÷¼ü£¬²¢ÇÒ£¬col1£¬col2ÉϼÓÁËË÷Òý¡£
1¡¢Í¨¹ý´´½¨ÁÙʱ±í
¿ÉÒÔ°ÑÊý¾ÝÏȵ¼Èëµ½Ò»¸öÁÙʱ±íÖУ¬È»ºóɾ³ýÔ­±íµÄÊý¾Ý£¬ÔÙ°ÑÊý¾Ýµ¼»ØÔ­±í£¬SQLÓï¾äÈçÏ£º
creat table tbl_tmp (select distinct* from tb ......

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

PL/SQL
 
¿é½á¹¹
DECLARE
         ÉùÃ÷²¿·Ö
BEGIN
         ¿ÉÖ´Ðв¿·Ö
EXCEPTION
         Òì³£´¦Àí²¿·Ö
END;
 
Àý£º
Ê×ÏÈÎÒÃÇ¿´Ò»¸ö¼òµ¥Ö®Àý×Ó,ÏÂÃæÕâ¸öÀý×ÓÊÇͳ¼Æ´Ó1 ......

Oracle¸ß¼¶¼¼ÇÉ

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

oracleÀïµÄextendµÄÒâ˼

oracleÀïµÄextendµÄÒâ˼
À©Õ¹ÒÑÖªµÄÊý×é¿Õ¼ä£¬Àý£º
DECLARE
TYPE CourseList IS TABLE OF VARCHAR2(10);
courses CourseList;
BEGIN
-- ³õʼ»¯Êý×éÔªËØ£¬´óСΪ3
courses := CourseList( 'Biol 4412 ', 'Psyc 3112 ', 'Anth 3001 ');
-- ΪÊý×éÔö¼ÓÒ»¸öÔªËØ£¬Êý×é´óСΪ4£¬Ä©Î²µÄÔªËØÎªNULL
courses.EXTEN ......

±±´óÇàÄñ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ºÅ