Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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),Ò²²»»á±»×èÈû)


Ïà¹ØÎĵµ£º

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

Aix5.3ÏÂOracle 10gÉèÖù鵵ģʽµ½Îļþϵͳ


н¨Îļþϵͳ
        crfs  -v jfs  -g  rootvg  -m /arch -a \ size=32768 -a frag=512 -a nbpi=8192  Ò²¿ÉÒÔ smit¡£
¿ªÆô¹éµµÄ£Ê½
     $ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 10 13:38 ......

OracleÖг£Óõĺ¯Êý

  ---sqlµÄº¯ÊýµÄʹÓÃ(Oracle)      
      ---dualµÄʹÓãºÑÆÔª±í£ºÃ»ÓбíÐèÒª²éѯµÄʱºò ¿ÉÒÔÓÃËü
               ---select 'Hello World' from dual;     ---½á¹û£ºH ......

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

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