¹ØÓÚ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;
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
SQL code:
CREATE OR REPLACE PROCEDURE usp_refreshTopN IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ
1,2,3,4
ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û
1
2
3
4
ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö???
ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó
SQL code:
wi ......