ORACLE ¶ÔÏóµÄʹÓÃ
--´´½¨¶ÔÏóÀàÐÍ
create or replace type emp_typ as object (
id number,
name varchar2(30),
sal number,
comm number,
member procedure change_comm(new_comm number),
member function get_info return varchar2
) ;
--´´½¨¶ÔÏóÀàÐ͹¹Ô캯Êý¶¨Òå
create or replace type body emp_typ is
member procedure change_comm(new_comm number)
is
begin
comm:=new_comm;
end;
member function get_info return varchar2
is
v_info varchar2(30);
begin
v_info:='ÐÕÃû:'||name ||' ¹¤×Ê:'||sal;
return v_info;
end;
end;
--´´½¨´øÀàÐ͵ıí
create table detail (empt emp_typ,tel number,addr Varchar2(20))
--²åÈëÊý¾Ý
insert into detail values (emp_typ(6666,'yangliping',5000,3000),13675047974,'shanghai caobao')
--¸üÐÂÊý¾Ý
update detail set empt=emp_typ(7777,'yangliing',3000,2000) where tel=13675047974
--²éѯÊý¾Ý
select * from detail
½á¹û:
EMPT.ID EMPT.NAME EMPT.SAL EMPT.COMM TEL ADDR
6666 yangliing 8000 5000 13833338888 ±±¾©
7777 yangliing 3000 2000 13675047974 shanghai caobao
--ɾ³ý¶ÔÏó±íÊý¾Ý
delete from detail where tel=13675047974
Ïà¹ØÎĵµ£º
ÖйúµçÁ¦ÐÐҵĿǰÕýÔÚ¾Àúמ޴óµÄ±ä»¯£º´Ó¹ú¼Ò°ìµçµ½ÆóÒµ°ìµç£¬ÐγÉÁ˶à¼Ò¾ºÕù°ìµçµÄ¸ñ¾Ö£»³§Íø·Ö¿ª¡¢¾º¼ÛÉÏÍø£¬´Ó¼Æ»®µ½Êг¡×ª¹ì£¬ÒýÈë¶àÖÖ¾¼Ã³É·Ö£»´ÓµØÓòÐÔ·ÖÉ¢¹©µçÏò´óµçÍø·¢Õ¹£»´ÓÕþÆó²»·Öµ½ÕþÆó·Ö¿ª¡£ÕâЩ±ä»¯£¬Ê¹ÖйúµÄµçÁ¦ÐÐÒµ¾ÊÜ×ÅÇ°ËùδÓеÄѹÁ¦¡£
Ò»·½Ã棬2003Äê¹úÄڵķ¢µçÆóÒµÖØиÄ×é£ ......
oracle³£ÓÃÊý¾ÝÀàÐÍ
½ñÌìͬÊÂÎÊЩÊý¾ÝÀàÐ͵ÄÎÊÌ⣬ÓеĻ¹ÕæÓеã¼Ç²»ÇåÁË£¬ÓÚÊǾͼòµ¥×ܽáϳ£ÓõÄÊý¾ÝÀàÐÍÒÔ±¸ÈÕºó²éÓÃ
1¡¢Char
¶¨³¤¸ñʽ×Ö·û´®£¬ÔÚÊý¾Ý¿âÖд洢ʱ²»×ãλÊýÌî²¹¿Õ¸ñ£¬ËüµÄÉùÃ÷·½Ê½ÈçÏÂCHAR(L)£¬LΪ×Ö·û´®³¤¶È£¬
ȱʡΪ1£¬×÷Ϊ±äÁ¿×î´ó32767¸ö×Ö·û£¬×÷ΪÊý¾Ý´æ´¢ÔÚORACLE8ÖÐ×î´óΪ2000¡£²»½¨ÒéʹÓ㬻ᴠ......
BLOBת»»ÎªCLOBµÄº¯Êý£¨oracleÖÐÖ´ÐУ©
CREATE OR REPLACE FUNCTION BlobToClob(blob_in IN BLOB) RETURN CLOB AS
v_clob CLOB;
v_varchar VARCHAR2(32767);
v_start PLS_INTEGER := 1;
v_buffer PLS_INTEGER := 32767;
BEGIN
DBMS_LOB.CRE ......
¸Õ¿ªÊ¼Ñ§Ï°Orace£¬Óöµ½Ò»Ð©·Ç³£ºÃµÄÊ飬ÔÚÏÂÃæÁгö£¬Ëæ×ÅѧϰµÄÉîÈë»á°ÑÓöµ½µÄºÃÊ鶼ÁгöÀ´£¬¹©Ñ§Ï°OracleµÄÅóÓѲο¼£¬
Ò²»¶Ó¸÷λÅóÓѲ¹³ä£º
»ù´¡£º
1. ORACLE DBA»ù´¡Åàѵ½Ì³Ì ºÎÃ÷Öø Ç廪´óѧ³ö°æÉç
&n ......