³õѧ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
Ïà¹ØÎÊ´ð£º
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔصĽڵ㣺/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ
1,2,3,4
ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û
1
2
3
4
ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö???
ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó
SQL code:
wi ......