Oracleѧϰ±Ê¼Çժ¼8
<1> ORACLEµÄʹÓÃ
Æô¶¯ºÍ¹Ø±Õ
¹¤¾ß²Ù×÷ORACLE -- sql*plus
plsql developer
<2> SQLÃüÁî
4´óÀà
DDL Êý¾Ý¶¨ÒåÓïÑÔ - ½¨Á¢Êý¾Ý¿â¶ÔÏó
create /alter/ drop/ truncate
DML Êý¾Ý²Ù×ÝÓïÑÔ - Êý¾ÝµÄ²é¿´ºÍά»¤
select / insert /delete /update
TCL ÊÂÎñ¿ØÖÆÓïÑÔ - Êý¾ÝÊÇ·ñ±£´æµ½Êý¾Ý¿âÖÐ
commit / rollback / savepoint
DCL Êý¾Ý¿ØÖÆÓïÑÔ -- ²é¿´¶ÔÏóµÄȨÏÞ
grant / revoke /ÈçºÎ½¨Óû§
<3> ×Ó²éѯºÍ¹ØÁª²éѯ *********************
¹ØÁª²éѯ - 3¸ö±íµÄ¹ØÁª
select dname,ename
from dept a, emp b
where a.deptno = b.deptno;
×Ó²éѯ -- (1)дÔÚwhere×Ó¾äÖÐ
(2) ×Ó²éѯ¿ÉÒÔ³öÏÖÔÚ×ֶεÄλÖÃÉÏ
(1) select * from emp where sal > (
select avg(sal) from emp );
--¸ßÓÚƽ¾ù¹¤×ʵÄËùÓÐÔ±¹¤
(2) select * from emp a where sal > (
&
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
×î½üÏîÄ¿½ø¶È±È½Ï»ºÂý£¬³õ²½Ñо¿ÁËÒ»ÏÂOracleµÄ´æ´¢¹ý³Ì£¬½«´úÂëÌù³öÀ´¡£
Ê×ÏÈÏÈÌù³öÀ´OracleµÄ·ÖÒ³·ÖÒ³´æ´¢¹ý³Ì´úÂë°É¡£
1.ÕâÊÇ°üµÄ´úÂë
create or replace package DB_Oper is
-- Author : LIUBING
-- Created : 2009-10-28 15:01:30
-- Purpose : ²âÊÔOracleµ ......
ΪÁËÈ·¶¨±í¿Õ¼äÖаüº¬ÄÇЩÄÚÈÝ£¬ÔËÐУº
select owner,segment_name,segment_type
from dba_segments
where tablespace_name='<name of tablespace>'
²éѯ±í¿Õ¼ä°üº¬¶àÉÙÊý¾ÝÎļþ¡£
select file_name, tablespace_name
from dba_data_files
where tablespace_name ='<name of t ......
ÎÒÏÖÔÚÔÚ×öÒ»¸öOracleÊý¾Ýµ¼È룬Ҫ½«EXCELÊý¾Ýµ¼Èëµ½OracleÊý¾Ý¿âÖУ¬ÏȶÁÈ¡Êý¾Ý£¬½«Êý¾Ý±£´æÔÚÒ»ÕÅÁÙʱ±íÖУ¬È»ºóµ¼Èë֮ǰ¶ÔÁÙʱ±íÖÐÊý¾ÝµÄÿ¸ö×Ö¶Î×öУÑ飬±ÈÈçÊý¾ÝÊÇ·ñΪÕûÊý£¬ÕûÊýµÄ×î´óλÊý£¬¼°µ¼ÈëµÄÊý¾ÝÔÚÔÊý¾Ý¿âÖÐÊÇ·ñÒѾ´æÔڵȣ¬ÎÒдÁËÒ»¸ö´æ´¢¹ý³Ì£¬¶ÔÒì³£µÄÊý¾Ý£¬½«×ֶΓis_checked”ÉèΪÒì³ ......
1¡¢´´½¨ÐòÁÐÓï·¨£º(ÐèÒªCREATE SEQUENCEϵͳȨÏÞ)
CREATE SEQUENCE ÐòÁÐÃû
[INCREMENT BY n] ---ÓÃÓÚ¶¨ÒåÐòÁеIJ½³¤¡£
......