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¡¢±à¼ /etc/apt/sources.list £º
sudo cp /etc/apt/sources.list /etc/apt/sources.list.bak #±¸·Ý
sudo gedit /etc/apt/sources.list
¼ÓÈëÏÂÃæÕâ¸öÔ´£º
deb http://oss.oracle.com/debian unst ......
¹ØϵÐÍÊý¾Ý¿âÀíÂÛÖÐ×Ö¶ÎÖµ±ØÐëÊǵ¥Öµ£¬¶øoracleÖÐÔÊÐíÔÚÒ»¸ö×Ö¶ÎÖд洢һ¸ö±íµÄÄÚÈÝ¡£
È磺Ա¹¤±íÖеÄÍâ¼ü ²¿ÃűàºÅ£¬oracleÖÐÕâ¸ö×ֶοÉÒÔ´æ·Å²¿ÃŵļǼ¶ø²¢²»ÊÇÒ»¸öÍâ¼ü£¬ÕâÑù²éѯʱºòµÄЧÂÊ»áÌá¸ß¡£
¿É±äÊý×飺
´´½¨´øÓпɱäÊý×éµÄ±í
´´½¨¿É±äÊý×é»ùÀàÐÍ
create or replace type »ùÀàÐÍÃû as object(×Ö¶ÎÇåµ¥);
......
ǶÌ×±í£º
Óë¿É±äÊý×éÀàËÆ£¬²»Í¬Ö®´¦ÊÇǶÌ×±íûÓÐÊý¾ÝÉÏÏÞ¡£
Óï·¨£º
´´½¨»ùÀàÐÍ
create or replace type ǶÌ×±í»ùÀàÐÍÃû as object(×ֶβÎÊý);
create or replace type mingxitype as object(
goodsid varchar(15),
incount int,
providerid varchar(10)
)not final;
´´½¨Ç¶Ì×±íÀàÐÍ
create or replace type Ç ......
Oracle µÄ¹ÜÀí¿ÉÒÔͨ¹ýOEM»òÕßÃüÁîÐнӿڡ£ Oracle ClusterwareµÄÃüÁ¿ÉÒÔ·ÖΪÒÔÏÂ4ÖÖ£º
½Úµã²ã£ºosnodes
ÍøÂç²ã£ºoifcfg
¼¯Èº²ã£ºcrsctl, ocrcheck,ocrdump,ocrconfig
Ó¦Óò㣺srvctl,onsctl,crs_stat
ÏÂÃæ·Ö±ðÀ´½éÉÜÕâЩÃüÁî¡£
Ò»£® ½Úµã²ã
Ö»ÓÐÒ»¸öÃüÁ¡¡osnodes£¬ Õâ ......