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

Oracle Database µÄѧϰ±Ê¼Ç

SQL:½á¹¹»¯²éѯÓïÑÔ
C R U D: Ôöɾ¸Ä²é
table :  name  age  score
desc+±íÃû    ---> ²éѯ±í½á¹¹
»òÕßÓà describe ÃüÁî (descÊÇdescribeµÄ¼òд)
²éѯÓïÑÔ£ºSELECT [DISTINCT] {*,column[alias],...} from table;
  SELECT identifies what columns from identifies which table
 ******* SELECT  ²éʲô  from  ´ÓÄÄÀï²é *******
 
 SELECT dept_id,last_name,manager_id from s_emp;
 Óöµ½¿Õֵʱ¿ÉÒÔÕâÑù²Ù×÷£º
  SELECT last_name,title,salary*NVL(commission_pct,0)/100 COMM from s_emp;
 Åųý²éѯʱ³öÏÖÖØÃûÏÖÏó £¬Óùؼü×Ö DISTINCT
   eg:  SELECT DISTINCT name from s_dept;
 ÅųýÁ½¸ö×Ö¶ÎÁ¬ºÏÆðÀ´»¹ÓÐÖØ¸´µÄÏÖÏó£º
   eg:  SELECT DISTINCT dept_id,title from s_emp;
 ¶Ô²éѯµÄ½á¹û½øÐÐÅÅÐòÓà ORDER BY;
   eg:  SELECT last_name "ÐÕÃû",salary "¹¤×Ê" from s_emp ORDER BY salary;
   (ĬÈÏÊÇÉýÐòÅÅÐò)
   eg:  SELECT last_name "ÐÕÃû",salary "¹¤×Ê" from s_emp ORDER BY salary asc;
   (ascÖ¸¶¨ÎªÉýÐòÅÅÐò)
   eg:  SELECT last_name "ÐÕÃû",salary "¹¤×Ê" from s_emp ORDER BY salary desc;
   (descÖ¸¶¨Îª½µÐòÅÅÐò)
 
  ×ܽ᣺order by ÅÅÐò
        asc      ÉýÐò
        desc     ½µÐò
  select last_name EMPLOYEE,start_date from s_emp order by EMPLOYEE desc;
  (ÔÚÅÅÐòµÄʱºò¿ÉÒÔÓñðÃûµ±×ö×Ö¶Î[ÅÅÐòµÄ¸ù¾Ý]½øÐÐÅÅÐò)--->ÕâÀïÊÇ£¨EMPLOYEE£©¡£
  select last_name,salary*12 from s_emp order by 2;
  (ÕâÀïµÄ2ÊÇÓÃÀ´Ö¸¶¨×ֶεÄλÖã¬ÕâÀïÖ¸Ïò salary*12 ,¼´°´Ô±¹¤µÄÄêнÅÅÐò)
  select last_name,dept_id,salary from s_emp order by dept_id,salary desc;
  (ÏȰ´dept_idµÄÉýÐò½øÐÐÅÅÐò£¬ÅÅÍêºóÔÙ°´salaryµÄ½µÐò½øÐÐÅÅÐò)
  ×¢£ºÕâÀïdept_idºóûÓÐÖ±½ÓÖ¸ÅÅÐò¹æÔò£¬°´Ä¬ÈϵÄÉýÐòÅÅÐò¡£
 
  WHERE¹Ø¼ü×Ö£º
  SELECT ÐÕÃû£¬²¿ÃÅID from s_emp WHERE dept_id = 42;
  (


Ïà¹ØÎĵµ£º

oracle ´æ´¢¹ý³Ì¼òÊö

´æ´¢¹ý³Ì¾ÍÊÇ×÷Ϊ¿ÉÖ´ÐжÔÏó´æ·ÅÔÚÊý¾Ý¿âÖеÄÒ»¸ö»ò¶à¸öSQLÃüÁî¡£
       ¶¨Òå×ÜÊǺܳéÏó¡£´æ´¢¹ý³ÌÆäʵ¾ÍÊÇÄÜÍê³ÉÒ»¶¨²Ù×÷µÄÒ»×éSQLÓï¾ä£¬Ö»²»¹ýÕâ×éÓï¾äÊÇ·ÅÔÚÊý¾Ý¿âÖеÄ(ÕâÀïÎÒÃÇ̸ֻSQL Server)¡£Èç¹ûÎÒÃÇͨ¹ý´´
½¨´æ´¢¹ý³ÌÒÔ¼°ÔÚASPÖе÷Óô洢¹ý³Ì£¬¾Í¿ÉÒÔ±ÜÃ⽫SQLÓï¾äͬASP´úÂë»ìÔÓ ......

oracle scnÑо¿

ÉîÈëÁ˽âOracle SCN (1)
--------------------------------------------------------------------------------
£Û˵Ã÷£Ý±¾À´ÔÚÑо¿Backup and Recovery£¬¿ÉÊÇÔÚ×öʵÑéµÄʱºòÓöµ½Ò»Ð©ÎÊÌâ²»ÊǺÜÀí½â£¬½ø¶ø×·¸ùÇóÔ´£¬Ïë¸ãÇå³þ£¬ÓÚÊDZØÐë¸ãÇå³þSCNºÍRecoveryÖ®¼äµÄ¹ØÏµ¡£ÓÚÊǺõת¶øÑо¿SCN£¬ÕâÁ½Ìì¿´Á˺ܶàÎÄÕ£¬°üÀ¨EygleÍ ......

oracle database system parameters on sol9

* start Oracle *
set noexec_user_stack=1
set msgsys:msginfo_msgmax=65535
set msgsys:msginfo_msgmnb=65535
set msgsys:msginfo_msgmap=258
set msgsys:msginfo_msgmni=1792
set msgsys:msginfo_msgssz=32
set msgsys:msginfo_msgtql=1792
set msgsys:msginfo_msgseg=32767
set shmsys:shminfo_shmmax=4294967 ......

oracle Îóɾ³ýÈÕÖ¾ÎļþºóµÄ´¦Àí·½·¨£¡


oracle
Îóɾ³ýÈÕÖ¾ÎļþºóµÄ´¦Àí·½·¨£¡
½â¾ö·½·¨±³¾°

ÕûÀíc
Å̵ÄÀ¬»øÎļþ£¬°Éoralce
µÄ¡£log
ÈÕÖ¾Îļþɾ³ý¡£

È»ºóoralce
Ò»Ö±²»ÄÜʹÓã¬Ìáʾtns
ÓÐÎÊÌ⣬
È»ºóÔÙÍùÉÏÕÒ×ÊÁÏ£¬Ò»Ö±Ã»Óнâ¾öµô£¬ºóÀ´¿´µ½Ò»±ßÎÄÕÂÈçÏ£¬ÎÊÌâ½â¾öµôÁË£¬Ìغʹó¼Ò·ÖÏí£¡
======================================== ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ