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

oracleµÄ»ù±¾ÖªÊ¶

Oracle
    SqlServer2000 2005
 MySql      
 DB2
 ORACLE   sun  SUN
 
 Êý¾Ý¿â  DataBase  db
    ´æ´¢Êý¾Ý
 Êý¾Ý Data
        Êý×Ö   ·ûºÅ  ×Ö·û ÐÅÏ¢
 DBMS  Êý¾Ý¿â¹ÜÀíϵͳ
    SQL : ½á¹¹»¯²éѯÓïÑÔ
 
 ±ÊÊÔ:  scjp sql    20 - 30%
    Oracle 10g XE
    Oracle 9i 
  
  SQL:
      CRUD
           Ôöɾ¸Ä²é  
     DDL
     DML
     DCL: DBA
 ²éѯÊý¾Ý¿âÖÐËùÓеıí:
     select  table_name  from  user_tables;
     SELECT  Òª²éµÄÊý¾Ý  from  ´ÓÄÄÀï²é
      1. ²éʲô
      2.  ´ÓÄÄÀï²é  
 ²éѯ s_emp ËùÓÐÐÐËùÓÐÁÐ
    select  *  from  s_emp ; 
  
    Ö¸¶¨Áвéѯ (×Ö¶ÎÃûÖ®¼äʹÓöººÅ·Ö¸ô)
    select  first_name , last_name   from  s_emp ; 
    
 SELECT last_name, salary * 12, commission_pct from s_emp;
   
    ʹÓÃNVLº¯Êý¿ÕÖµÎÊÌâ
    SELECT last_name, title, salary*commission_pct/100 + salary      from  s_emp;
    SELECT last_name, title, salary*NVL(commission_pct,0)/100 + salary   from      s_emp;
   
 ×ֶαðÃû
    as  ±ðÃû  " ±ð Ãû "
 ×Ö·ûÁ¬½Ó
 select  first_name || last_name  " ÐÕ Ãû "   from s_emp ;
 
 DISTINCT  &n


Ïà¹ØÎĵµ£º

Oracle±í¿Õ¼ä¹ÜÀí

extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î»      --segment    management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......

Oracle³£ÓÃÃüÁî

ÒÔϾÝ˵ÃüÁî¾ùÖ¸ÔÚPL/SQLÖУ¬ÔÚCommand WindowÖÐÖ´ÐеÄÃüÁî¡£
²»¶ÏËѼ¯ÕûÀí
1¡¢the account is locked"µÄ½â¾ö·½·¨
      ÓÃsysÒÔsysdbaµÄÉí·ÝÀ´½øÐеǼ,ÔÚsys״̬ÊÇlockedµÄʱºòÒ²ÊÇÄܵǼµÄ.È»ºóÔÙʹÓÃÃüÁî
      alter user sys account unlockÀ´½øÐнâËø ......

ÐÞ¸ÄOracleÓû§ÃÜÂëµÄС¾÷ÇÏ

ÓÐʱºòÎÒÃÇ¿ÉÄܲ»ÖªµÀÒ»¸öÓû§µÄÃÜÂ룬µ«ÊÇÓÖÐèÒªÒÔÕâ¸öÓû§×öһЩ²Ù×÷£¬ÓÖ²»ÄÜÈ¥Ð޸ĵôÕâ¸öÓû§µÄÃÜÂ룬Õâ¸öʱºò£¬¾Í¿ÉÒÔÀûÓÃһЩСÇÏÃÅ£¬À´Íê³É²Ù×÷¡£
¾ßÌå²Ù×÷¹ý³ÌÈçÏ£º
SQL*Plus: Release 9.2.0.5.0 - Production on ÐÇÆÚÈÕ 11ÔÂ 21 13:32:34 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reser ......

Oracle CURSORµÄ¼òµ¥Ó÷¨

ǰÑÔ£º
 OracleµÄ¶Ô±í²Ù×÷ÖÐÓÐÒ»ÖÖÀàËÆÓÚDataSetµÄ¶ÔÏó²Ù×÷·½·¨CURSOR£¬Ëü¿ÉÒÔͨ¹ý½¨Á¢±íµÄ²Ù×÷¶ÔÏó»òÕß˵±íµÄÖ¸Õë¶ÔÏóÀ´´ïµ½´Ó±íÀïÃæÌáÈ¡Êý¾ÝµÄ²Ù×÷¡£
˵Ã÷£º
 Ò»°ãͨ¹ýSQLÓïÑÔ¿ÉÒÔÕë¶Ôij¸ö±íµÄijһÐлò¶àÐÐÊý¾Ý½øÐвÙ×÷±ÈÈç˵SELECT£¬UPDATEµÈ¡£ÕâЩ²Ù×÷±ØÐëÒÔSQLÓï¾äµÄÓï·¨¸ñʽÀ´±»½âÊÍÆ÷½âÊͲ¢Ö´ÐС£ÔÚʵ¼ ......

ORACLE Êý¾Ý¿â£¨²éѯ Ö÷¼üÍâ¼üÔ¼Êø£©

 --   ²éѯÍâ¼üÔ¼Êø(²éij±íµÄËùÓи¸±í)  
  select   c.constraint_name,cc.column_name,rcc.owner,rcc.table_name,rcc.column_name  
  from   user_constraints   c,user_cons_columns   cc,user_cons_columns   rcc  
  where   c.owner=' ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ