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

¡¾×ª¡¿ORACLEÓû§Á¬½ÓµÄ¹ÜÀí

ÓÃϵͳ¹ÜÀíÔ±£¬²é¿´µ±Ç°Êý¾Ý¿âÓм¸¸öÓû§Á¬½Ó£º

SQL> select username,sid,serial# from v$session;

Èç¹ûҪͣij¸öÁ¬½ÓÓÃ

SQL> alter system kill session 'sid,serial#';

Èç¹ûÕâÃüÁî²»ÐÐ,ÕÒËüUNIXµÄ½ø³ÌÊý

SQL> select pro.spid from v$session ses,v$process pro where ses.sid=21 and ses.paddr=pro.addr;

˵Ã÷£º21ÊÇij¸öÁ¬½ÓµÄsidÊý

È»ºóÓà kill ÃüÁîɱ´Ë½ø³ÌºÅ¡£

Îå¡¢SQL*PLUSʹÓÃ
a¡¢½üÈëSQL*Plus
$sqlplus Óû§Ãû/ÃÜÂë

Í˳öSQL*Plus
SQL>exit

b¡¢ÔÚsqlplusϵõ½°ïÖúÐÅÏ¢
ÁгöÈ«²¿SQLÃüÁîºÍSQL*PlusÃüÁî
SQL>help
Áгöij¸öÌض¨µÄÃüÁîµÄÐÅÏ¢
SQL>help ÃüÁîÃû

c¡¢ÏÔʾ±í½á¹¹ÃüÁîDESCRIBE
SQL>DESC ±íÃû

d¡¢SQL*PlusÖеı༭ÃüÁî
ÏÔʾSQL»º³åÇøÃüÁî
SQL>L

ÐÞ¸ÄSQLÃüÁî
Ê×ÏÈÒª½«´ý¸ÄÕýÐбäΪµ±Ç°ÐÐ
SQL>n
ÓÃCHANGEÃüÁîÐÞ¸ÄÄÚÈÝ
SQL>c/¾É/ÐÂ
ÖØÐÂÈ·ÈÏÊÇ·ñÒÑÕýÈ·
SQL>L

ʹÓÃINPUTÃüÁî¿ÉÒÔÔÚSQL»º³åÇøÖÐÔö¼ÓÒ»Ðлò¶àÐÐ
SQL>i
SQL>ÊäÈëÄÚÈÝ

e¡¢µ÷ÓÃÍⲿϵͳ±à¼­Æ÷
SQL>edit ÎļþÃû
¿ÉÒÔʹÓÃDEFINEÃüÁîÉèÖÃϵͳ±äÁ¿EDITORÀ´¸Ä±äÎı¾±à¼­Æ÷µÄÀàÐÍ£¬ÔÚlogin.sqlÎļþÖж¨ÒåÈçÏÂÒ»ÐÐ
DEFINE_EDITOR=vi

f¡¢ÔËÐÐÃüÁîÎļþ
SQL>START test
SQL>@test

³


Ïà¹ØÎĵµ£º

oracle ÔöÁ¿±¸·Ý½Å±¾


    OS :RHEL AS 4 oracle 10g
    0±¸·Ý½Å±¾
    #!/bin/bash
    # incremental level 0 backup script
    source /home/oracle/.bash_profile
    current_day=`date +%Y%m%d`
    mkdir /home/ora ......

¡¾×ªÌû¡¿SQL Oracleɾ³ýÖظ´¼Ç¼

1.Oracleɾ³ýÖظ´¼Ç¼.
ɾ³ý±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´Åжϣ¬Ö»ÁôÓÐrowid×îСµÄ¼Ç¼.
delete from people
where peopleId  in (select  peopleId  from people  group  by  peopleId   having  count(peopleId) > 1)
and rowid not i ......

oracle 10gÊý¾Ý¿â±¸·ÝÓ뻹ԭ×ܽá(תÔØ£©

1.Êý¾Ý¿â¹éµµÄ£Ê½:
        * ·Ç¹éµµÄ£Ê½:µ±Êý¾Ý¿âÊý¾ÝÖ»¶Á²»»á¸Ä±äʱ,Êý¾Ý²»»á¸Ä±ä,Êý¾Ý¿âÊʺÏÓ÷ǹ鵵ģʽ,                     ÕâÑùÌá¸ßÐÔÄÜ
    &nb ......

OracleÖÐrownumµÄʹÓÃ

ÔÚʹÓÃOracleÖÐʹÓÃRownum£¬»áÓÐЩÎó½â£¬ÏÖÕûÀíÏÂÍøÓÑÃǵÄÎÄÕ£¬Ï£ÍûÄÜÓÐËù°ïÖú£¬ºÇºÇ
¶ÔÓÚ Oracle µÄ rownum ÎÊÌ⣬ºÜ¶à×ÊÁ϶¼Ëµ²»Ö§³Ö>,>=,=,between...and£¬Ö»ÄÜÓÃÒÔÉÏ·ûºÅ(<¡¢<=¡¢!=)£¬²¢·Ç˵ÓÃ>,>=,=,between..and ʱ»áÌáʾSQLÓï·¨´íÎ󣬶øÊǾ­³£ÊDz鲻³öÒ»Ìõ¼Ç¼À´£¬»¹»á³öÏÖËƺõÊÇĪÃûÆäÃîµÄ½á¹û ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ