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

ORACLEÊý¾Ý¿âµÄÊý¾Ýµ¼Èë·½·¨

ÒÔ ÏÂÆßÖÖÊý¾Ýµ¼Èë·½·¨Äĸö×îÊÊÓÃÐèÒªÕë¶Ô¾ßÌåÇé¿ö¾ßÌå·ÖÎö£¬ÎÒÒ²¸½´øÁоÙÁËÓ°Ïìµ¼ÈëËٶȵĸ÷ÖÖÒòËع©Õå×á£ÎªÁ˱Ƚϸ÷ÖÖÊý¾Ýµ¼Èë·½·¨µÄЧ¹û£¬ÎÒ´´½¨ÁËʾÀý±í ºÍÊý¾Ý¼¯£¬²¢Óø÷ÖÖ·½·¨µ¼ÈëʾÀýÊý¾Ý¼¯À´¼ÆËã×ÜÌåµ¼Èëʱ¼äºÍµ¼Èë½ø³ÌÕ¼Óà CPU ʱ¼ä£¬ÕâÀïµÃ³öµÄʱ¼ä½ö¹©²Î¿¼¡£ÐèҪ˵Ã÷µÄÊÇ£¬½¨ÒéÄãʹÓà Oracle 9i ÆóÒµ°æÊý¾Ý¿â£¬µ±È»ÄãÒ²¿ÉÒÔ³¢ÊÔʹÓà Oracle 7.3 ÒÔÉϵıê×¼°æÊý¾Ý¿â¡£±¾ÎÄʹÓõĻúÆ÷ÅäÖÃΪ£ºCPU Intel P4£¬ÄÚ´æ 256M£¬Êý¾Ý¿â Oracle 9i ÆóÒµ°æ¡£
ʾÀý±í½á¹¹ºÍÊý¾Ý¼¯
ΪÁËÑÝʾºÍ±È½Ï¸÷ÖÖÊý¾Ýµ¼Èë·½·¨£¬ÎÒ¼Ù¶¨Êý¾Ýµ¼ÈëÈÎÎñÊǽ«ÍⲿÎļþÊý¾Ýµ¼Èëµ½ Oracle Êý¾Ý¿âµÄCALLS±íÖУ¬ÍⲿÊý¾ÝÎļþ°üº¬Ê®ÍòÌõºô½ÐÖÐÐļǼ£¬½«½ü 6MB µÄÎļþ´óС£¬¾ßÌåµÄÊý¾ÝʾÀýÈçÏÂ:
82302284384,2003-04-18:13:18:58,5001,ͶËß,ÊÖ»úÈý°üάÐÞÖÊÁ¿
82302284385,2003-04-18:13:18:59,3352,×Éѯ,¹©Ë®ÈÈÏߵĺÅÂë
82302284386,2003-04-18:13:19:01,3142,½¨Òé,ÔöÉ蹫½»Ïß·
½ÓÊܵ¼ÈëÊý¾ÝµÄ±íÃûÊÇ CALLS£¬±í½á¹¹ÈçÏ£º
     Name                Null?         Type                 Comment
    ------------     ---------     -------------        -----------------
    CALL_ID          NOT NULL      NUMBER               Primary key
    CALL_DATE        NOT NULL      DATE                 Non-unique index
    EMP_ID           NOT NULL      NUMBER
    CALL_TYPE        NOT NULL      VARCHAR2(12)
 


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

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

Óà Navicat for Oracle ¹ÜÀí Oracle10g/11g Êý¾Ý¿â

    Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæһЩ£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
    °²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Ϊ¿ ......

linuxÏ oracleµÄ°²×°

  °²×°×¼±¸£º
ÏÂÔØÎļþ
l         Oracle Database 10g Release 2(10.2.0.1) Software
½âѹÎļþ
½âѹÎļþÃüÁ
unzip 10201_database_linux32.zip
½âѹºóµÄÎļþ¼Ð¿ÉÄÜ“database”»ò“db/Disk1”
HostsÎļþ
ÔÚ/etc/hosts ÎļþÖаüº¬Ò»¸öÍêÕûºÏ· ......

Oracle Functionµ÷ÓÃjava´úÂë

 Ô­ÎÄ´«ËÍÃÅ£ºhttp://www.blogjava.net/improviser/archive/2008/12/07/244911.html
ÔÚǰһƪÎÄÕÂÖмòµ¥½éÉÜÁËJAVA³ÌÐòÈçºÎµ÷ÓÃOracle´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨³ÌÐò½á¹¹£¬ ±¾ÎĽ«½éÉÜJAVA¸úOracleµÄÁíÒ»ÖÖ¹Øϵ£¬¼´Í¨¹ýJAVA±àдOracle´æ´¢¹ý³Ì¡£ ͨ³£Çé¿öÏ£¬ÎÒÃǶ¼ÊÇʹÓÃOracleÊý¾Ý¿âϵͳÖеÄps/sqlÓï¾äÀ´Îªoracle±àд ......

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 C
-- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ