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 ......
½â¾ö·½°¸£º
select session_id from v$locked_object; --Ê×Ïȵõ½±»Ëø¶ÔÏóµÄsession_id
SELECT sid, serial#, username, osuser from v$session where sid = session_id; --ͨ¹ýÉÏÃæµÃµ½µÄsession_idȥȡµÃv$sessionµÄsidºÍserial#£¬È»ºó¶Ô¸Ã½ø³Ì½øÐÐÖÕÖ¹¡£
&n ......
'
ALTER TABLESPACE app_data
ADD DATAFILE 'u01/oradata/userdata03.dbf'
SIZE 200M;
'´´½¨±í¿Õ¼ä
CREATE TABLESPACE userdata
DATAFILE 'u01/oradata/userdata03.dbf' SIZE 100M
AUTOEXTEND ON NEXT 5M MAXSIZE 200M;
'´´½¨»Ø¹ö±í¿Õ¼ä
CREATE UNDO TABLESPACE undo1
DATAFILE ' ......
//ʹÓÃ×Ô¶¨Ò庯Êý¶¨ÒåÈÕÆÚ¸ñʽ
to_date('1982-11-11','yyyy-mm-dd')
to_date('1982/11/11','yyyy/mm/dd')
//Ï£ÍûÔ±¹¤scottµÄ¸Ú룬¹¤×Ê£¬²¹ÖúÓësmithÔ±¹¤Ò»Ñù
update emp set (job,sal,comm)=(select job,sal,comm from emp where ename='SMITH') where ename='SCOTT';
||------- javaʹÓÃoracle &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.
Éæ¼°µ½Êý¾Ý¿â¶ø²»ÊÇʵÀýµ ......