Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : Oracle

ORACLEµÄÓû§ÃûºÍÃÜÂëÊÇʲô£¿ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒ¸Õ×°ÁËORACLE 11g£¬¿É´ò¿ªSQL PlusʱҪÇóÊäÈëÓû§ÃûºÍÃÜÂë¡£ËüÃÇÊÇʲô°¡£¿
×°µÄʱºò²»ÊǾÍÒªÄãÊäÈëÓû§ÃûºÍÃÜÂëµÄô£¿
ÔÚĬÈÏÇé¿öÏ£¬¼ÙÈçÄãµÇ¼OSµÄÓû§ÊÇDBA×éµÄ£¬¿ÉÒÔÕâÑù£º
sqlplus /nolog
sql>connect / as sysdba
ÕâÑù¾ÍÒÔSYSDBAȨÏÞÁ¬ÉÏÁË£¬È»ºó¿ÉÒÔ¸ÄÆäËüÈκÎÓû§µÄÃÜÂë


Oracle Óû§¼°½ÇÉ« ½éÉÜ
h ......

sqlÓï¾äÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

id a b
-----------
1 2 12
1 1 100
1 2 123
1 1 130
1 2 153
1 1 171
1 1 188
1 2 200
1 2 222
1 1 234
1 2 333
1 2 344
1 2 411
ԭʼÊý¾Ý°´ÕÕbÁÐÅÅÐò£¬Õý³£Êý¾ÝaÁÐÊÇ1£¬2½»Ì棬Ȼºó·Ö±ðÈ¡µÃbÁеÄÖµ
Èç¹ûaÁпªÊ¼Êý¾Ý ......

oracl³£ÓÃsql - Oracle / »ù´¡ºÍ¹ÜÀí

oracl³£ÓÃÐÔÄܲéѯ¼°ËÀËø½â¾ö°ì·¨»ã×Ü¡£
select count(1) from dictionary;
select * from dba_data_files;
select count(1) from dba_objects t where t.owner='BESTTONE';
select * from dba_tablespaces t where t.tablespace_name='BESTTONE';
select count(1) from dba_tables t where t.owner='BESTTONE';
sele ......

Îʼ¸¸öoracleÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÈçÌâ:
1.±í¿Õ¼ä»òÊý¾ÝÎļþµÄÒƶ¯¶Ô±íÖеÄÊý¾ÝÓÐÓ°ÏìÂ𣿠
2.ÐÐÁ¬½ÓºÍÐÐǨÒÆÈçºÎÀí½â£¿
3.ÔÚ½øÐÐÊý¾ÝÎļþÌí¼Óʱ£¬´øÉϲÎÊýresizeºÍreuseÊÇʲôÒâ˼£¿
4.Êý¾Ý¿éºÍ±íµÄ¹Øϵ£¿
5.ÎÒÃÇÔÚÐÞ¸Äϵͳ¼¶²ÎÊýʱ£¬´øÉÏscope = spfile »ò scope=both µÄÓÃÒâÊÇʲô£¿
Ï£Íû´ó¼Ò°ïæ½â´ð£¡Ð»Ð»£¡
1¡¢Óеġ£±í¿Õ¼äºÍÊý¾ÝÎļþÊÇÎ ......

ÔÙÎʼ¸¸öoracleÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÈçÌ⣺
1.ÈçºÎÀí½âvarchar2ÀàÐͲÉÓÃnon-padded,¶øchar²ÉÓÃBlank-Padded·½Ê½±È½Ï£¿
2.oracleÖÐͳ¼ÆÐÅÏ¢ÈçºÎÊÕ¼¯?
3.¼ÆËã2µÄ64´Î·½½á¹û²»¶Ô£¬²»ÖªÊ²Ã´Ô­Òò£¿
´úÂëÇåµ¥:
SQL code:

2µÄ64´Î·½¸ù
SQL> select power(2,64) from dual;

POWER(2,64)
-----------
1.844674407
SQL> select power(64,2) value ......

oracle²éѯ²¢È¡³öij¸ö·¶Î§ÐÐÎÊÌâ - Oracle / ¿ª·¢

²éѯ³öѧϰ³É¼¨¼°¸ñµÄËùÓÐѧÉú
²¢È¡³öµÚ10ÖÁ20Ãû
±í¿ÉÒÔ×Ô¼ºÆðÃû×Ö,ֻҪʵÏÖ¾ÍÐÐ

select * from 
(select t.*,rownum flag from table t order by ³É¼¨ desc )
where flag >= 10 and flag <= '20'

rownum > ij¸öÊý×Ö OR rownum = ·Ç1µÄÊý×Ö
¶¼ÊDz»ºÏ·¨µÄ°É

select * from (
select b.* ......
×ܼǼÊý:1827; ×ÜÒ³Êý:305; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [2] [3] [4] [5] 6 [7] [8] [9] [10] [11]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ