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ÔÊÐíÓû§¶Ô±í½øÐнøÒ»²½¹æ»®£¬¼´¶Ô±í½øÐнøÒ»²½²ð·Ö£¬½«±í·Ö³ÉÈô¸É¸öÂß¼²¿·Ö£¬Ãð¸ö²»·Á³ÆÆäΪ±í·ÖÇø
·¶Î§·ÖÇø£º
¸ù¾Ý±íÖÐÁÐÖµµÄ·¶Î§½øÐзÖÇø
Óï·¨£ºPartition by range(×Ö¶ÎÃû)(
Partition ·ÖÇøÃû values less than (60), --60ÒÔÏÂ
Partition ·ÖÇøÃû values less than (75), --60¡«75
......
----------------------------------------------------------------------------
Ïà¹Ø֪ʶ£ºOracle SYNONYM£¨Í¬Òå´Ê£©
----------------------------------------------------------------------------
ÊÇÒ»ÖÖÓ³Éä¹Øϵ£¬¿ÉÒÔÀí½âΪ±íµÄÒ»Ö̶ֹ¨±ðÃû
ͬÒå´ÊµÄºÃ´¦£º½¨Á¢Ò»¸öͬÒå´Ê¿ÉÒÔÅųýÒ»¸ö¶ÔÏóÃû×ÖµÄÏÞÖÆ
Èç¹ûÄãµÄ ......
ORACLEÊý¾Ý¿â²åÈëÐÔÄܲâÊÔ
MKing
2010-3-8
²âÊÔ»·¾³»ù±¾ÐÅÏ¢£º
OS£ºWindows XP sp3
DB£ºOracle 9.2.0.1 δÆôÓù鵵
DBÖØ×öÈÕÖ¾Îļþ´óС£º100MB
Ó²ÅÌÐͺţºSAMSUNG HD161GJ£¨SATA-300,160G,7200rpm,8M cache£©
CPU£ºIntel Core2 E8400£¨3.0G£©
Äڴ棺2G
ͨ¹ýHD TuneµÃµ½µÄÓ²ÅÌ»ù±¾²âÊÔÐÅÏ ......