Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 Êý¾Ý¿â ÊÂÎñ´¦Àí»ù±¾Ô­Àí

 
ÊÂÎñ´¦Àí£ºËùνµÄÊÂÎñ´¦Àí¾ÍÊDZ£Ö¤²Ù×÷µÄÍêÕûÐÔ£¬ËùÓвÙ×÷Ҫôͬʱ³É¹¦£¬ÒªÃ´Í¬Ê±Ê§°Ü¡£
Ô­ÀíÈçÏ£º
ÔÚOracleÿ¸öÁ¬½Óµ½Êý¾Ý¿âµÄ´°¿Ú£¬Á¬½ÓÖ®ºó½¨Á¢Ò»¸ösession¡£Ò»¸ösessionÀïÃæ¶ÔÊý¾ÝËù×öµÄÐ޸쬲»»áÁ¢¿Ì·´Ó¦ÔÚÊý¾Ý¿âµÄÕæÊµÊý¾ÝÖ®ÉÏ£¬ÊÇÔÊÐí»Ø¹öµÄ£¬µ±Ò»¸ösessionÌá½»ËùÓеIJÙ×÷ºó£¬Êý¾Ý²ÅÕæÕýµØ×ö³öÐ޸ġ£
& ......

oracleÃüÁî ÊÕ²Ø

  oracleÃüÁî ÊÕ²Ø
1. ORACLEÊý¾Ý¿âÆô¶¯Óë¹Ø±Õ
1.1 ´ò¿ªºÍ¹Ø±ÕÊý¾Ý¿â (ÊÖ¹¤)
1.1.1 sqlplusÁ¬½Ó
  #su - oracle
#sqlplus  /nolog
1.1.2 ´ò¿ªÊý¾Ý¿â
sql> connect sys/oracle as sysdba;
  sql> startup [nomount|mount]
µÈ´ýÊ®¼¸Ãë×óÓÒ£¬µ±¿´µ½
oracle instances started,
databa ......

VCÏÂÀûÓÃPro*C¿ª·¢Oracle½Ó¿Ú

±¾ÎĽéÉÜÁËʹÓÃPro*C/C++ÔÚVisual
C++»·¾³Ï¿ª·¢OracleÊý¾Ý¿â½Ó¿Ú³ÌÐòµÄ·½·¨
Éè¼ÆË¼Â·ÆäʵÕâÑù£ºÊ×ÏÈͨ¹ýVC½¨Á¢Ò»¸ö¹¤³Ì£¬×Ô¶¯»¯½¨Á¢MAKEFILE£¬UNIXÐèÒª×Ô¼ºÐ´MAKEFILE¡£
Æä´ÎÅäÖÃVCµÄ»·¾³£¬½«PROCµÄ.H£¬.LIBµÄ·¾¶¼ÓÈëDERECTIRY¡£Ð´Ò»¸öPCÎļþ£¬¼´PROCÎļþ¡£·Åµ½¹¤³ÌÏàÓ¦µÄĿ¼Ï¡£È»ºó°ÑPCÎļþ¼ÓÈ빤³Ì¡£Ê¹ÓÃPROCUI.E ......

¹ØÓÚoracleÖÐblob×ֶεļÈëÎÊÌâ

ÔÚoracleÖУ¬ÓÐ4¸ö´ó¶ÔÏó£¨lobs£©ÀàÐÍ¿ÉÓ㬷ֱðÊÇblob,clob,bfile,nclob¡£
¡¡¡¡ÏÂÃæÊǶÔlobÊý¾ÝÀàÐ͵ļòµ¥½éÉÜ¡£
¡¡¡¡ blob:¶þ½øÖÆlob£¬Îª¶þ½øÖÆÊý¾Ý£¬×¿É´ï4GB£¬´æÖüÔÚÊý¾Ý¿âÖС£
¡¡¡¡ clob:×Ö·ûlob,×Ö·ûÊý¾Ý,×¿ÉÒÔ´ïµ½4GB,´æÖüÔÚÊý¾Ý¿âÖС£
¡¡¡¡ bfile:¶þ½øÖÆÎļþ;´æÖüÔÚÊý¾Ý¿âÖ®ÍâµÄÖ»¶ÁÐͶþ½øÖÆÊý¾Ý£¬×î´ó³¤ ......

oracle¸ß¼¶¸´ÖÆÖ®Ò»—ÈýÖÖ¸´ÖƼ¼ÊõÌØµã

oracleÌṩÈýÖָ߼¶±¸·Ý¹¦ÄÜ
¸ß¼¶¸´ÖÆ£¨Advanced Replication£©
Á÷¸´ÖÆ£¨Streams Replication£©
±¸¿â£¨Dataguard£©
Ò» dataguard£º
dataguardÔڸ߿ÉÓü°ÈÝÔÖ·½ÃæÒ»°ãÊÇdbaµÄÊ×Ñ¡£¬²»¹ÜÊÇÎïÀí±¸Óÿ⣨physical standby database£©»¹ÊÇÂß¼­±¸Óÿ⣨logical standby database£©£¬ËüÃǶ¼¾ßÓÐһЩ¹²Í¬µÄ´ýÕ÷¡£
ÅäÖú͹ÜÀí· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ