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

oracle×Ô¶¯±¸·Ý½Å±¾ÉèÖÃÎÊÌâ

#set Oracle User
ORA_OWNER=oracle Õâ¾äÊÇÉèÖÃoracleÓû§ÃûÂð£¿
#set Node Name
Node_Name=¡¯hostname¡¯Õâ¾äÊÇÉèÖÃÖ÷»úÃûÂð£¿
#set the Backup FileName¡¯s date
RQ=¡¯date+%F-%H-%M¡¯  ÕâÊÇÔõô¶¨ÒåµÄʱ¼ä£¿RQÊǵ÷¶Èʱ¼äÉèÖÃÂð£¿

-----------------------------------------
OraUser=¡±oracle¡±
OraUserHome=¡±/home/oracle¡±
User=¡±sys as sysdba¡±                  ÕâЩÊÇʲôÒâ˼£¿
Pass=¡±123213¡±
Buffer=¡±10240¡±
----------------------------------------





UP

ÒýÓÃ
-----------------------------------------
OraUser=¡±oracle¡±
OraUserHome=¡±/home/oracle¡±
User=¡±sys as sysdba¡±                  ÕâЩÊÇʲôÒâ˼£¿
--×÷Ϊ³¬¼¶¹ÜÀíÔ±Óû§À´½øÐвÙ×÷

Pass=¡±123213¡±
Buffer=¡±10240¡±
----------------------------------------



OraUser=¡±oracle¡±ÕâÊÇSIDµÄÉèÖÃÂð£¿
OraUserHome=¡±/home/oracle¡±Õâ²»ÊÇ$ORACLE_HOMEµÄÒâ˼°É¡£ÕâÀïÉèÖõÄÊÇʲôĿ¼
User=¡±sys as sysdba¡±      ÕâÊÇÒÔsysdbaÀ´µÇ½Âð£¿ÎªÊ²Ã´²»Ö±½Óд³ÉµÇ½Ãûsys
Pass=¡±123213¡±             
Buffer=¡±10240¡±                Õâ¸öÊÇÉèÖõÄʲô£¿


OraUserHome=¡±/home/oracle¡±Õâ¸ö¾ÍÊÇOR


Ïà¹ØÎÊ´ð£º

linux + oracleÓÃXP·ÃÎʲ»ÁË

ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......

php Öвéѯoracle date ÀàÐÍÊý¾ÝµÄÎÊÌâ?

ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

½èˮԴÈËÆø£¡oracle jobÎÊÌ⣡ÔÚÏßµÈ

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......

ORACLE ×ÜºÍ SUM ÎÊÌâ

±ÈÈ磺
ÓÐÕűíΪËùÓдúÀíÉÌÿÈÕ·¢Õ¹µÄ²»Í¬Æ·ÅƵÄÊýÁ¿£¨2008Äê¼ä£©

´úÀíÉÌID  Æ·ÅÆ  ÈÕÆÚ        ÈÕ·¢Õ¹Á¿
1111      a    20080101  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ