ORACLE 10 ѧϰ±Ê¼ÇÃüÁî µÚÒ»¿Î¡£(¸¶Ê×ê¿)
ORACLE 10 ѧϰ±Ê¼ÇÃüÁîµÚÒ»¿Î¡£
1.
sqlplus /nolog
connect /as sysdba
alter user scott account unlock;
alter user scott identified by manager;
2.
grant select on dept to nmerp;
revoke select on dept to nmerp;
select * from scott.dept
create table abc(a varchar2(10),b char(10));
alter table abc add c number;
3.
select length('abcdef') from dual;
select trim( 'abc' ) from dual;
select substr('abcdefg',2,3) from dual;
4.
sysdate/current_date/next_day
max/min/sum/count/avg
user/decode
5.
select a.dname,b.ename,b.sal,b.comm,b.job
from dept a right join emp b
on a.deptno=b.deptno and a.deptno=10;
6.
select ename,to_char(hiredate,'YYYY-MM-DD') from emp;
7.
select max(sal),min(sal) from emp;
select avg(sal),sum(sal) from emp;
select variance(sal),stddev(sal) from emp; (·½²îºÍ±ê×¼²î)
select deptno,avg(sal),max(sal) from emp group by deptno;
select deptno,job,avg(sal),max(sal) from emp group by deptno,job;
select deptno,avg(sal),max(sal) from emp group by deptno having avg(sal)<2000;
8.
select dept.dname, emp.ename from dept,emp where dept.dname='sales';
select dept.dname, emp.ename from dept,emp where dept.deptno=emp.deptno;
select d.dname, e.ename from dept d , emp e where d.deptno=e.deptno;
select e.ename, e.sal, d.dname from emp e, dept d where e.deptno=d.deptno;
9.
select a.ename, a.sal, b.grade from emp a, salgrade b
where a.sal between b.losal and b.hisal;
10.
select manager.ename from emp manager, emp worker where manager.empno=worker.mgr
and worker.ename='BLAKE';
Ïà¹ØÎĵµ£º
1.2.1 OracleÓëAIXµÄ½ÇÉ«
OracleÔËÐÐÔÚAIXÉÏ£¬Ìṩ×ÅÊý¾ÝµÄ´æ´¢ºÍ¹ÜÀí·þÎñ¡£Êý¾Ý¼´ÐÅÏ¢£¬OracleÊý¾Ý¿â¾ÍÊÇÓ¦ÓÃϵͳÖд洢Êý¾ÝÐÅÏ¢µÄÒ»¸ö¼¯Öд洢λÖá¢Ò»ÖÖ´æÈ¡·½·¨µÄÉÌÆ·»¯ÊµÏÖ¡£AIXÊdzÐÔØOracleÔËÐеĵײãƽ̨£¬½øÐÐ×ÅCPUµ÷¶È¡¢ÄÚ´æµ÷¶È¡¢´æ´¢¹ÜÀí¡¢Îļþ¹ÜÀí¡¢ÍøÂçÇý¶¯µÈϵͳÔËÐкÍά»¤¹¤×÷¡£
×÷Ϊ¶ÔÓ¦ÓÃϵͳµÄÖ§ ......
ÒòΪǿÖƹػú£¬¿ª»úµÄʱºò½øÈëÊý¾Ý¿â±¨´í£º
ora_01034:oracle not available
ora_27101:shared memory realm does not exit
½â¾ö·½·¨£º
1.´ò¿ªCMD
2.ÊäÈë sqlplus "/as sysdba"
3.»Ø³µ
4.ÊäÈë startup
5.½áÊø ......
Êý¾Ý¿âÖ®¼äµÄÁ´½Ó½¨Á¢ÔÚDATABASE LINKÉÏ¡£Òª´´½¨Ò»¸öDB LINK£¬±ØÐëÏÈ
ÔÚÿ¸öÊý¾Ý¿â·þÎñÆ÷ÉÏÉèÖÃÁ´½Ó×Ö·û´®¡£
1¡¢ Á´½Ó×Ö·û´®¼´·þÎñÃû£¬Ê×ÏÈÔÚ±¾µØÅäÖÃÒ»¸ö·þÎñÃû£¬µØÖ·Ö¸ÏòÔ¶³ÌµÄÊý¾Ý¿âµØÖ·£¬·þÎñÃûȡΪ½«À´ÄãҪʹÓõÄÊý¾Ý¿âÁ´Ãû£º
2¡¢´´½¨Êý¾Ý¿âÁ´½Ó£¬
½øÈëϵͳ¹ÜÀíÔ±SQL>²Ù×÷·ûÏ£¬ÔËÐÐÃüÁî£ ......
3ÔÂ6ÈÕ£º
¾Å¡¢±í¹ÜÀí£º
Ò»¡¢ÔÙ±í¹ÜÀíÖÐÐèҪѧϰµÄÄÚÈÝ£º
1¡¢ ´´½¨±í
2¡¢ ³£ÓõÄÊý¾ÝÀàÐÍ
3¡¢ ɾ³ý±í
4¡¢ ¸´ÖƱí
5¡¢ Ð޸ıí
6¡¢ ±íÖØÃüÃû
7¡¢ ½Ø¶Ï±í
8¡¢ ±íµÄÔ¼ÊøÌõ¼þ
¶þ¡¢´´½¨±í
³£¼û±íÓï·¨£º
´´½¨±íÓï·¨£º
CREATE TABLE ±íÃû
(
&nb ......
Oracle µÄ¹ÜÀí¿ÉÒÔͨ¹ýOEM»òÕßÃüÁîÐнӿڡ£ Oracle ClusterwareµÄÃüÁ¿ÉÒÔ·ÖΪÒÔÏÂ4ÖÖ£º
½Úµã²ã£ºosnodes
ÍøÂç²ã£ºoifcfg
¼¯Èº²ã£ºcrsctl, ocrcheck,ocrdump,ocrconfig
Ó¦Óò㣺srvctl,onsctl,crs_stat
ÏÂÃæ·Ö±ðÀ´½éÉÜÕâЩÃüÁî¡£
Ò»£® ½Úµã²ã
Ö»ÓÐÒ»¸öÃüÁ¡¡osnodes£¬ Õâ ......