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

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),Ò²²»»á±»×èÈû)


Ïà¹ØÎĵµ£º

sqlserver FOR XML PATH Óï¾äµÄÓ¦ÓÃ

´úÂëÈçÏÂ:

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 ÍâÁ¬½ÓºÍ £¨+£©ºÅµÄÓ÷¨

¶ÔÓÚÍâÁ¬½Ó£¬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 ......

oracle dbtimezoneÐÞ¸Ä

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 ......

Oracle RAC 10.2.0.1 Éý¼¶ 10.2.0.4 ¼òµ¥ÃèÊö

ÍÆ¼ö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.
Éæ¼°µ½Êý¾Ý¿â¶ø²»ÊÇʵÀýµ ......

Oracle Linux Æð動¤ÈÍ£Ö¹¤Î×Ô動»¯

¤½¤ÎËû¤Î¥ª¥Ú¥ìー¥Æ¥£¥ó¥°?¥·¥¹¥Æ¥à¤Ë¤ª¤±¤ë¥Çー¥¿¥Ùー¥¹¤ÎÆð動¤ÈÍ£Ö¹¤Î×Ô動»¯
dbstart¤ª¤è¤Ódbshut¥¹¥¯¥ê¥×¥È¤òʹÓ䷤ƥÇー¥¿¥Ùー¥¹¤ÎÆð動¤ÈÍ£Ö¹¤ò×Ô動»¯¤¹¤ë¤Ë¤Ï¡¢´Î¤ÎÊÖ順¤ò実ÐФ·¤Þ¤¹¡£
root¥æー¥¶ー¤Ç¥í¥°¥¤¥ó¤·¤Þ¤¹¡£
¥×¥é¥Ã¥È¥Õ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ