Oracleѧϰ±Ê¼Çժ¼6
declare
begin
--SQLÓï¾ä
--Ö±½ÓдµÄSQLÓï¾ä(DML/TCL)
--¼ä½Óдexecute immediate <DDL/DCLÃüÁî×Ö·û´®>
--select Óï¾ä
<1>±ØÐë´øÓÐinto×Ó¾ä
select empno into eno from emp
where empno =7369;
<2>Ö»Äܲ鵽һÐÐ**********
<3>×ֶθöÊý±ØÐëºÍ±äÁ¿µÄ¸öÊýÒ»ÖÂ
exception
--Òì³£
when <Òì³£Ãû×Ö> then --ÌØ¶¨Òì³£
<´¦ÀíÓï¾ä>
when others then --ËùÓÐÒì³£¶¼¿É²¶»ñ
<´¦ÀíÓï¾ä>
end;
<Àý×Ó>
±àд³ÌÐò ÏòDEPT±íÖвåÈëÒ»Ìõ¼Ç¼£¬
´Ó¼üÅÌÊäÈëÊý¾Ý£¬Èç¹û
Êý¾ÝÀàÐÍÊäÈë´íÎóÒªÓÐÌáʾ
ÎÞ·¨²åÈë¼Ç¼ Ò²ÒªÓÐÌáʾ
Ö»ÄÜÊäÈëÕýÊý,Èç¹ûÓиºÊýÌáʾ
declare
n number;
no dept.deptno%type;
nm dept.dname%type;
lc dept.loc%type;
exp exception; --Òì³£µÄ±äÁ¿
exp1 exception;
num number:=0; --¼ÆÊýÆ÷
pragma exception_init(exp,-1); --Ô¤¶¨ÒåÓï¾ä
--(-1´íÎóºÍÒì³£±äÁ¿¹ØÁª)
pragma exception_init(exp1,-1476);
e1 exception; --×Ô¶¨ÒåÒì³£±äÁ¿
begin
--ÊäÈëÖµ
no := '&񅧏';
num := num + 1;
if no < 0 then
raise e1; --×Ô¶¨ÒåÒì³£µÄÒý·¢
&
Ïà¹ØÎĵµ£º
for example:
15:18:59 SQL> create table t1 (a int, b int);
±íÒÑ´´½¨¡£
ÒÑÓÃʱ¼ä: 00: 00: 00.15
......
ÉêÃ÷oracleº¯Êý£¬¼°Æä½á¹û¼¯½á¹¹
½á¹û¼¯±ØÐëΪȫ¾ÖµÄ¡¢table of ²»ÄÜÓÃindex by
CREATE OR REPLACE TYPE EMPARRAY is object (corporationId number)£»
CREATE OR REPLACE TYPE EMPARRAY2 is table of EMPARRAY£»
create or replace function func_empl return sys_refcursor is
Result sys_refcursor;
......
Ò»¡¢ÔÚPLSQLÖд´½¨±í£º
create table HWQY.TEST
(
CARNO VARCHAR2(30),
CARINFOID NUMBER
)
¶þ¡¢ÔÚPLSQLÖд´½¨´æ´¢¹ý³Ì£º
create or replace procedure pro_test
AS
carinfo_id number;
BEGIN
select s_CarInfoID.nextval into carinfo_id
from dual;
insert into test(test ......
oracleµÄÌåϵºÜÅÓ´ó£¬ÒªÑ§Ï°Ëü£¬Ê×ÏÈÒªÁ˽âoracleµÄ¿ò¼Ü¡£ÔÚÕâÀ¼òÒªµÄ½²Ò»ÏÂoracleµÄ¼Ü¹¹£¬ÈóõѧÕß¶ÔoracleÓÐÒ»¸öÕûÌåµÄÈÏʶ¡£
¡¡¡¡1¡¢ÎïÀí½á¹¹£¨ÓÉ¿ØÖÆÎļþ¡¢Êý¾ÝÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ¡¢²ÎÊýÎļþ¡¢¹éµµÎļþ¡¢ÃÜÂëÎļþ×é³É£©
¡¡¡¡¿ØÖÆÎļþ£º°üº¬Î¬»¤ºÍÑéÖ¤Êý¾Ý¿âÍêÕûÐԵıØÒªÐÅÏ¢¡¢ÀýÈ磬¿ØÖÆÎļþÓÃÓÚʶ±ðÊý¾ÝÎļ ......
1.¸ü¸Ä¹éµµÂ·¾¶
ÔÚORACLE10GÖУ¬Ä¬ÈϵĹ鵵·¾¶Îª$ORACLE_BASE/flash_recovery_area¡£¶ÔÓÚÕâ¸ö·¾¶£¬
ORACLEÓÐÒ»¸öÏÞÖÆ£¬¾ÍÊÇĬÈÏÖ»ÄÜÓÐ2GµÄ¿Õ¼ä¸ø¹éµµÈÕ־ʹÓ㬿ÉÒÔʹÓÃÏÂÃæÁ½¸öSQLÓï¾äÈ¥²é¿´ËüµÄÏÞÖÆ
1. select * from v$recovery_file_dest;
sql >show parameter db_recovery_file_dest(Õâ¸ö¸üÓѺÃÖ±¹ÛһЩ)
µ± ......