Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ´æ´¢¹ý³Ì

1.´´½¨¹ý³Ì
¡¡¡¡¡¡ÓëÆäËüµÄÊý¾Ý¿âϵͳһÑù£¬OracleµÄ´æ´¢¹ý³ÌÊÇÓÃPL/SQLÓïÑÔ±àдµÄÄÜÍê³ÉÒ»¶¨´¦Àí¹¦ÄܵĴ洢ÔÚÊý¾Ý¿â×ÖµäÖеijÌÐò¡£
¡¡¡¡Óï·¨:
¡¡¡¡create [or replace] procedure procedure_name
¡¡¡¡[ (argment [ { in| in out }] type,
¡¡¡¡argment [ { in | out | in out } ] type
¡¡¡¡{ is | as }
¡¡¡¡<ÀàÐÍ ......

ÍæתOracle£¨4£©

//ʹÓÃ×Ô¶¨Ò庯Êý¶¨ÒåÈÕÆÚ¸ñʽ
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 ......

Oracleѧϰ±Ê¼Ç£ºlinuxÏÂÆôÍ£Oracle


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

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

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