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),Ò²²»»á±»×èÈû)
Ïà¹ØÎĵµ£º
¡¡ÈçÏ£¬±íaÊÇÊý¾Ý¿âÖÐÒѾ´æÔÚµÄ±í£¬bÊÇ×¼±¸¸ù¾Ý±ía½øÐи´ÖÆ´´½¨µÄ±í£º
¡¡¡¡1¡¢Ö»¸´ÖƱí½á¹¹µÄsql
¡¡¡¡create table b as select * from a where 1<>1
¡¡¡¡2¡¢¼´¸´ÖƱí½á¹¹ÓÖ¸´ÖƱíÖÐÊý¾ÝµÄsql
¡¡¡¡create table b as select * from a
¡¡¡¡3¡¢¸´ÖƱíµÄÖÆ¶¨×ֶεÄsql
¡¡¡¡create table b as select row_id ......
ÓÉÓÚ¹«Ë¾ÒµÎñÔö³¤½Ï¿ì£¬Êý¾Ý¿âoracleѹÁ¦Ô½À´Ô½´ó£¬¹«Ë¾¿¼ÂÇÔÚÓ¦Ó÷þÎñÆ÷ Websphere ºÍ Êý¾Ý¿âoracleÖ®¼äÔö¼Ó timestenÊý¾Ý¿âÀ´ÊµÏÖÊý¾ÝµÄ¶Áд·ÖÀ룬ÁíÍâÓÉÓÚtimestenÊÇÄÚ´æÊý¾Ý¿â£¬ËùÒÔ²éѯËÙ¶ÈÉÏÒªÓÅÓÚ oracle Êý¾Ý¿â£¬Á½¸öÊý¾Ý¿âËäÈ»¶¼ÊÇoracle¹«Ë¾µÄ²úÆ·£¬µ«ÊÇÔںܶàsqlµÄд·¨ÉÏÊDz»ÏàͬµÄ£¬Ï ......
Oracle£ºÒ»¸öÊý¾Ý¿âÓжà¸öÓû§,Ò»¸öÓû§ÓµÓÐÒ»×éÊý¾Ý¿â¶ÔÏó,Õâ¸öÓû§ÎÒÃÇË׳ÆÎª·½°¸,
ͨ³£Ò»¸öÒµÎñϵͳ¶ÔÓ¦Ò»¸öÊý¾Ý¿âÓû§¡£
¡ïOracle°²×°³É¹¦ºó»á×Ô¶¯´´½¨Ê®À´¸öϵͳ½ç±ðµÄÕË»§¡£Ä¬ÈÏÇé¿öÏÂÕâЩÕË»§ÖÐÖ»ÓÐËĸö¿ÉÓã¬ÆäËüµÄÕʺŶ¼±»ÉèÖóÉÁËËø¶¨»òÊÇÉèÖÃΪ¹ý ÆÚ״̬£¬ÕâËĸöÕÊ»§¾Í ......
SELECT sde.st_area(zone) from sde.test1 ORDER BY name;//
SELECT shape from schools ORDER BY name;
SELECT objectid, sde.st_astext(SDE.ST_POINTfromSHAPE(shape,0)) AS points from schools;
SELECT name, sde.st_x (zone) "The X coordinate" from test ; //ÕýÈ·Ö´ÐÐ
SELECT name, sde.st_x (shape) "The ......
Upgrade Oracle 9i RAC to Oracle 10g RAC
by Vincent Chan
This article provides the procedures for converting Oracle 9i (9.2.0.4) RAC to Oracle 10g (10.2.0.1) RAC on Red Hat Enterprise Linux 3 (RHEL3).
Oracle Database 10g and Oracle Real Application Cluster (RAC) 10g itself, boast many new and ex ......