³õѧ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
Ïà¹ØÎÊ´ð£º
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
13 NO
13 YES ......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test
as
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......
select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ
1,2,3,4
ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û
1
2
3
4
ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö???
ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó
SQL code:
wi ......
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......