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
ÔËÐÐÕâ¶Î½Å±¾£¬½«Éú³ÉÈçϽá¹û£º
¸´ÖÆ´úÂë
......
1.´´½¨¹ý³Ì
¡¡¡¡¡¡ÓëÆäËüµÄÊý¾Ý¿âϵͳһÑù£¬OracleµÄ´æ´¢¹ý³ÌÊÇÓÃPL/SQLÓïÑÔ±àдµÄÄÜÍê³ÉÒ»¶¨´¦Àí¹¦ÄܵĴ洢ÔÚÊý¾Ý¿â×ÖµäÖеijÌÐò¡£
¡¡¡¡Óï·¨:
¡¡¡¡create [or replace] procedure procedure_name
¡¡¡¡[ (argment [ { in| in out }] type,
¡¡¡¡argment [ { in | out | in out } ] type
¡¡¡¡{ is | as }
¡¡¡¡<ÀàÐÍ ......
//ʹÓÃ×Ô¶¨Ò庯Êý¶¨ÒåÈÕÆÚ¸ñʽ
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 ......
1. linuxÏÂÆô¶¯oracle
su - oracle
sqlplus /nolog
conn /as sysdba
startup
exit
lsnrctl start
exit
2. linuxϹرÕoracle
su - oracle
sqlplus /nolog
conn /as sysdba
shutdown immediate
exit
lsnrctl stop
exit
3¡¢Æô¶¯¼àÌýÆ÷
oracle@suse92:~> lsnrctl start
4¡¢Í£Ö¹¼àÌýÆ÷
oracle@suse92:~ ......
¤½¤ÎËû¤Î¥ª¥Ú¥ìー¥Æ¥£¥ó¥°?¥·¥¹¥Æ¥à¤Ë¤ª¤±¤ë¥Çー¥¿¥Ùー¥¹¤ÎÆð動¤ÈÍ£Ö¹¤Î×Ô動»¯
dbstart¤ª¤è¤Ódbshut¥¹¥¯¥ê¥×¥È¤òʹÓ䷤ƥÇー¥¿¥Ùー¥¹¤ÎÆð動¤ÈÍ£Ö¹¤ò×Ô動»¯¤¹¤ë¤Ë¤Ï¡¢´Î¤ÎÊÖ順¤ò実ÐФ·¤Þ¤¹¡£
root¥æー¥¶ー¤Ç¥í¥°¥¤¥ó¤·¤Þ¤¹¡£
¥×¥é¥Ã¥È¥Õ ......