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

½«Êý¾Ýµ¼Èëµ½oracleÊý¾Ý¿â

1.Ê×ÏȽ«Òªµ¼ÈëµÄÊý¾ÝÉú³ÉexcelÎļþ¸ñʽ£¬×îÇ°Ãæ¿ÕÒ»¸ñ¡£
2.ÓÃPL/SQLÁ¬½ÓÒªµ¼ÈëµÄÊý¾Ý¿â£¬ÊäÈëÓï¾ä select * from ±íÃû for update
3.µã»÷СËø£¨±à¼­Êý¾Ý£©£¬Ñ¡ÖÐÒ»Ðн«excel¸´ÖÆÊý¾ÝÕ³Ìùµ½±íÖÐ
ÒÔinformixÊý¾Ýµ¼³öΪÀý£¬Ê×ÏÈʹÓÃSecureCRT¹¤¾ß½øÈëÖնˡ£ÊäÈëÃüÁîdbaccessºóÖ´ÐУ¬Ñ¡ÖÐÊý¾Ý¿âNEWÒ»ÏÂSQLÓï¾äÊäÈëÃüÁunload to ±íÃû.unl select * from ±íÃû ºóÑ¡ÔñRUNÖ´ÐУ¬½«Éú³ÉÒ»¸öunlÎļþ£¬½«unlÎļþת»»³Éexcel£¬Ê×ÏȽ«|»»³É^tÔÚÉú³Éexcel¡£
µ¼³ö±í½á¹¹£ºÖ±½Ó½øÈëÖÕ¶ËÊäÈëdbschema -d Êý¾Ý¿âÃû -t ±íÃû a_topic_class.sql


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

Oracle ERP²ÆÎñϵͳ——¹Ì¶¨×ʲú

1 ×ʲúÀàÐÍ
×ʲúÀàÐÍ£º×ʱ¾»¯¡¢CIP¡¢·ÑÓÃÐÔ
×ʱ¾»¯£ºÊÇÖ¸ÐèÒª¼ÆËãÕ۾ɵÄ×ʲú
CIP£ºÊÇÔÚ½¨¹¤³Ì×ʲú£¬Éв»ÐèÕ۾ɣ¬´ýÆä×ʱ¾»¯Ö®ºóÔÙ¿ªÊ¼ÕÛ¾É
·ÑÓÃÐÔ£ºÊDz»¼ÆËãÕ۾ɣ¬¸Ã×ʲúµÄ³É±¾¶¼×÷Ϊ·ÑÓô¦Àí
 
2 ×ʲúÔö¼Ó
×ʲúÔö¼ÓÓÐÁ½ÖÖ·½Ê½£ºÊÖ¶¯Ôö¼Ó£¬×Ô¶¯Ôö¼Ó¡£
×Ô¶¯Ôö¼ÓÊÇÖ¸ÓÉÆäËûÄ£¿é£¨APÄ£¿é»òPAÄ£¿é£©´«µÝµ½×ʲúÄ£¿é ......

LinuxÏÂOracle9i RMAN±¸·Ý¼°»Ö¸´²½Öè½éÉÜ

1¡¢×ª»»·þÎñÆ÷¹éµµÄ£Ê½£¬Èç¹ûÒÑÊǹ鵵ģʽ¿ÉÌø¹ý´Ë²½£º
  ¡¡%sqlplus /nolog (Æô¶¯sqlplus)
¡¡¡¡SQL> conn / as sysdba (ÒÔDBAÉí·ÝÁ¬½ÓÊý¾Ý¿â)
¡¡¡¡SQL> shutdown immediate; (¼´Ê±¹Ø±ÕÊý¾Ý¿â)
¡¡¡¡SQL> startup mount (Æô¶¯ÊµÀý²¢¼ÓÔØÊý¾Ý¿â£¬µ«²»´ò¿ª)
¡¡¡¡SQL> alter database archivelog; (¸ü¸ÄÊ ......

oracle sqlÓïÑÔÄ£ºý²éѯ ͨÅä·ûlikeµÄʹÓý̳Ì

ÔÚWhere×Ó¾äÖУ¬¿ÉÒÔ¶Ôdatetime¡¢char¡¢varchar×Ö¶ÎÀàÐ͵ÄÁÐÓÃLike×Ó¾äÅäºÏͨÅä·ûÑ¡È¡ÄÇЩ“ºÜÏñ...”µÄÊý¾Ý¼Ç¼£¬ÒÔÏÂÊÇ¿ÉʹÓõÄͨÅä·û£º
%   Áã»òÕ߶à¸ö×Ö·û
_    µ¥Ò»ÈκÎ×Ö·û£¨Ï»®Ïߣ©
\     ÌØÊâ×Ö·û
[]     ÔÚijһ·¶Î§ÄÚµÄ×Ö·û£¬Èç ......

oracle sql ÇóÖÖ²Ëʱ¼ä

-- create by zh
-- n ÊÇ×÷ÎïµÄʱ¼ä,x ÊÇÏ£ÍûÔÚ¼¸µã³ÉÊì,·µ»Ø²¥ÖÖµÄʱ¼ä
with t as
(
select 64 n,9 x from dual union all
select 64 n,13 x from dual union all
select 64 n,17 x from dual union all
select 64 n,20 x from dual
)
select '³ÉÊìʱ¼ä:'     || lpad(to_char(n),4,' ' ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ