Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

±±´óÇàÄñ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×Ö½Ú
 
´æ´¢¿É±ä³¤¶È×


Ïà¹ØÎĵµ£º

±±´óÇàÄñoracleѧϰ±Ê¼Ç13

ǶÌ×±í£º
Óë¿É±äÊý×éÀàËÆ£¬²»Í¬Ö®´¦ÊÇǶÌ×±íûÓÐÊý¾ÝÉÏÏÞ¡£
Óï·¨£º
´´½¨»ùÀàÐÍ
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 clusterware ºÍ oracle rac µÄÖ÷Òª²¿¼þ

ÏÖÔÚ¿´Ïà¹ØµÄRAC½á¹¹µÄÎÄÕ»¹²»Ì«Àí½â¡£
ÏÖÔÚ¿´Õâ¸ö¾ÍºÜÇå³þÆäÖеÄÒâ˼ÁË¡£
oracle clusterware Ö÷ÒªÓÐÒÔÏÂÖ÷Òª²¿¼þ£º
CSS: ¼¯ÈºÍ¬²½·þÎñ
Ö÷Òª¹ÜÀíÕû¸ö¼¯ÈºÄÚ¸÷¸ö½Úµã¼äµÄÇé¿ö£¬°üÀ¨½ÚµãµÄÌí¼ÓºÍ¼õÉÙ¡£ÓëÖ®¶ÔÓ¦µÄÊÇocssd ½ø³Ì£¬Èç¹û¸Ä½ø³Ì³öÏÖ¹ÊÕϽ«»áµ¼Ö½ڵãÖØÆô¡£Èç¹ûʹÓÃÁ˵ÚÈý·½µÄclusterware£¬css ͨ¹ýµÚÈý·½clus ......

¿ìËÙɾ³ýoracleÖØ¸´¼Ç¼


×ܽáÁËÒ»ÏÂɾ³ýÖØ¸´¼Ç¼µÄ·½·¨£¬ÒÔ¼°Ã¿ÖÖ·½·¨µÄÓÅȱµã¡£
¼ÙÉè±íÃûΪTbl£¬±íÖÐÓÐÈýÁÐcol1£¬col2£¬col3£¬ÆäÖÐcol1£¬col2ÊÇÖ÷¼ü£¬²¢ÇÒ£¬col1£¬col2ÉϼÓÁËË÷Òý¡£
1¡¢Í¨¹ý´´½¨ÁÙʱ±í
¿ÉÒÔ°ÑÊý¾ÝÏȵ¼Èëµ½Ò»¸öÁÙʱ±íÖУ¬È»ºóɾ³ýÔ­±íµÄÊý¾Ý£¬ÔÙ°ÑÊý¾Ýµ¼»ØÔ­±í£¬SQLÓï¾äÈçÏ£º
creat table tbl_tmp (select distinct* from tb ......

ORACLE 10 (¸¶Ê×ê¿)ѧϰ±Ê¼Ç µÚ2½Ú ÃüÁî¡£

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ