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

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)
  USING INDEX TABLESPACE student_index;
    È»ºó²åÈ뼸ÐмǼ£º
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&n


Ïà¹ØÎĵµ£º

SQL SERVER 2000ÖзÃÎÊOracleÊý¾Ý¿â·þÎñÆ÷µÄ¼¸ÖÖ·½·¨

ÔÚSQL SERVER 20000ÖзÃÎÊOracleÊý¾Ý¿â·þÎñÆ÷µÄ¼¸ÖÖ·½·¨
1.ͨ¹ýÐм¯º¯Êýopendatasource
ÒªÇó:±¾µØ°²×°Oracle¿Í»§¶Ë
select * from opendatasource('MSDAORA', 'Data Source=XST4;User ID=manager;Password=sjpsjsjs')..MISD.PBCATCOL
ÆäÖУ¬MSDAORAÊÇOLEDB FOR OracleµÄÇý¶¯£¬
×¢Òâ:Óû§ÃûºÍ±íÃûÒ»¶¨Òª´óС£¬·þÎñÆ÷ºÍ ......

SQLServerºÍOracleµÄ³£Óú¯Êý¶Ô±È

1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.È¡Õû£¨½ØÈ¡£©
S:select cast(-1.002 as int) value
O:selec ......

Oracle 10G DataGuard

http://hi.baidu.com/firefly5002/blog/item/5b5719fcb5bd3e1d08244d11.html
Oracle 10G DataGuard
server A: 10.85.10.44 SID=mesdb
target server B: 10.85.10.43
oracle version:10.2.0.1
OS platform : windows 2003
Data GuardĬÈÏÊÇmaximize performance£¬ ¿ÉÒÔÓÃÒÔÏÂÓï¾äÀ´½øÐÐģʽ¼äµÄÇл»¡£
ALTER DATABASE ......

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨

1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
    ²ÎÊý1 IN NUMBER,
    ²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
  ½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......

Oracle Óαê×ܽá+ÕûÀí

ÏîÄ¿ÖÐÐèҪʹÓõ½°´¹æÔòÉú³ÉÐòÁкţ¬¿ªÊ¼µÄ½â¾ö°ì·¨ÊǸù¾ÝÌõ¼þÈ¡µÃ×î´óIDºÅ½øÐзֽâ+1Ôٺϲ¢µÄ½â¾ö·½°¸£¬ºóÀ´·¢ÏÖÈç¹ûÁ½¸ö¿Í»§Í¬Ê±²Ù×÷µÄʱºò³öÏÖÎÊÌ⣺Ìí¼ÓµÄʱºòIDÒѾ­´æÔÚ£¬Ô­ÒòÊÇ£ºAÓû§ÔÚ·ÃÎÊÈ¡µÃµÚMAX(N)¼Ç¼deID£¬µ«ÊÇ»¹Ã»ÓнøÐÐÔö¼Ó²Ù×÷£¬Õâʱ£¬BÓû§Ò²È¡µÃµÚMAX(N)¼Ç¼deID£¬ÕâÊÇ£Á½øÐÐÌí¼Ó²Ù×÷ͬʱ£¬£ÂҲͬʱ½øÐÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ