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;
(
Ïà¹ØÎĵµ£º
ÊÂÎñ´¦Àí£ºËùνµÄÊÂÎñ´¦Àí¾ÍÊDZ£Ö¤²Ù×÷µÄÍêÕûÐÔ£¬ËùÓвÙ×÷Ҫôͬʱ³É¹¦£¬ÒªÃ´Í¬Ê±Ê§°Ü¡£
ÔÀíÈçÏ£º
ÔÚOracleÿ¸öÁ¬½Óµ½Êý¾Ý¿âµÄ´°¿Ú£¬Á¬½ÓÖ®ºó½¨Á¢Ò»¸ösession¡£Ò»¸ösessionÀïÃæ¶ÔÊý¾ÝËù×öµÄÐ޸쬲»»áÁ¢¿Ì·´Ó¦ÔÚÊý¾Ý¿âµÄÕæÊµÊý¾ÝÖ®ÉÏ£¬ÊÇÔÊÐí»Ø¹öµÄ£¬µ±Ò»¸ösessionÌá½»ËùÓеIJÙ×÷ºó£¬Êý¾Ý²ÅÕæÕýµØ×ö³öÐ޸ġ£
& ......
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 ......
±¾ÎĽéÉÜÁËʹÓÃPro*C/C++ÔÚVisual
C++»·¾³Ï¿ª·¢OracleÊý¾Ý¿â½Ó¿Ú³ÌÐòµÄ·½·¨
Éè¼ÆË¼Â·ÆäʵÕâÑù£ºÊ×ÏÈͨ¹ýVC½¨Á¢Ò»¸ö¹¤³Ì£¬×Ô¶¯»¯½¨Á¢MAKEFILE£¬UNIXÐèÒª×Ô¼ºÐ´MAKEFILE¡£
Æä´ÎÅäÖÃVCµÄ»·¾³£¬½«PROCµÄ.H£¬.LIBµÄ·¾¶¼ÓÈëDERECTIRY¡£Ð´Ò»¸öPCÎļþ£¬¼´PROCÎļþ¡£·Åµ½¹¤³ÌÏàÓ¦µÄĿ¼Ï¡£È»ºó°ÑPCÎļþ¼ÓÈ빤³Ì¡£Ê¹ÓÃPROCUI.E ......
ÔÚoracleÖУ¬ÓÐ4¸ö´ó¶ÔÏó£¨lobs£©ÀàÐÍ¿ÉÓ㬷ֱðÊÇblob,clob,bfile,nclob¡£
¡¡¡¡ÏÂÃæÊǶÔlobÊý¾ÝÀàÐ͵ļòµ¥½éÉÜ¡£
¡¡¡¡ blob:¶þ½øÖÆlob£¬Îª¶þ½øÖÆÊý¾Ý£¬×¿É´ï4GB£¬´æÖüÔÚÊý¾Ý¿âÖС£
¡¡¡¡ clob:×Ö·ûlob,×Ö·ûÊý¾Ý,×¿ÉÒÔ´ïµ½4GB,´æÖüÔÚÊý¾Ý¿âÖС£
¡¡¡¡ bfile:¶þ½øÖÆÎļþ;´æÖüÔÚÊý¾Ý¿âÖ®ÍâµÄÖ»¶ÁÐͶþ½øÖÆÊý¾Ý£¬×î´ó³¤ ......
oracleÌṩÈýÖָ߼¶±¸·Ý¹¦ÄÜ
¸ß¼¶¸´ÖÆ£¨Advanced Replication£©
Á÷¸´ÖÆ£¨Streams Replication£©
±¸¿â£¨Dataguard£©
Ò» dataguard£º
dataguardÔڸ߿ÉÓü°ÈÝÔÖ·½ÃæÒ»°ãÊÇdbaµÄÊ×Ñ¡£¬²»¹ÜÊÇÎïÀí±¸Óÿ⣨physical standby database£©»¹ÊÇÂß¼±¸Óÿ⣨logical standby database£©£¬ËüÃǶ¼¾ßÓÐһЩ¹²Í¬µÄ´ýÕ÷¡£
ÅäÖú͹ÜÀí· ......