±±´óÇàÄñoracleѧϰ±Ê¼Ç16
PL/SQL
¿é½á¹¹
DECLARE
ÉùÃ÷²¿·Ö
BEGIN
¿ÉÖ´Ðв¿·Ö
EXCEPTION
Òì³£´¦Àí²¿·Ö
END;
Àý£º
Ê×ÏÈÎÒÃÇ¿´Ò»¸ö¼òµ¥Ö®Àý×Ó,ÏÂÃæÕâ¸öÀý×ÓÊÇͳ¼Æ´Ó1ÖÁ100µÄ×ܺÍ.
declare
i number:=0; /*ÉùÃ÷±äÁ¿¾®¸ø³õÖµ*/
t number:=1;
error_message exception; /*ÉùÃ÷Ò»¸ö³ö´í´¦Àí*/
begin
for t in 1..100 loop
i:=i+t;
end loop;
if i>=5050 then
raise error_message; /*Òý·¢´íÎó´¦Àí*/
else
insert into c_nt(c_t) values(i);
end if;
exception
when error_message then
insert into c_nt(c_t) values(0);
end;
Ò»¡¢
±äÁ¿
1.
ÄÚÖÃÊý¾ÝÀàÐÍ
A.
±êÁ¿
a)
NUMBER
Datatype
Range
Subtypes
description
BINARY_INTEGER
[-214748364, 2147483647]
NATURAL
NATURAL
NPOSITIVE
POSITIVEN
SIGNTYPE
ÓÃÓÚ´æ´¢µ¥×Ö½ÚÕûÊý¡£
ÒªÇó´æ´¢³¤¶ÈµÍÓÚNUMBERÖµ¡£
ÓÃÓÚÏÞÖÆ·¶Î§µÄ×ÓÀàÐÍ(SUBTYPE):
NATURAL:ÓÃÓڷǸºÊý
POSITIVE:Ö»ÓÃÓÚÕýÊý
NATURALN:Ö»ÓÃÓڷǸºÊýºÍ·ÇNULLÖµ
POSITIVEN:Ö»ÓÃÓÚÕýÊý£¬²»ÄÜÓÃÓÚNULLÖµ
SIGNTYPE:Ö»ÓÐÖµ:-1¡¢0»ò1.
NUMBER
[1.0E-130,1.0E126)
DEC
DECIMAL
DOUBLE
PRECISION
FLOAT
INTEGERIC
INT
NUMERIC
REAL
SMALLINT
´æ´¢Êý×ÖÖµ£¬°üÀ¨ÕûÊýºÍ¸¡µãÊý¡£¿ÉÒÔÑ¡Ôñ¾«¶ÈºÍ¿Ì¶È·½Ê½£¬Óï·¨£º
number[ ( [,])]¡£
ȱʡµÄ¾«¶ÈÊÇ38,scaleÊÇ0.
PLS_INTEGER
[-214748364, 2147483647]
ÓëBINARY_INTEGER»ù±¾Ïàͬ£¬µ«²ÉÓûúÆ÷ÔËËãʱ£¬PLS_INTEGERÌṩ¸üºÃµÄÐÔÄÜ ¡£
b)
CHARACTER
datatype
rang
subtype
description
CHAR
×î´ó³¤¶È32767×Ö½Ú
CHARACTER
´æ´¢¶¨³¤×Ö·û´®£¬Èç¹û³¤¶ÈûÓÐÈ·¶¨£¬È±Ê¡ÊÇ1
LONG
×î´ó³¤¶È2147483647×Ö½Ú
´æ´¢¿É±ä³¤¶È×
Ïà¹ØÎĵµ£º
ǶÌ×±í£º
Óë¿É±äÊý×éÀàËÆ£¬²»Í¬Ö®´¦ÊÇǶÌ×±íûÓÐÊý¾ÝÉÏÏÞ¡£
Óï·¨£º
´´½¨»ùÀàÐÍ
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 Ç ......
ÏÖÔÚ¿´Ïà¹ØµÄRAC½á¹¹µÄÎÄÕ»¹²»Ì«Àí½â¡£
ÏÖÔÚ¿´Õâ¸ö¾ÍºÜÇå³þÆäÖеÄÒâ˼ÁË¡£
oracle clusterware Ö÷ÒªÓÐÒÔÏÂÖ÷Òª²¿¼þ£º
CSS: ¼¯ÈºÍ¬²½·þÎñ
Ö÷Òª¹ÜÀíÕû¸ö¼¯ÈºÄÚ¸÷¸ö½Úµã¼äµÄÇé¿ö£¬°üÀ¨½ÚµãµÄÌí¼ÓºÍ¼õÉÙ¡£ÓëÖ®¶ÔÓ¦µÄÊÇocssd ½ø³Ì£¬Èç¹û¸Ä½ø³Ì³öÏÖ¹ÊÕϽ«»áµ¼Ö½ڵãÖØÆô¡£Èç¹ûʹÓÃÁ˵ÚÈý·½µÄclusterware£¬css ͨ¹ýµÚÈý·½clus ......
×ܽáÁËÒ»ÏÂɾ³ýÖØ¸´¼Ç¼µÄ·½·¨£¬ÒÔ¼°Ã¿ÖÖ·½·¨µÄÓÅȱµã¡£
¼ÙÉè±íÃûΪTbl£¬±íÖÐÓÐÈýÁÐcol1£¬col2£¬col3£¬ÆäÖÐcol1£¬col2ÊÇÖ÷¼ü£¬²¢ÇÒ£¬col1£¬col2ÉϼÓÁËË÷Òý¡£
1¡¢Í¨¹ý´´½¨ÁÙʱ±í
¿ÉÒÔ°ÑÊý¾ÝÏȵ¼Èëµ½Ò»¸öÁÙʱ±íÖУ¬È»ºóɾ³ýÔ±íµÄÊý¾Ý£¬ÔÙ°ÑÊý¾Ýµ¼»ØÔ±í£¬SQLÓï¾äÈçÏ£º
creat table tbl_tmp (select distinct* from tb ......
ORACLE 10 ѧϰ±Ê¼Ç-µÚ2½Ú-ÃüÁî¡£
1. inner join / left join/ right join / full join
select a.dname, b.ename from dept a, emp b where a.deptno=b.deptno and a.deptno=10;
select a.dname, b.ename from dept a inner join emp b
on a.deptno=b.deptno and a.deptno=10;
select dname,ename from dept natural ......