Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 C££ SQL Óï¾ä

ÔÚVSÖÐдSQLÓï¾äµÄʱºò£¬Ç§ÍòÍòǧҪСÐÄÔÙСÐÄ£¬±ÈÈç ˵ Êý¾ÝÀàÐÍµÄÆ¥Å䣬 µ¥ÒýºÅ£¨Õâ¸öÄܰÑÈËÃÔËÀ£©
 where ×Ó¾äÖпÉǧÍò²»ÄÜÓпոñ£¨µ±²éѯÌõ¼þΪ×Ö·û´®µÄʱºòÄܰÑÄãŪ·è£¬ÎÒŪÕâ¸öµÄʱºò¶¼·èÁ˼¸´ÎÁË£¬Ê²Ã´¶¼¶Ô¾ÍÊDz鲻³öÀ´£¬µ÷ÊÔÁËN±é²Å·¢ÏÖ¡££©²»ÐÐÁË£¬³Ô·¹È¥£¬ÔÙ²»³Ô¿´¼û»îÈ˶¼ÏëÒ§ÁË¡£ ......

oracle ʱ¼äÀàÐÍ C#

ÔÚsqlÓï¾äÖÐÉæ¼°µ½Ê±¼äÀàÐÍʱ ÈôÖ»ÏëÒªÈÕÆÚ  to_date('2007-7-8','yyyy-mm-dd')
  ÔÚC#ÖÐÓÐdatetimeÀàÐÍ£¬´úÂë˵Ã÷Ò»ÇÐ
  DateTime dt = System.DateTime.Now;
string lsh;
lsh=string.Format("{0:yyyyMMddHHmmss}", dt);
DateTime dt = DateTime.Now;
Label1.Text = dt.To ......

Oracle ÈÕÖ¾Îļþ´íÎóµÄ´¦Àí¡£

ת×Ô£ºhttp://hi.baidu.com/dashuaiwang/blog/item/47cc680ec35055c37acbe1f8.html
´ò¿ªoracle Êý¾Ý¿âʱ³öÏÖÁË´íÎó:
ORA-00313: ÎÞ·¨´ò¿ªÈÕÖ¾×é 1 (Ïß³Ì 1) µÄ³ÉÔ±
ORA-00312: Áª»úÈÕÖ¾ 1 Ïß³Ì 1: 'D:\ORACLE\ORADATA\GOCOM\REDO01.LOG'
SQL> connect / as sysdba;
ÒÑÁ¬½Ó¡£
SQL> shutdown immediate;
ORA- ......

oracle ÈÕÆÚÏÔʾӢÎĸñʽ

     ÎÒÃdzõѧÕß°²×°oracleµÄʱºò£¬×Ö·û¼¯Ñ¡ÔñµÄÒ»°ãÊǼòÌåÖÐÎĵĸñʽ£¬Õâ·½±ãÎÒÃÇÓ¢ÎIJ»ºÃµÄ²ËÄñ£¬³ö´íµÄʱºò¶¨Î»´íÎ󣬵«ÊÇÓÐÒ»¸öÎÊÌâ°éËæ³öÏÖ£¬ÎÒÃÇд¹ØÓÚÈÕÆÚµÄsqlµÄÓï¾ä£¬ÎÒÃÇÏëÒªÓ¢ÎĵĸñʽÔõô°ì£¿ÏÂÃæÓÐÁ½¸ö°ì·¨£º
1. Á¬½Óµ½Êý¾Ý¿âºó£¬ÎÒÃÇʹÓÃÈçÏÂÓï¾ä
  ALTER SESSION SET NLS_D ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ