ORACLEÎóɾÊý¾ÝÎļþµ¼ÖÂORA
×Ô´ÓѧORACLEÒÔÀ´¾Í´ÓÀ´Ã»Óз¢Éú¹ýʲô¹ÊÕÏ£¬±È½ÏÐÒÔË¡£ÆäʵҲ²»ÄÜËãÐÒÔË£¬ÒòΪÕâÑù¾ÍÉÙÁ˶ÍÁ¶µÄ»ú»áÁË£¬ºÇºÇ£¬Ôõô¾õµÃ×Ô¼ºÓеãÇóÅ°µÄÇãÏò……
¼´±ãÊÇÔÚѧϰbackup and recovery basicsµÄʱºò£¬Ò²Ö»ÊÇ×ö×ö±¸·ÝµÄʵÑ飬û×ö¹ý»Ö¸´£¬ÒòΪÉí±ßûÓÐÈËÖ¸µ¼£¬Ò²Ã»ÆäËûͬѧÔÚѧORACLE£¬ËùÒÔÅÂÒ»³öÎÊÌâ¿Ï¶¨ºÜÂé·³£¬½â¾ö²»Á˾͵ÃÖØ×°£¬Ð¶ÔØÓÐʱºò»¹Ð¶²»¸É¾»£¬×ÜÖ®¾ÍÊÇÂé·³……
ºÃÁË£¬²»¶à˵ÁË£¬½ñÌìÔçÉÏÒ»¿ª»ú¾Í·¢ÏÖ¸ö´íÎó£¬ÏÂÃæ¼òµ¥ÃèÊöһϣ¬¾Íµ±×öÊǵÚÒ»´Î½â¾ö¹ÊÕÏ°É¡£
Microsoft Windows XP [°æ±¾ 5.1.2600]
(C) °æȨËùÓÐ 1985-2001 Microsoft Corp.
C:\Documents and Settings\Admin>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 13 09:18:43 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn scott/tiger
ERROR:
ORA-01033: ORACLE æ£å湪鍒濆鍖栨垨鍏³é棴
ÉÏÍø²éÁËÏÂ
ora-01033: oracle initialization or shutdown in progress
¹Ù·½Õë¶ÔORA-01033µÄ½âÊÍ»ù±¾ÉÏÊÇÈÃÓû§µÈ´ýÒ»¶Îʱ¼äºóÔٴεǽ£¬»ùÓÚÕâÖÖÅжÏÔÚÓÚORA-01033µÄ±¾ÖÊÊÇÓÉÓÚδÍêÈ«¼ÓÔضøµ¼ÖµĽø³ÌæµËùÔì³ÉµÄ£¬ÕâÖÖÇé¿öµÄºÏÀí½âÊÍȷʵ¿ÉÒÔÊÇÈÃÓû§µÈ´ýµ½¼ÓÔØÍê±Ï¡£µ«ÊǶÔÓÚ´ËÖÖÎļþË𻵵IJ»¿ÉÄæµÄ²Ù×÷£¬Ò²¾Í´ú±í×ÅÓÀÔ¶²»¿ÉÄܵȵ½¼ÓÔØÍê±ÏµÄÄÇÒ»¿Ì£¬Òò´Ë£¬Óõȴý²¢²»Ò»¶¨Äܽâ¾ö¡£
¼ÈÈ»Ìáʾ˵Êdzõʼ»¯»ò¹Ø±Õ»¹ÔÚ½øÐÐÖУ¬ÎҾ͹رÕÊý¾Ý¿â£¬ÔÙÒ»²½²½´ò¿ª¿´±¨Ê²Ã´´í¡£
SQL> conn / as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> select * from dual;
ADDR INDX INST_ID D
-------- ---------- ---------- -
0366CD54 0 1 X --ÕâÀï¿ÉÒÔ¿´³öDUAL±íÖÐÄÚÈݲ»Õý³£ÁË
SQL> shutdown normal;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 176160768 bytes
Fixed Size &nbs
Ïà¹ØÎĵµ£º
ORDER BY ÅÅÐò
ASC ÉýÐò(ĬÈÏ)
DESC ½µÐò
select * from s_emp order by dept_id , salary desc
²¿ÃźÅÉýÐò£¬¹¤×ʽµÐò
¹Ø¼ü×ÖdistinctÒ²»á´¥·¢ÅÅÐò²Ù×÷¡£
select * from employee order by 1; //°´µÚÒ»×Ö¶ÎÅÅÐò
NULL±»ÈÏΪÎÞÇî´ó¡£order by ¿ÉÒÔ¸ú±ðÃû¡£
select table_name ......
connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from tablename start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = 'HBHqfWGWPy'
connect by prior org_id = parent_id;
¼òµ¥ËµÀ´Êǽ«Ò»¸öÊ÷×´½á¹¹´æ´¢ÔÚÒ»ÕűíÀ±ÈÈçÒ»¸ö±í ......
ÔÚOracleÊý¾Ý¿âÖÐ''ÓëNULLÊǵȼ۵ġ£¾ù±íʾ¿ÕÖµ£¬¶ø²»ÊÇÀàËÆÆäËûÊý¾Ý¿âÉÏ''±íʾ¿Õ´®£¬NULL±íʾ¿ÕÖµ¡£
ORACLEÔÊÐíÈκÎÒ»ÖÖÊý¾ÝÀàÐ͵Ä×Ö¶ÎΪ¿Õ£¬³ýÁËÒÔÏÂÁ½ÖÖÇé¿ö£º
1¡¢Ö÷¼ü×ֶΣ¨primary key£©£¬
2¡¢¶¨ÒåʱÒѾ¼ÓÁËNOT NULLÏÞÖÆÌõ¼þµÄ×Ö¶Î
˵Ã÷£º
1¡¢NULLµÈ¼ÛÓÚûÓÐÈκÎÖµ¡¢ÊÇδ֪Êý¡£
2¡¢NULLÓë ......
ÔÚijЩ³¡ºÏÏ£¬´æ´¢¹ý³Ì»ò´¥·¢Æ÷ÀïµÄSQLÓï¾äÐèÒª¶¯Ì¬Éú³É¡£OracleµÄDBMS_SQL°ü¿ÉÒÔÓÃÀ´Ö´Ðж¯Ì¬SQLÓï¾ä¡£±¾ÎÄͨ¹ýÒ»¸ö¼òµ¥µÄÀý×ÓÀ´Õ¹Ê¾ÈçºÎÀûÓÃDBMS_SQL°üÖ´Ðж¯Ì¬SQLÓï¾ä£º
DECLARE
v_cursor NUMBER;
v_stat NUMBER;
& ......
Ò»£ºsql loader µÄÌصã
oracle×Ô¼º´øÁ˺ܶàµÄ¹¤¾ß¿ÉÒÔÓÃÀ´½øÐÐÊý¾ÝµÄǨÒÆ¡¢±¸·ÝºÍ»Ö¸´µÈ¹¤×÷¡£µ«ÊÇÿ¸ö¹¤¾ß¶¼ÓÐ×Ô¼ºµÄÌص㡣
±ÈÈç˵expºÍimp¿ÉÒÔ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐе¼³öºÍµ¼³öµÄ¹¤×÷£¬ÊÇÒ»ÖֺܺõÄÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄ¹¤¾ß£¬Òò´ËÖ÷ÒªÓÃÔÚÊý¾Ý¿âµÄÈȱ¸·ÝºÍ»Ö¸´·½Ãæ¡£ÓÐ×ÅËٶȿ죬ʹÓüòµ¥£¬¿ì½ÝµÄÓŵ㣻ͬʱҲÓÐһР......