¹ØÓÚoracleµÄ×Ô¶¨ÒåtypeµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
ʹÓÃÁË×Ô¶¨Òåtype
ÈçÏÂ
create or replace type customtype as object(
ele1 char(7),
ele2 char(3)
);
Ö®ºóÔÚpackageÀïÃæÏëʹÓÃ
ÓÚÊÇд
l_ele1_c customtype.ele1%type;
µ«ÊDz»ÐУ¬pls00206µÄ´íÎó
ÆäʵÎÒ¾ÍÊÇÏëÔÚ×Ô¶¨ÒåtypeÄDZ߶¨ÒåºÃÁË£¬packageÄDZßÒÔºó¾Í²»»á±äÁË£¬Ö»ÒªÊ¹ÓÃcustomtype.ele1µÄtype¾ÍºÃÁË
ÇëÎÊÓÐûʲô½â¾ö·½°¸£¿
ʵÔÚ²»ÐУ¬¾ÍÖ»Äܶ¨Òål_ele1_c char(7);ÁË¡¡
TYPE Table_ele1 IS TABLE OF customtype.ele1%TYPE;
TABele1 Table_ele1;
ÓÃTABele1¾Í¿ÉÒÔÁË(Ãû×ÖËæ±ã)
Â¥É쵀 ËûòËÆ ÏëÒýÓõÄÊÇ TYPE ÀïÃæµÄÕâ¸ö
ÄÇÄãΪʲô²»Ö±½Ó¶¨ÒåÊÇ ¾Í
create or replace type customtype as object(
ele1 char(7)
);
TABele1 Table_ele1;
лл¥ÉÏÁ½Î»£¬Æäʵ¾ÍÊÇ¿Í»§¸øÁ˸ötype¶¨Ò壬˵һ¶¨ÒªÓã¬È»ºóÒªÎÒÀ´Ð´Ò»¸öpackage£¬ÓÖ˵±ØÐëÒªÓÃ%typeµÄÐÎʽ¡£ÎҾ;À½áÁË¡¡
ÔÀ´¿ÉÒÔÏÈÓñäÁ¿Ê¹ÓÃÕâ¸öÀàÐÍ
È»ºóʹÓñäÁ¿µÄtypeÀ´¶¨Òå¡¡
Àý£º
l_type customtype;
l_ele1_c l_type.ele1%type;
Ïà¹ØÎÊ´ð£º
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ã棬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
CREATE OR REPLACE PROCEDURE usp_refreshTopN
IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......
oracleº¯ÊýÈçÏ£º
create or replace function P_WEB_GETCITYID
(
p_mobileNumber in VARCHAR2,
p_cityid out NUMBER
) Return NUMBER
IS
p_areacode varc ......
java.sql.SQLException: ORA-04031: unable to allocate 26416 bytes of shared memory ("shared pool","SELECT * from ( SELECT rownu...","Typecheck heap","qry_text : qcpis ......
ÎÒÓÃmyeclipseÁ¬½ÓOracleÒ»Ö±±¨´í£¬Ò»ÏÂÊDZ¨´í½Øͼ£¬
Çó¸ßÈËÏàÖú¡£
ÎÞͼÎÞÕæÏà....
file:///C:/Documents%20and%20Settings/Administrator/×ÀÃæ/SF/Oracle%20JDBCÁ¬½Ó´íÎó.png
....
Äã¿´¿´Çý¶¯ºÍORACLEµÄ°æ ......