Oracle¶¨ÒåÔ¼Êø Íâ¼üÔ¼Êø
Íâ¼üÔ¼Êø±£Ö¤²ÎÕÕÍêÕûÐÔ¡£Íâ¼üÔ¼ÊøÏÞ¶¨ÁËÒ»¸öÁеÄȡֵ·¶Î§¡£Ò»¸öÀý×Ó¾ÍÊÇÏÞ¶¨ÖÝÃûËõдÔÚÒ»¸öÓÐÏÞÖµ¼¯ºÏÖУ¬Õâ¸öÖµ¼¯ºÏÊÇÁíÍâÒ»¸ö¿ØÖƽṹ——Ò»ÕŸ¸±í
ÏÂÃæÎÒÃÇ´´½¨Ò»ÕŲÎÕÕ±í£¬ËüÌṩÁËÍêÕûµÄÖÝËõдÁÐ±í£¬È»ºóʹÓòÎÕÕÍêÕûÐÔÈ·±£Ñ§ÉúÃÇÓÐÕýÈ·µÄÖÝËõд¡£µÚÒ»ÕűíÊÇÖݲÎÕÕ±í£¬State×÷ΪÖ÷¼ü
CREATE TABLE state_lookup
(state VARCHAR2(2),
state_desc VARCHAR2(30)) TABLESPACE student_data;
ALTER TABLE state_lookup
ADD CONSTRAINT pk_state_lookup PRIMARY KEY (state);
È»ºó²åÈ뼸ÐмǼ£º
INSERT INTO state_lookup VALUES ('CA', 'California');
INSERT INTO state_lookup VALUES ('NY', 'New York');
INSERT INTO state_lookup VALUES ('NC', 'North Carolina');
ÎÒÃÇͨ¹ýʵÏÖ¸¸×Ó¹ØÏµÀ´±£Ö¤²ÎÕÕÍêÕûÐÔ£¬Í¼Ê¾ÈçÏÂ
--------------- Íâ¼ü×ֶδæÔÚÓÚStudents±íÖÐ
|State_lookup | ÊÇState×Ö¶Î
--------------- Ò»¸öÍâ¼ü±ØÐë²ÎÕÕÖ÷¼ü»òUnique×Ö¶Î
| Õâ¸öÀý×ÓÖУ¬ÎÒÃDzÎÕÕµÄÊÇState×Ö¶Î
| ËüÊÇÒ»¸öÖ÷¼ü×ֶΣ¨²Î¿´DDL£©
/|\
---------------
| Students |
---------------
ÉÏͼÏÔʾÁËState_Lookup±íºÍStudents±í¼äÒ»¶Ô¶àµÄ¹ØÏµ£¬State_Lookup±í¶¨ÒåÁËÖÝËõдͨÓü¯ºÏ——ÔÚ±íÖÐÿһ¸öÖݳöÏÖÒ»´Î¡£Òò´Ë£¬State_Lookup±íµÄÖ÷¼üÊÇState×ֶΡ£
State_Lookup±íÖеÄÒ»¸öÖÝÃû¿ÉÒÔÔÚStudents±íÖгöÏÖ¶à´Î¡£ÓÐÐí¶àѧÉúÀ´×Ôͬһ¸öÖÝ£¬Ò»´Î£¬ÔÚ±íState_LookupºÍStudentsÖ®¼ä²ÎÕÕÍêÕûÐÔʵÏÖÁËÒ»¶Ô¶àµÄ¹ØÏµ¡£
Íâ¼üͬʱ±£Ö¤Students±íÖÐState×ֶεÄÍêÕûÐÔ¡£Ã¿Ò»¸öѧÉú×ÜÊÇÓиöState_lookup±íÖгÉÔ±µÄÖÝËõд¡£
Íâ¼üÔ¼Êø´´½¨ÔÚ×Ó±í¡£ÏÂÃæÔÚstudents±íÉÏ´´½¨Ò»¸öÍâ¼üÔ¼Êø¡£State×ֶβÎÕÕstate_lookup±íµÄÖ÷¼ü¡£
1¡¢´´½¨±í
CREATE TABLE students
(student_id VARCHAR2(10) NOT NULL,
stu
Ïà¹ØÎĵµ£º
´óÐÍÏîÄ¿¿ª·¢ÖУ¬³£ÓõÄÊý¾Ý¿â£¬µ±ÊôOracle¡£µ«Oracle
¿Í»§¶Ë°²×°¾ÍÒªÒ»ÕŹâÅÌ£¬Ìå»ýºÜ´ó¡£¶øÇÒ°²×°ºó£¬»ù±¾ÉϾÍÓÃ2¸ö¹¦ÄÜ£ºTNSÅäÖ÷þÎñÃû£¬SqlPlus¡£ÔÚ¿ª·¢¹ý³ÌÖУ¬´óÁ¿Ê¹ÓÃToadºÍPL/SQL
Developer¡£Òò´Ë£¬Oracle¿Í»§¶Ë°²×°ÅÌ£¬½ö½öÊDZ»×÷Ϊһ¸öÇý¶¯¶øÐèÒª£¬¸ù±¾Ã»±ØÒª×°ÄÇô´óµÄ¿Õ¼ä¡£Òò´Ë£¬±¾Îĸø³öÁËÈçºÎʹÓþ«¼òµÄ
......
ORACLE PL/SQLÓëSQL SERVER T-SQLһЩ±È½Ï
×Ö·û´®Á¬½Ó
OracleÓÃ|| ·ûºÅ×÷ΪÁ¬½Ó·û£¬¶øSQL ServerµÄÁ¬½Ó·ûÊǼӺţº+ ¡£
Oracle²éѯÈçÏÂËùʾ£ºSelect ‘Name’ || ‘Last Name’ from tableName
SQL Server²éѯÈçÏ£ºSelect ‘Name’ + ‘Last Name’
GUID
OracleÓÃSYS_GUID ......
ORACLE³£ÓÃSQLÓÅ»¯hintÓï¾ä
http://oracle.chinaitlab.com/induction/802186.html
ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬ÎÒÃǾ³£»áÓõ½hint,ÏÖ×ܽáÒ»ÏÂÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracle HINTµÄÓ÷¨£º
¡¡¡¡1. /*+ALL_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
¡¡¡¡ÀýÈç:
¡¡¡¡SELECT /*+ALL+_ROW ......
ORACLEÎïÀíÉÏÊÇÓÉ´ÅÅÌÉϵÄÒÔϼ¸ÖÖÎļþ:Êý¾ÝÎļþºÍ¿ØÖÆÎļþºÍLOGFILE¹¹³ÉµÄ ±í¿Õ¼ä¾Í̸ֻÏà¹ØµÄÊý¾ÝÎļþ Ê×ÏÈÃ÷È·¸ÅÄî:±í¿Õ¼äÊÇORACLEÄÚ²¿¶¨ÒåµÄÒ»¸ö¸ÅÄî,ÊÇΪÁËͳһORACLEÎïÀíºÍÂß¼ ÉϵĽṹ¶ø×¨ÃލÁ¢µÄ,´ÓÎïÀíÉÏÀ´Ëµ,Ò»¸ö±í¿Õ¼äÊÇÓɾßÌåµÄÒ»¸ö»ò¶à¸ö´ÅÅÌÉÏÊý ¾ÝÎļþ¹¹³ÉµÄ(ÖÁÉÙ1¶Ô1,¿ÉÒÔ1¶Ô¶à),´ÓÂß¼ÉÏÀ´ËµÒ»¸ö±í¿Õ¼äÊ ......
oracleÌṩÈýÖָ߼¶±¸·Ý¹¦ÄÜ
¸ß¼¶¸´ÖÆ£¨Advanced Replication£©
Á÷¸´ÖÆ£¨Streams Replication£©
±¸¿â£¨Dataguard£©
Ò» dataguard£º
dataguardÔڸ߿ÉÓü°ÈÝÔÖ·½ÃæÒ»°ãÊÇdbaµÄÊ×Ñ¡£¬²»¹ÜÊÇÎïÀí±¸Óÿ⣨physical standby database£©»¹ÊÇÂß¼±¸Óÿ⣨logical standby database£©£¬ËüÃǶ¼¾ßÓÐһЩ¹²Í¬µÄ´ýÕ÷¡£
ÅäÖú͹ÜÀí· ......