²»°²×°oracle¿Í»§¶Ë²¿ÊðPBÓ¦ÓÃ
££Õª×Ô¡¶PB8.0½ø½×ƪ¡·
ÔÚ°²×°ÁËOracle¿Í»§¶Ë³ÌÐòºó£¬ÔÚOracle°²×°Ä¿Â¼ÏÂÓÐÈçÏÂĿ¼ºÍÎļþÊÇÁ¬½ÓOracleÊý¾Ý¿â·þÎñÆ÷Ëù±ØÐèµÄ£º£¨×îºÃ±£³ÖĿ¼²ã´Î¹Øϵ½á¹¹£©
Oracle\BINĿ¼ÒÔ¼°ÏÂÃæµÄËùÓÐDLLÎļþ£¬²¢ÇÒ±£Ö¤Ó¦ÓóÌÐò¿ÉÒÔÕÒµ½¸ÃĿ¼£¬¼´¸ÃĿ¼ΪϵͳĿ¼»òÕßPATHĿ¼¡£
Oracle\OCOMMON\NLS\ADMINĿ¼ÒÔ¼°ÆäÏÂËùÓÐÎļþ
Oracle\OCOMMON\NLS\MESGĿ¼ÒÔ¼°ÆäÏÂËùÓÐÎļþ
Oracle\NETWORK\tnsnames.ora
Oracle\ORACORE\MesgÒÔ¼°ÆäÏÂËùÓÐMSBÎļþ
PowerBuilder³ÌÐòÐèÒª£ºPBO8480.DLL¡¢PBVM80.DLL¡¢PBDWE80.DLL¡¢libjcc.dll
Ìí¼ÓÈçÏÂ×¢²á±í£º
=====================================================================
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
"ORACLE_HOME"="E:\\oracle" //°²×°Ê±È·¶¨µÄOracle¿Í»§¶Ë°²×°Ö÷Ŀ¼
"ORACLE_HOME_NAME"="iSuites" //OracleÖ÷Ŀ¼Ãû³Æ
"NLS_LANG"="NA"
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES]
"HOME_COUNTER"="1"//Ö÷Ŀ¼¸öÊý
"DEFAULT_HOME"="Oracle815"//ȱʡµÄÖ÷Ŀ¼Ãû³Æ
"LAST_HOME"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES\ID0]
"NAME"="Oracle815"//µÚÒ»¸öÖ÷Ŀ¼Ãû³Æ
"PATH"="E:\\oracle" //Oracle°²×°Ä¿Â¼
"NLS_LANG"="NA"
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0]
"ORACLE_HOME_NAME"="Oracle815"//Ö÷Ŀ¼Ãû³Æ &
Ïà¹ØÎĵµ£º
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
ÔÀ´ÓõÄSQL server£¬Ö÷ÒªÓÐÁ½ÖÖ·ÖÒ³·½·¨£ºÓαêºÍÆ´×Ö·û´®£¬Óα귨̫Âý£¬Æ´´®·¨Ò²ÓÐһЩȱÏÝ¡£
ÏÖÔÚÕÒµ½ÁËÒ»¸öOracleµÄ·ÖÒ³·½·¨£¬Ò²¿ÉÒÔ˵ÊÇÆ´×Ö·û´®£¬µ«ÊÇÓÃÆðÀ´¾Í±ÈSQL serverµÄÒª·½±ã£¬Ã»ÓÐ֮ǰµÄÎÊÌ⣺
SELECT * from
(
SELECT A.*, ROWNUM RN
from (SELECT * from TABLE_NAME) A
WHERE ROWNUM <= 40
)
W ......
ÎÊÌâÌá³ö£º
Ò»¸ö¸ß¼¶SQLÓï¾äÎÊÌâ
¼ÙÉèÓÐÒ»ÕÅ±í£¬ÓÐÕâÑùһЩÊý¾Ý
a b
1 2
0 2
2 3
3 4
4
5 6
6 7
12 7
7
aÊÇ×Ó½Úµã bÊǸ¸½Úµã ,Èç¹ûbΪnull ÔòΪһ¿ÃÊ÷µÄ¸ù½Úµã
¸ù¾ÝAÓëBµÄÕâ¸ö¹Øϵ ÕÒ³öÒ»¿ÃÊ÷µÄ½á¹¹ÏÔʾ³öÀ´ £¬²¢ÏÔʾ³öÿ¸ö½ÚµãÔÚÊéÖеIJ㼶£¬½«Ê÷µÄ½á¹¹´ò ......
-- ²éѯÍâ¼üÔ¼Êø(²éij±íµÄËùÓи¸±í)
select c.constraint_name,cc.column_name,rcc.owner,rcc.table_name,rcc.column_name
from user_constraints c,user_cons_columns cc,user_cons_columns rcc
where c.owner=' ......
ÏîÄ¿¾ÀíÈÃ×öÀúÊ·Êý¾Ý±¸·Ý£¬Éæ¼°µ½ÈçºÎ½«ÒµÎñ±íÖеļǼµ¼³öµ½ÀúÊ·±íÖУ¬×Ô¼º×ʼÏëÄѵÀÊǸú×Ô¶¯¶ÔÕ˺Í×Ô¶¯ÉÏ´«³ÌÐòÒ»Ñùд¸ö³ÌÐòÈ»ºó½«³ÌÐò·ÅÔÚϵͳµÄÈÎÎñ¼Æ»®ÀﶨʱÔËÐУ¿»¹ÊÇÎÊÎÊÏîÄ¿¾Àí°É£¬ÎÊÏîÄ¿¾Àí£¬Äǵ¼³ö¼Ç¼Ôõô×ö¡£ÏîÄ¿¾Àí˵£¬Êý¾Ý¿âÀïÓ¦¸ÃÓÐÕâ¸ö¹¦ÄÜ°É¡£»ÐÈ»´óÎò£¬ÒþÔ¼¼ÇµÃÖ ......