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

oracle ±éÀúÊ÷

oracle ÔõôÀ´±éÀúÒ»¸öÊ÷£¬Ïà±È½ÏÆäËû·½·¨£¬oracleµÄconnectÓï·¨¸üÄܱܺãÀûµÄ½â¾öÎÊÌâ¡£
Óï·¨¸ñʽ£º
select ...
from ...
start with...
connect by prior expr=expr
order siblings by ..
start with µÄ¹¦ÄÜÀàËÆÓÚwhere£¬Ö¸Ã÷´ÓÄĸö·ÖÖ§¿ªÊ¼±ãÀû£»
connect by Ö¸Ã÷¸¸½ÚµãºÍ×Ó½ÚµãµØÁ¬½Ó·½Ê½£¬¹Ø¼ü×Öprior·ÅÔÚ¸¸½Úµã֮ǰ£»
order siblings by´ú±í¶Ôͬһ²ãµÄ½Úµã½øÐÐÅÅÐò·½·¨¡£
Àý×Ó£º
select * from direct
start with parentid is null
connect by prior parentid = id;
½á¹û£º
id  name   parentid
1   oracle     null
2   assistants  1
3   bin              1
4   RDBMS        1
5   ADMIN        4
6   catcr.sql     5
7   catawrvw.sql  5
Èç¹ûÏë¿´Ê÷µÄ²ã´Î½á¹¹£¬¿ÉÓÃoracleÌṩLEVELαÁÐ
·½·¨ÈçÏ£º
select level,lpad(' ',level * 2 -1)|| '|' || name name
from direct
start with parentid is null
connect  by  prior id = parentid;
ʹÓÃSYS_CONNECT_BY_PATH£¬È¡µÃ֮ǰµÄ·¾¶ÐÅÏ¢
select id,SYS_CONNECT_BY_PATH(name,'/') name
from direct
start with parentid is null
connect by prior id = parentid;


Ïà¹ØÎĵµ£º

oracle´´½¨±í¿Õ¼ä¡¢Óû§¡¢ÊÚȨ


//´´½¨Êý¾Ý±í¿Õ¼ä
create tablespace zfmi logging datafile 'D:\oracle\oradata\zfmi\zfmi.dbf' size 100m autoextend on next 32m maxsize 2048m extent management local;
//´´½¨Óû§²¢Ö¸¶¨±í¿Õ¼ä
create user zfmi identified by zfmi default tablespace zfmi temporary tablespace zfmi_temp;
//¸øÓû§ÊÚÓèÈ¨Ï ......

Éî¶È¶Ô±ÈOracleÓëSQL Server——µÚ¶þ²¿·Ö

Êý¾Ý¿âʵÀý½á¹¹ ÊÂÎñÒ»ÖÂÐÔ(Transactional Consistency)ºÍ»ùÓÚʱ¼äµãµÄ»Ö¸´(Point-in-time Recovery) ϵͳԪÊý¾Ý
topÊý¾Ý¿âʵÀý½á¹¹
µ±OracleʵÀýÆô¶¯Ö®ºó£¬Ëù¿´µ½µÄ¾ÍÊÇÔÚ·þÎñÆ÷ÄÚ´æÉϵÄÒ»¸ö¸ö²»Í¬ÄÚ´æ¿é¼ÓÉϲúÉúµÄÓëÕâЩÄÚ´æ½»»¥µÄºǫ́½ø³Ì¡£OracleÎĵµ½«ÕâЩÄÚ´æ½á¹¹ºÍ½ø³ÌÊյĺÜÏêϸ¡£
ÓÉOracleʵÀýËùÕ¼ÓõÄÄÚ´æ¿é³ ......

ORACLE Óë mysql µÄÇø±ð

1.ÔÚORACLEÖÐÓÃselect * from all_usersÏÔʾËùÓеÄÓû§£¬¶øÔÚMYSQLÖÐÏÔʾËùÓÐÊý¾Ý¿âµÄÃüÁîÊÇshow
databases¡£¶ÔÓÚÎÒµÄÀí½â£¬ORACLEÏîÄ¿À´ËµÒ»¸öÏîÄ¿¾ÍÓ¦¸ÃÓÐÒ»¸öÓû§ºÍÆä¶ÔÓ¦µÄ±í¿Õ¼ä£¬¶øMYSQLÏîÄ¿ÖÐÒ²Ó¦¸ÃÓиöÓû§ºÍÒ»¸ö¿â¡£ÔÚ
ORACLE(db2Ò²Ò»Ñù)Öбí¿Õ¼äÊÇÎļþϵͳÖеÄÎïÀíÈÝÆ÷µÄÂß¼­±íʾ£¬ÊÓͼ¡¢´¥·¢Æ÷ºÍ´æ´¢¹ý³ÌÒ²¿É ......

cmdÖд´½¨oracleÓû§

1.´ò¿ªcmd£¬ÊäÈësqlplus£¬»Ø³µ
2.ÊäÈëÓû§Ãû£ºsystem/manager@orcl as sysdba£¬»Ø³µ
3.create user muzai identified by muzai;   //´´½¨muzaiÓû§£¬ÃÜÂëΪmuzai
4.grant dba to muzai;    //°ÑdbaµÄȨÏÞ¸³¸ømuzaiÕâ¸öÓû§ ......

oracle 10 ´´½¨¶à¸öÊý¾Ý¿âµÇ¼¸÷¸öEMµÄ·½·¨

Ò»¡¢Enterprise Manager 10g
ĬÈÏÇé¿öÏ£¬°²×°Oracleʱ£¬»á°²×°EM¡£ËüÊÇλÓÚÊý¾Ý¿â·þÎñÆ÷ÉϵÄHTTP·þÎñÆ÷¡£
£¨1£©Æô¶¯EM
Ҫȷ±£OracleDBConsole<SID>·þÎñÒѾ­Æô¶¯¡£
Æô¶¯·þÎñ£ºemctl start dbconsole
¹Ø±Õ·þÎñ£ºemctl stop dbconsole
·ÃÎÊEM£ºhttp://·þÎñÆ÷Ãû³Æ£º¶Ë¿ÚºÅ/em
¶Ë¿ÚºÅ¿ÉÔÚ$ORACLE_HOME\product\10. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ