Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÌáÈ¡Oracleµ±Ç°Óû§Ãû£¬»úÆ÷Ãû£¬IPµÄ·½·¨

select sysdate  µ±Ç°Ê±¼ä,
       sys.login_user  Êý¾Ý¿âÓû§,
       machine   µÇ¼»úÆ÷Ãû,
       SYS_CONTEXT('USERENV', 'IP_ADDRESS')   µÇ¼IP,
       program   Ó¦ÓóÌÐò
  from v$session
 where AUDSID = USERENV('SESSIONID');


Ïà¹ØÎĵµ£º

[Oracle 10g] ÉÁ»Ø»Ö¸´Çø (Flash Recovery Area)

ºÎΪÉÁ»Ø»Ö¸´Çø
Oracle 10g ÓÐÒ»Ïîй¦ÄܳÆÎª:×Ô¶¯µÄ»ùÓÚ´ÅÅ̵ı¸·ÝÓë»Ö¸´( Automatic Disk-Based Backup and Recovery )¡£ÊµÏָù¦ÄܵĻù´¡Îª±¾ÎÄÒª½²ÊöµÄÉÁ»Ø»Ö¸´Çø( Flash Recovery Area )¡£ÉÁ»Ø»Ö¸´ÇøÊÇ Oracle 10g ÖеÄÐÂÊÂÎï¡£¼òµ¥µÄ˵£¬ÉÁ»Ø»Ö¸´ÇøÊÇÒ»¿éÓÃÒÔ´æ´¢»Ö¸´Ïà¹ØµÄÎļþµÄ´æ´¢¿Õ¼ä¡£ÔÊÐíÓû§¼¯Öд洢ËùÓлָ ......

ORACLEµÄlpadº¯Êý¡¢rpadº¯ÊýÓ÷¨

ORACLEµÄlpadº¯Êý¡¢rpadº¯ÊýÓ÷¨
Óï·¨£ºselect lpad('12345678',1,'0') from dual;
·µ»Ø×Ö·û´®‘12345678’µÄ´Ó×ó±ß³¤¶ÈΪ1µÄ×Ö·û´®£¬Èç¹û²»¹»£¬×ó±ß²¹‘0’
Óï·¨£ºselect rpad('12345678',1,'0') from dual; 
·µ»Ø×Ö·û´®‘12345678’µÄ´Ó×ó±ß³¤¶ÈΪ1µÄ×Ö·û´®£¬Èç¹û²»¹»£¬Óұ߲¹&ls ......

oracleÖÐÖØÃüÃûÁÐÃûºÍ±íÃû

ÎÒÃÇÔÚ´´½¨±í½á¹¹µÄ¹ý³ÌÖУ¬¿ÉÄÜ»áÓÉÓÚʧÎó£¬Ôì³É±íÖÐÁÐÃû´íÎó£¬ÈçºÎ¸ü¸ÄÄØ£¬Äã¿ÉÄÜ»á»Ø´ð£¬Ê¹ÓÃOEM»òÕßPL/SQL£¬³ýÁËÕâÁ½ÖÖ·½·¨£¬ÎÒÃÇ¿ÉÒÔʹÓÃÃüÁ
   ALTER TABLE ±íÃû rename   column  ÁÐÃû to ÐÂÁÐÃû     ×¢ÒâcolumnÊǹؼü×Ö   /*ÖØÃüÃûÁÐÃû*/
  ALTE ......

Oracle¸üжàÐÐ

¸üжàÐеIJ½Ö裺
²½Öè¶à£¬µ«Ð§ÂʱȽϸߣº
1¡¢create table ÁÙʱ±í value (select a.id,a.name,b.name,... from table1 a,table2 b where a.id=b.id)
2¡¢É¾³ýtable1ÖеļǼ£¬²»Òªdrop
3¡¢insert into table1 select ÄãÐèÒªµÄ×Ö¶Î from ÁÙʱ±í¡£
select * from tb_ai03
create table tb_ai031 as select * from tb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ