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

Oracle ϵͳ³£¼û´íÎó


p580  ÎÄÆ½
³£¼ûÎÊÌâÒ»:°º¹óµÄÊý¾Ý¿âÁ¬½Ó¿ªÏú
    ÔÚÓ¦Óÿª·¢ÖУ¬¿Í»§¶ËΪÁËijÖÖÊý¾Ý¿â²Ù×÷¶ø½øÐÐijÖÖÊý¾Ý¿âÁ¬½ÓºÍ¶Ï¿ªµÄ²Ù×÷¡£ÕâÊÇ2000Äêǰºó¶¯Ì¬ÍøÒ³Ó¦ÓÃÀàÐͳ£¼ûµÄ´íÎó¡£ÔÚÕâÖÖÓ¦ÓÃÖУ¬Ã¿µ±Ò»¸öÓû§µ¥»÷Ò»¸öÍøÒ³£¬Èç¹ûÕâ¸öÍøÒ³Ç¶ÈëÁËÊý¾Ý¿â²Ù×÷£¬Ôò¸ÃÍøÒ³Òª½øÐÐÒ»´Î»òÈô¸É´ÎµÄÊý¾Ý¿âÁ¬½ÓºÍ¶Ï¿ª¡£µ±Ç°Öмä¼þ¼¼ÊõÄ£ÐÍÒѾ­³ÉÊ죬Öмä¼þϵͳ°üº¬×ŶÔÊý¾Ý¿âÁ¬½Ó³ØµÄÖ§³Ö¡£ÍøÒ³Á¬½ÓÔì³ÉµÄÊý¾Ý¿âÁ¬½ÓºÍ¶Ï¿ª²Ù×÷ÒѾ­ºÜÉÙ¼ûÁË¡£
   ÔÚ¿Í»§/·þÎñÆ÷½á¹¹µÄÓ¦ÓÃÖУ¬Ó¦Óô°¿Ú½çÃæÉÏÒ²²»½¨Òé·ÅÖÃÊý¾Ý¿âÁ¬½Ó½Å±¾£¬¶øÊÇÔÚÓ¦ÓÃÆô¶¯ÆÚ¼äÖ®¼äÁ¬½ÓÊý¾Ý¿â¼´¿É¡£
³£¼ûÎÊÌâ¶þ£ºSQL²»ÄÜÖØÓú͹²Ïí³ØµÍЧ
   ÔÚSQL¿ª·¢Öв»×¢ÒâÓï·¨¼°²éѯ½á¹¹µÄÒ»Ö±£¬½«µ¼ÖÂSQLÔÚÖ´Ðйý³ÌÖб»²»¶ÏµØ½âÎö£¬ºÄ·Ñϵͳ×ÊÔ´¡£ÀýÈ磬²éѯÌõ¼þÖÐÖ±½ÓÒýÓÃÊýÖµ£¬¶ø·Ç°ó¶¨±äÁ¿¡£ÕâÔÚÔËÐл·¾³Ï½«Òâζ×Ų»Í¬µÄSQL¡£ËäÈ»Æäº¬ÒåÒ»Ö£¬µ«OracleÈÔÈ»»á½«Æä½âÎöΪ²»Í¬µÄSQL¡£Oracle½¨ÒéʹÓð󶨱äÁ¿µÄ·½·¨½øÐÐÓαêµÄÖØÓá£
³£¼ûÎÊÌâÈý£º²»Á¼SQLÓï¾ä
   ²»Á¼SQLÊÇÖ¸ÄÇЩºÄ·ÑÁË´óÁ¿Ê±¼ä¡¢´óÁ¿ÏµÍ³×ÊÔ´µÄSQLÓï¾ä¡£ÀýÈçÔËÐÐʱ¼ä³¬¹ý9СʱµÄ±¨±í»òÕßÊÇÒ»¸öºÄʱ3·ÖÖÓµÄÁª»ú²éѯ¡£ÕâЩ“ºÄ·Ñ¾Þ´ó”µÄSQLÈç¹ûÄܵõ½ÓÐЧµ÷Õû£¬ÆäÓÅ»¯¹±Ï×ÂʱØÈ»¿ÉȦ¿Éµã¡£Oracle 10gR2ÖÐADDM(×Ô¶¯Êý¾Ý¿âÕï¶Ï¼àÊÓÆ÷£©¿ÉÒÔÓÃÀ´Ê¶±ð¸ßÏûºÄSQL£¬ÒÔ¼°Ê¹ÓÃSQL¹ËÎʹ¤¾ß½øÐÐÓÅ»¯¡£
³£¼ûÎÊÌâËÄ:ʹÓӷdz£Óõijõʼ»¯²ÎÊý”
   Õâ¿ÉÄÜÊÇ×î³£¼ûµÄ´íÎóÁË£ºÓû§Ê¹ÓÃÁË´óÁ¿×Ô¶¨Òå²ÎÊý£¬²¢ÆÚÍûij¸ö“ÉñÃØ”²ÎÊý»á¸øÏµÍ³´øÀ´ÖʵķÉÔ¾¡£Õâ¸öÎóÇøÀ´Ô´ÓÚÓû§¶ÔOracleÊý¾Ý¿âϵͳ²ÎÊýµÄ²»Àí½â¡£Êµ¼ÊÉÏÎÒÃÇÓ¦¸ÃÏàÐÅÕâÑùÒ»µã£ºÄ¬Èϰ²×°µÄÊý¾Ý¿âÍùÍùÊÊÓ¦ÓÚ´ó¶àÊýÓ¦ÓÃÇé¿ö£¬ÆäÅäÖÿÉÄܾÍÊÇ×îºÃµÄ¡£
³£¼ûÎÊÌâÎ壺Êý¾Ý¿âI/O²»¾ùºâ
Êý¾Ý¿âÔÚAIX½øÐÐÎïÀíʵʩʱ£¬Ôڹ滮Êý¾Ý´æ´¢·½ÃæÓ¦¿¼ÂÇÊý¾Ý´æ·Å¾ùºâ¼°I/O¾ùºâÎÊÌâ¡£Ö¸µ¼Ô­ÔòÊÇI/O²Ù×÷ÔÚ´æ´¢×Óϵͳ´ø¿íÉϵľùºâ¡£ºÜ¶àϵͳ°´ÕÕ´ÅÅÌ»òÕß´æ´¢Âß¼­µ¥Ôª£¨LUN£©´æ´¢Êý¾Ý£¬¶ø²¢·Ç´ø¿íµÄ¾ùºâ£¬Òò´ËÕû¸ö´æ´¢×Óϵͳ²»ÄÜÐγÉI/O¾ùºâ£¬µ¼ÖÂϵͳI/O»ºÂý¡£
³£¼ûÎÊÌâÁù£ºÖØ×öÈÕÖ¾ÉèÖÃÎÊÌâ
Êý¾Ý¿âµÄÈÕÖ¾²»ÄÜ̫С£¬Ò²²»ÄÜÌ«ÉÙ£¬·ñÔòСµÄÖØ×öÈÕÖ¾»áÔì³Éϵͳ¼ì²éµãƵ·±²úÉú£¬¶ÔÊý¾Ý»º´æºÍ´æ´¢×ÓϵͳÔì³ÉI/OѹÁ¦¡£Èç¹ûÖØ×öÈÕÖ¾×é½ÏÉÙ£¬ÔòÓпÉÄÜÐγÉÒò¹éµµÎÊÌâµ¼ÖµÄÈÕÖ¾Çл»µÈ´ý¡£
³£¼ûÎÊÌâÆß£º´ó±íµÄÈ«±íɨÃè
´ï±êµÄÈ«±íɨÃ


Ïà¹ØÎĵµ£º

ORACLEº¯Êý´óÈ«

SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
        A         A      ZERO     ......

Oracle 10g Êý¾Ý¿â°²×°¼°ÅäÖÃ

1¡¢°²×°
2¡¢´´½¨“±¾µØNet·þÎñÃû”
3¡¢PLSQL Developer Á¬½Ó²âÊÔ
4¡¢´´½¨±í¿Õ¼ä
1.´ò¿ªsqlplus¹¤¾ß£º
sqlplus /nolog
2. Á¬½ÓÊý¾Ý¿â£º
conn /as sysdba
3. ´´½¨±í¿Õ¼ä£º
create tablespace camds datafile 'D:\oracle\product\10.2.0\oradata\camds\camds.dbf' size  ......

ͼƬ¶þ½øÖÆ´æÈëORACLEºÍд³ö

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using Syste ......

ORACLEµÄһЩ²éѯ


Ò»¡¢ÐèÒª²éѯµÄÊý¾Ý
1
¡¢²éѯ³öÔÂн´óÓÚ
'SMITH'
µÄËùÓÐÔ±¹¤×ÊÁÏ
    select *from emp where
sal>(select sal from emp where name="SMITH");
2
¡¢²éѯËùÓÐÔ±¹¤µÄÐÕÃû¼°Áìµ¼ÐÕÃû
    select e1.ename,e2.ename from
emp e1,emp e2 where e1.mgr=e2.empno(+);
3
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ