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

Oracle Óαê

·¢ÏÖһƪ¹ØÓÚÓαêµÄÎÄÕ£¬¸Ð¾õдµÄºÜ²»´í£¬ÏÈÊÕ²ØÁË£»µ«ÊÇÀïÃæÓÐһЩ´íÎó£¬=ÓÐʱ¼äÁËÔÙÕûÀíһϡ£
--------
ÎÒÃǽ«ÌÖÂÛ¸÷ÖÖÓÃÓÚ·ÃÎÊORACLEÊý¾Ý¿âµÄDDLºÍTCLÓï¾ä¡£ 
²éѯ 
    SELECTÓï¾äÓÃÓÚ´ÓÊý¾Ý¿âÖвéѯÊý¾Ý£¬µ±ÔÚPL/SQLÖÐʹÓÃSELECTÓï¾äʱ£¬ÒªÓëINTO×Ó¾äÒ»ÆðʹÓ㬲éѯµÄ·µ»ØÖµ±»¸³ÓèINTO×Ó¾äÖеıäÁ¿£¬±äÁ¿µÄÉùÃ÷ÊÇÔÚDELCAREÖС£SELECT             INTOÓï·¨ÈçÏ£º 
     SELECT [DISTICT|ALL]{*|column[,column,...]} 
     INTO (variable[,variable,...] |record) 
     from {table|(sub-query)}[alias] 
     WHERE............ 
    PL/SQLÖÐSELECTÓï¾äÖ»·µ»ØÒ»ÐÐÊý¾Ý¡£Èç¹û³¬¹ýÒ»ÐÐÊý¾Ý£¬ÄÇô¾ÍҪʹÓÃÏÔʽÓα꣨¶ÔÓαêµÄÌÖÂÛÎÒÃǽ«ÔÚºóÃæ½øÐУ©£¬INTO×Ó¾äÖÐÒªÓÐÓëSELECT×Ó¾äÖÐÏàͬÁÐÊýÁ¿µÄ±äÁ¿¡£INTO×Ó¾äÖÐÒ²¿ÉÒÔÊǼǼ±äÁ¿¡£ 
%TYPEÊôÐÔ 
     ÔÚPL/SQLÖпÉÒÔ½«±äÁ¿ºÍ³£Á¿ÉùÃ÷ΪÄÚ½¨»òÓû§¶¨ÒåµÄÊý¾ÝÀàÐÍ£¬ÒÔÒýÓÃÒ»¸öÁÐÃû£¬Í¬Ê±¼Ì³ÐËûµÄÊý¾ÝÀàÐͺʹóС¡£ÕâÖÖ¶¯Ì¬¸³Öµ·½·¨ÊǷdz£ÓÐÓõ쬱ÈÈç±äÁ¿ÒýÓõÄÁеÄÊý¾ÝÀàÐͺʹóС¸Ä±äÁË£¬Èç¹ûʹÓÃÁË%TYPE,ÄÇôÓû§¾Í²»±ØÐ޸ĴúÂ룬·ñÔò¾Í±ØÐëÐ޸ĴúÂë¡£ 
Àý£º 
  v_empno SCOTT.EMP.EMPNO%TYPE; 
  v_salary EMP.SALARY%TYPE; 
  ¡¡²»µ«ÁÐÃû¿ÉÒÔʹÓÃ%TYPE,¶øÇÒ±äÁ¿¡¢Óαꡢ¼Ç¼£¬»òÉùÃ÷µÄ³£Á¿¶¼¿ÉÒÔʹÓÃ%TYPE¡£Õâ¶ÔÓÚ¶¨ÒåÏàͬÊý¾ÝÀàÐ͵ıäÁ¿·Ç³£ÓÐÓᣠ
    DELCARE 
    V_A NUMBER(5):=10; 
    V_B V_A%TYPE:=15; 
    V_C V_A%TYPE; 
    BEGIN 
      DBMS_OUTPUT.PUT_LINE 
      ('V_A='||V_A||'V_B='||V_B||'V_C='||V_C); 
    END 
    
    SQL>;/ 
  &nbs


Ïà¹ØÎĵµ£º

ÉèÖÃOracleÌáʾ·û

ÔÚ$ORACLE_HOME/sqlplus/admin/login.sql (»òÕßÊÇglogin.sql)ÖÐÌí¼Ó£º
set termout off   
  COLUMN prompter new_value m_prompt     
  select host_name || ':' || instance_name ||' >'  prompter       
  from sys.v_$insta ......

db2,oracle,mysql³£ÓÃÃüÁî±È½Ï


¡¶oracle,db2,mysqlÀà±È¡·×÷ΪÈýÖÖÊý¾Ý¿âÒ»¸öÀà±È£¬Ä¿µÄÔÚÓÚͨ¹ýÀà±È£¬Á˽âÏÖÔÚÊý¾Ý¿âÏàËÆµãÓëÒìͬµã£¬Í¬Ê±¿ÉÒÔ°ïÖú´ó¼ÒÔÚÁ˽âÒ»ÖÖÊý¾Ý¿â£¬Äܹ»Ñ¸ËÙµØÑ§»áÆäËûÊý¾Ý¿â¡£³õ²½¶¨ÒåΪoracle,db2,mysqlÈýÖÖÊý¾Ý¿â£¬ÒÔºó¿ÉÄÜ»¹ÊÇ×·¼Óinformix,sysbase,sql serverµÈÊý¾Ý¿â¡£
±¾Æª×÷ΪÊׯª£¬Ä¿µÄÊÇÈôó¼Ò¶ÔÕâÈýÖÖÊý¾Ý¿â³£ÓõÄÖªÊ ......

rlwrapʹÓ÷½·¨£¨oracleµÄÖ¸ÁîÉÏÏ·­頁¹¤¾ß£©

rlwrapʹÓ÷½·¨
¹Ø¼ü×Ö: rlwrapʹÓ÷½·¨
ÔÚWindows²Ù×÷ϵͳÉÏ,µ±ÔÚDOSÃüÁî´°¿ÚÖÐÔËÐÐSQL*PlusµÄʱºò,¿ÉÒÔʹÓÃÏòÉÏ,ÏòϼüÀ´Ìø»ØÖ®Ç°ÒѾ­Ö´ÐйýµÄSQLÓï¾ä.Äã¿ÉÒÔ¸ù¾ÝÐèÒªÐÞ¸ÄËûÃÇ,È»ºó°´Enter¼üÖØÐÂÌá½»Ö´ÐÐ.
È»¶ø,µ±ÔÚLinux ShellÖÐÔËÐÐSQL*PlusµÄʱºò,²¢²»Ìṩä¯ÀÀÀúÊ·ÃüÁîÐеŦÄÜ.
ΪÁËÔÚLinuxÖдﵽͬÑùµÄÄ¿µÄ,Ä ......

oracle ³£Óú¯Êý

1. select * from emp;
2. select empno, ename, job from emp;
3. select empno ±àºÅ, ename ÐÕÃû, job ¹¤×÷ from emp;
4. select job from emp;
5. select distinct job from emp;
6. select distinct empno, job from emp;
˵Ã÷:ÒòΪ¹ÍÔ±±àºÅ²»Öظ´, ËùÒÔ´Ëʱ֤Ã÷ËùÓеÄÁÐûÓÐÖØ¸´,ËùÒÔ²»ÄÜÏû ......

OracleÖÐKill sessionµÄÑо¿

ÎÒÃÇÖªµÀ,ÔÚOracleÊý¾Ý¿âÖÐ,¿ÉÒÔͨ¹ýkill sessionµÄ·½Ê½À´ÖÕÖ¹Ò»¸ö½ø³Ì,Æä»ù±¾Óï·¨½á¹¹Îª:
alter system kill session 'sid,serial#' ;
±»killµôµÄsession,״̬»á±»±ê¼ÇΪkilled,Oracle»áÔÚ¸ÃÓû§ÏÂÒ»´ÎtouchʱÇå³ý¸Ã½ø³Ì.
ÎÒÃÇ·¢ÏÖµ±Ò»¸ösession±»killµôÒԺ󣬸ÃsessionµÄpaddr±»Ð޸ģ¬Èç¹ûÓжà¸ösession±»kill£¬ÄÇô¶ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ