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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæһЩ£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
°²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Ϊ¿ ......
°²×°×¼±¸£º
ÏÂÔØÎļþ
l Oracle Database 10g Release 2(10.2.0.1) Software
½âѹÎļþ
½âѹÎļþÃüÁ
unzip 10201_database_linux32.zip
½âѹºóµÄÎļþ¼Ð¿ÉÄÜ“database”»ò“db/Disk1”
HostsÎļþ
ÔÚ/etc/hosts ÎļþÖаüº¬Ò»¸öÍêÕûºÏ· ......
ÔÎÄ´«ËÍÃÅ£ºhttp://www.blogjava.net/improviser/archive/2008/12/07/244911.html
ÔÚǰһƪÎÄÕÂÖмòµ¥½éÉÜÁËJAVA³ÌÐòÈçºÎµ÷ÓÃOracle´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨³ÌÐò½á¹¹£¬ ±¾ÎĽ«½éÉÜJAVA¸úOracleµÄÁíÒ»ÖÖ¹Øϵ£¬¼´Í¨¹ýJAVA±àдOracle´æ´¢¹ý³Ì¡£ ͨ³£Çé¿öÏ£¬ÎÒÃǶ¼ÊÇʹÓÃOracleÊý¾Ý¿âϵͳÖеÄps/sqlÓï¾äÀ´Îª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
-- ......