Oracle 10g Æô¶¯Óë¹Ø±Õ
ÔÚÖ´ÐÐÆô¶¯¹Ø±ÕÃüÁî֮ǰÐèÒªÕýÈ·ÉèÖÃÏÂÁл·¾³±äÁ¿£º
ORACLE_BASE
ORACLE_HOME °²×°¹ý³ÌÖÐÏÔʾµÄoracle home Ŀ¼
ORACLE_SID
PATH=$PAHT£º$ORACLE_HOME/bin
ÒÔ oracle Õ˺ŵǽ Linux£¬»òÕß´Ó root ÏÂÊäÈë su - oracle ±ä³É oracle ÕʺÅÖ´ÐÐÆô¶¯¹Ø±ÕÃüÁî
1. Æô¶¯ºÍ¹Ø±Õ¼àÌý
Æô¶¯¼àÌý£ºlsnrctl start
¹Ø±Õ¼àÌý£ºlsnrctl stop
2. Æô¶¯ºÍÍ£Ö¹Êý¾Ý¿â
Æô¶¯Êý¾Ý¿â£ºÔÚÖÕ¶ËÊäÈë sqlplus '/ as sysdba' ½øÈë sqlplus£¬ÔÚ sqlplus ÊäÈë startup
Í£Ö¹Êý¾Ý¿â£ºÔÚ sqlplus ÊäÈë shutdown »òÕß shutdown immediate
3. Æô¶¯ºÍÍ£Ö¹ dbconsole ·þÎñ
Æô¶¯Ç°Ðè×¢ÒâOracleµÄidÊÇ·ñÕýÈ·
windowsÏÂÃüÁîΪset ORACLE_SID=TEST
AIXÏÂÃüÁîΪexport ORACLE_SID=TEST
Æô¶¯ dbconsole ·þÎñ£º emctl start dbconsole
Í£Ö¹ dbconsole ·þÎñ£º emctl stop dbconsole
4. Æô¶¯ºÍÍ£Ö¹ iSQL*Plus isqlplusctl start | stop
5. ÁгöOracle½ø³Ì
ps -fu oracle
Ïà¹ØÎĵµ£º
oracle distinct
¹Ø¼ü×Ö: distinctµÄһЩÔÓ̸
distinctÕâ¸ö¹Ø¼ü×ÖÀ´¹ýÂ˵ô¶àÓàµÄÖظ´¼Ç¼ֻ±£ÁôÒ»Ìõ£¬µ«ÍùÍùÖ»Óà ËüÀ´·µ»Ø²»Öظ´¼Ç¼µÄÌõÊý£¬¶ø²»ÊÇÓÃËüÀ´·µ»Ø²»ÖؼǼµÄËùÓÐÖµ¡£ÆäÔÒòÊÇdistinctÖ»ÓÐÓöþÖØÑ»·²éѯÀ´½â¾ö£¬¶øÕâÑù¶ÔÓÚÒ»¸öÊý¾ÝÁ¿·Ç³£´óµÄÕ¾À´Ëµ£¬ÎÞÒÉÊÇ»áÖ±½ÓÓ°Ï쵽ЧÂʵġ£
ÏÂÃæÏÈÀ´¿´¿´Àý×Ó£º
table ......
SVRMGR> select * from dba_jobs;
³õʼ»¯Ïà¹Ø²ÎÊýjob_queue_processes
alter system set job_queue_processes=39 scope=spfile;//×î´óÖµ²»Äܳ¬¹ý1000 ;job_queue_interval = 10 //µ÷¶È×÷ҵˢÐÂƵÂÊÃëΪµ¥Î»
DBA_JOBS describes all jobs in the database.
USER_JOBS describes all jobs owned by the c ......
alter session set nls_sort='schinese_pinyin_m';
select * from dept order by
nlssort(name,'NLS_SORT=SCHINESE_PINYIN_M');
Oracle9i֮ǰ£¬ÖÐÎÄÊÇ°´ÕÕ¶þ½øÖƱàÂë½øÐÐÅÅÐòµÄ¡£
ÔÚoracle9iÖÐÐÂÔöÁË°´ÕÕÆ´Òô¡¢²¿Êס¢±Ê»
ÅÅÐò¹¦ÄÜ¡£ÉèÖÃNLS_SORTÖµ
SCHINESE_RADICAL_M °´ÕÕ²¿Ê×£¨µÚһ˳Ðò£©¡¢±Ê»®£¨µÚ¶þ˳Ðò£©Å ......
OracleÖеÄdecodeÓ÷¨
Decode(Ìõ¼þ£¬Öµ1£¬ÏÔʾֵ1£¬Öµ2£¬ÏÔʾֵ2£¬…… Öµn£¬ÏÔʾֵn)
Ó¦ÓþÙÀý£º
select t.res_id,
t.res_size || '(kb)' as res_size,
decode(t.res_type,1,'Ä£°åÇø','0','ÎĵµÇø') res_type,
......