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

³õѧoracle¡£Ó¦¸ÃѡʲôÊ飿 - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λÀÏ´óÃÇÍÆ¼ö±¾Êé°É¡«
×îºÃ²»ÒªÔÛ¹ú¼ÒÈËдµÄ£®ÎÒÒ»Ö±¸Ð¾õÔÛÃǹúµÄר¼ÒÃÇдÊéÍùÄÑÁËдËùÓÐÈ˶Á²»¶®ËûÃDzŸßÐË£®£®


Óб¾ÊéºÃÏñÊÇ¡®¾«Í¨9i/10g ±à³Ì¡¯Í¦»ù´¡µÄ¡£

ÏëÁ˽âÌåϵ½á¹¹¿ÉÒÔÑ¡¡¶Oracle9i&10g±à³ÌÒÕÊõ£­£­ÉîÈëÊý¾Ý¿âÌåϵ½á¹¹¡· ÈËÃñÓʵç³ö°æÉç
ÈôÊÇÏëѧSQL»òÊÇPL/SQLÄÇ¿ÉÑ¡µÄÊéÓкܶ࣬LZ×Ô¼º¶àÕÒÕÒ°É¡£

Oracle one by one 
¿°³Æ¾­µä

ÄãÊÇѧÉú¾ÍȥͼÊé¹Ý°É

¸øÄãÒ»¸öÍâÎÄÊé¼®Çåµ¥£º
2005-08-10 00:15 1,507,311 43061-ora92errmsg.chm
2009-02-13 22:18 <DIR> 9i
2005-06-03 00:42 1,305,519 Advanced Oracle PL_SQL - Programming With Packages - O'Reilly.chm
2009-02-13 22:18 <DIR> Apress expert one-on-one oracle sourcecode
2005-04-24 13:49 421,499 Apress expert one-on-one oracle sourcecode.zip
2005-12-27 16:52 4,985,126 Apress.Expert.Oracle.Database.Architecture.9i.and.10g.Programming.Techniques.and.Solutions.Sep.2005.pdf
2008-09-02 08:50 9,318,509 Apress.Troubleshooting.Oracle.Performance.pdf
2005-01-26 18:29 8,652,845 Apress_Expert one on one Oracle.pdf
2005-08-08 01:40 32,484,619 Apress_Expert one-on-one Oracle_cn.pdf
2009-02-13 22:18 <DIR> Effective Oracle by Design
2006-07-23 11:55 78,019 Effective Oracle by Design.zip
2005-06-03 12:55 10,246,532 Expert Oracle 9I Database Administration - Apress(2003).chm
2006-07-24 16:20


Ïà¹ØÎÊ´ð£º

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......

oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí

×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐР
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
 SEQUENCE# APP
---------- ---
  13 NO
  13 YES ......

oracle³õѧÕßÄãÇë½Ì - Oracle / »ù´¡ºÍ¹ÜÀí

--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test 
as 
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......

OracleÐÐתÁÐ - Oracle / ¸ß¼¶¼¼Êõ

select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ
1,2,3,4
ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û
1
2
3
4
ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö???
ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó

SQL code:
wi ......

¹ØÓÚSQLÓï¾äORµÄÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ