oracleºÍsqlserver²éѯʱ×èÈûÇé¿ö
1.oracle»·¾³
create table test
(
id number(4),
name varchar2(20)
)
ÔÚÒ»¸ösessionÖÐ
insert into test values(1,'aa');
ÔÚÁíÒ»¸ösessionÖÐ
select * from test1;
²éѯû±»×èÈû
2.sqlserver»·¾³
ÔÚÒ»¸ösessionÖÐ
insert into test values(1,'aa');
ÔÚÁíÒ»¸ösessionÖÐ
select * from test1;
²éѯ±»×èÈû(ʵ¼ÊÉÏǰһ¸ösessionÔÚupdate»òdeleteʱ¾ù»á×èÈû±¾´Î²éѯ,µ±È»,Èç¹û¼ÓÉÏwith (nolock),Ò²²»»á±»×èÈû)
Ïà¹ØÎĵµ£º
´úÂëÈçÏÂ:
DECLARE
@TempTable table(UserID int , UserName nvarchar(50));
insert into
@TempTable (UserID,UserName) values (1,'a')
insert into @TempTable
(UserID,UserName) values (2,'b')
select UserID,UserName
from @TempTable FOR XML PATH
ÔËÐÐÕâ¶Î½Å±¾£¬½«Éú³ÉÈçϽá¹û£º
¸´ÖÆ´úÂë
......
¶ÔÓÚÍâÁ¬½Ó£¬OracleÖпÉÒÔʹÓÓ(+)”À´±íʾ£¬9i¿ÉÒÔʹÓÃLEFT/RIGHT/FULL OUTER JOIN£¬ÏÂÃæ½«ÅäºÏʵÀýÒ»Ò»½éÉÜ¡£
1. LEFT OUTER JOIN£º×óÍâ¹ØÁª
SELECT e.last_name, e.department_id, d.department_name
from employees e
LEFT OUTER JOIN department ......
select dbtimezone from dual ; --²é¿´Êý¾Ý¿âÊ±Çø
select sessiontimezone from dual ; --²é¿´»á»°Ê±Çø
1.select u.name || '.' || o.name || '.' || c.name TSLTZcolumn
from sys.obj$ o, sys.col$ c, sys.user$ u
&nbs ......
ÍÆ¼öcrs°æ±¾¸ßÓÚdb°æ±¾
If you also plan to apply this patch to Oracle Clusterware,
ensure that you apply the patch to Oracle Clusterware before
applying it to Oracle Database. This is because Oracle Clusterware
hould always be at the same or later version as the database.
Éæ¼°µ½Êý¾Ý¿â¶ø²»ÊÇʵÀýµ ......
¤½¤ÎËû¤Î¥ª¥Ú¥ìー¥Æ¥£¥ó¥°?¥·¥¹¥Æ¥à¤Ë¤ª¤±¤ë¥Çー¥¿¥Ùー¥¹¤ÎÆð動¤ÈÍ£Ö¹¤Î×Ô動»¯
dbstart¤ª¤è¤Ódbshut¥¹¥¯¥ê¥×¥È¤òʹÓ䷤ƥÇー¥¿¥Ùー¥¹¤ÎÆð動¤ÈÍ£Ö¹¤ò×Ô動»¯¤¹¤ë¤Ë¤Ï¡¢´Î¤ÎÊÖ順¤ò実ÐФ·¤Þ¤¹¡£
root¥æー¥¶ー¤Ç¥í¥°¥¤¥ó¤·¤Þ¤¹¡£
¥×¥é¥Ã¥È¥Õ ......