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

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

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


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

ÔÚLinuxϵͳÉÏʵÏÖÓÃPythonÔ¶³Ì·ÃÎÊOracleÊý¾Ý¿â

1¡¢ÏÂÔØoracleÈí¼þ
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html
oracle-instantclient-basic-10.2.0.4-1.i386.rpm
oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm
oracle-instantclient-devel-10.2.0.4-1.i386.rpm
2¡¢°²×°rpm°ü
rpm -ivh oracle-instantclient-basic-10.2.0.4 ......

Oracle ERPϵ統½è´û¹ØÏµ±í

ϵͳ·Ö²½Öè²úÉúµÄ·Ö¼£º
1£©¿â´æÄ£¿é×÷½ÓÊÕʱ²úÉúµÄ·Ö¼Ϊ£º
½è£º²ÄÁϲɹº £¨²É¹ºµ¥¼ÛX¶©µ¥ÊýÁ¿£©
´û£ºÓ¦¼Æ¸ºÕ®
£¨²É¹ºµ¥¼ÛX¶©µ¥ÊýÁ¿£©
2£©¿â´æÄ£¿é×÷¼ìÑéÈë¿âʱ²úÉúµÄ·Ö¼Ϊ£º
ϵͳ²úÉúµÄ·Ö¼·Ö±ðΪ£º
1£©¿â´æÄ£¿é×÷½ÓÊÕʱ²úÉúµÄ·Ö¼Ϊ£º
½è£º²ÄÁϲɹº
£¨²É¹ºµ¥¼ÛX¶©µ¥ÊýÁ¿£©
´û£ºÓ¦¼Æ¸ºÕ®
£¨²É¹ºµ¥¼ÛX¶©µ¥Ê ......

ORACLE·ÖÎöº¯ÊýµÄÓ÷¨

¿ª´°º¯ÊýµÄµÄÀí½â£º
¿ª´°º¯ÊýÖ¸¶¨ÁË·ÖÎöº¯Êý¹¤×÷µÄÊý¾Ý´°¿Ú´óС£¬Õâ¸öÊý¾Ý´°¿Ú´óС¿ÉÄÜ»áËæ×ÅÐеı仯¶ø±ä»¯£¬¾ÙÀýÈçÏ£º
over£¨order   by   salary£© °´ÕÕsalaryÅÅÐò½øÐÐÀۼƣ¬order   byÊǸöĬÈϵĿª´°º¯Êý
over£¨partition   by   deptno£©°´ÕÕ²¿ÃÅ·ÖÇø
ove ......

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

ÎÒÃÇÔÚ´´½¨±í½á¹¹µÄ¹ý³ÌÖУ¬¿ÉÄÜ»áÓÉÓÚʧÎó£¬Ôì³É±íÖÐÁÐÃû´íÎó£¬ÈçºÎ¸ü¸ÄÄØ£¬Äã¿ÉÄÜ»á»Ø´ð£¬Ê¹ÓÃOEM»òÕßPL/SQL£¬³ýÁËÕâÁ½ÖÖ·½·¨£¬ÎÒÃÇ¿ÉÒÔʹÓÃÃüÁ
   ALTER TABLE ±íÃû rename   column  ÁÐÃû to ÐÂÁÐÃû     ×¢ÒâcolumnÊǹؼü×Ö   /*ÖØÃüÃûÁÐÃû*/
  ALTE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ