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

OracleµÝ¹éº¯Êý

CREATE OR REPLACE VIEW ADMIN.TYPETREEVIEW
(ID, ITEMNO, ITEMNOSUB, GROUPID, MEMO,
TREE)
AS
/* 2007/01/23 16:51 XieShaoHua µÝ¹é²éѯ */
SELECT     typetree.ID, typetree.itemno, typetree.itemnosub, typetree.groupid,
           typetree.memo,
           RPAD ('¡¡', LEVEL * 3 - 2, '¡¡') || '©À' || typetree.memo AS tree
      from typetree
START WITH itemnosub = '0'
CONNECT BY PRIOR typetree.itemno = typetree.itemnosub;


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

oracle TNSListener Æô¶¯ºóÓÖÍ£Ö¹µÄÎÊÌâ

 ×î½üÔÚʹÓùý³ÌÖеķ¢ÏÖÁ¬½ÓÊý¾Ý¿âʱºÃʱ»µ£¬¾­³£±¨TNSÒì³££¬ÔÚ¿ØÖÆÃæ°åÖÐÔÚ·þÎñÖн«tnsÕý³£Æô¶¯ºó£¬µ±Á¬½ÓÊý¾Ý¿âʱ·¢ÏÖtnsÓÖÍ£Ö¹ÁË¡£¿à¿àÔÚÍøÉÏËÑѰÁËÐí¶à£¬·¢ÏÖÍøÉÏÆÌÌì¸ÇµØµÄÈýÖÖ·½·¨£¬ÎÒÒ»Ò»ÊÔÁ˶¼Ã»ÓÐ×÷Óᣠ 
ºóÀ´ÎÞÒâÖп´µ½Ò»Î»ÍøÓÑ˵Ëû³öÏÖ¹ýÏàͬµÄÎÊÌ⣬ÊÇÓÉÓÚ×°Á˸övpnÈí¼þ£¬ÕâʱµÄÎÒÉñ¾­ÌرðÃô ......

Oracle 10g ÕýÔò±í´ïʽ


ORACLEÖÕÓÚÔÚ10GÖÐÌṩÁ˶ÔÕýÔò±í´ïʽµÄÖ§³Ö£¬ÒÔǰÄÇЩÐèҪͨ¹ýLIKEÀ´½øÐеĸ´Ôӵį¥Åä¾Í¿ÉÒÔͨ¹ýʹÓÃÕýÔò±í´ïʽ¸ü¼òµ¥µÄʵÏÖ¡£
Oracle 10gÕýÔò±í´ïʽÌá¸ßÁËSQLÁé»îÐÔ¡£ÓÐЧµÄ½â¾öÁËÊý¾ÝÓÐЧÐÔ£¬ Öظ´´ÊµÄ±æÈÏ, Î޹صĿհ׼ì²â£¬»òÕß·Ö½â¶à¸öÕýÔò×é³ÉµÄ×Ö·û´®µÈÎÊÌâ¡£
Oracle 10gÖ§³ÖÕýÔò±í´ïʽµÄË ......

oracle Æô¶¯¹ÜÀíÆ÷

 emctl start dbconsole ÊÇ10gµÄÆô¶¯console·þÎñµÄÃüÁî
½«OEM·þÎñÍ£Ö¹emctl stop dbconsole
emctl start dbconsoleÆô¶¯EM console·þÎñ£¬Ê¹ÓÃǰÐèÒªÏÈÉèÖÃORACLE_SID»·¾³±äÁ¿
emctl stop dbconsoleÍ£Ö¹EM console·þÎñ£¬Ê¹ÓÃǰÐèÒªÏÈÉèÖÃORACLE_SID»·¾³±äÁ¿
¹Ø±ÕÊý¾Ý¿âºóÓ¦¸ÃÊ×ÏÈÓÃsysdbaµÇ½,ÕâÑù¾Í½øÈëÁËsysģʽ. ......

110¸öOracle º¯Êý

 1. ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2. CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr65 from dual;
ZH ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ