oracle´æ´¢¹ý³ÌµÄ¶¯Ì¬Óαê³ö´í - Oracle / ¿ª·¢
create or replace procedure prc
AS
sqlstr varchar2(3000);
type resultcur is ref cursor;
begin
sqlstr := ¡®select * from tableÃû where Ìõ¼þ¡¯;
open resultcur for sqlstr; ---´Ë´¦±¨´í
......
end prc;
Compilation errors for PROCEDURE PRC
Error: PLS-00330: invalid use of type name or subtype name
Line: 148
Text: open resultcur for sqlstr;
ÇëÎÊ´óÏÀÃÇ£¬ÕâÊÇʲô´íÎó£¬Ôõô½â¾ö£¬Çë´Í½Ì£¡
SQL code:
-- ¸ø¸öÀý×Ó¸øÄ㣬×Ô¼º¿´×Űì°É£º
-----------------------------------------------------------------------------
create or replace package pkg_emp_info
as
type myrctype is ref cursor;
procedure emp_info_proc(v_empno in number default 0,v_ename in VARCHAR2, v_deptno number default 0,p_rc out myrctype);
end pkg_emp_info;
/
create or replace package body pkg_emp_info
as
procedure emp_info_proc(v_empno in number default 0,v_ename in VARCHAR2, v_deptno number default 0,p_rc out myrctype)
is
sqlstr VARCHAR2(2000);
begin
sqlstr :=
'SELECT * from emp e where 1=1';
if v_empno<>0 then
sqlstr := sqlstr||' and e.empno='||v_empno;
end if;
if v_ename<>'' then
sqlstr := sqlstr||' and e.ename like ''%||v_ename||%''';
end if;
if v_deptno<>0 then
sqlstr := sqlstr||' and e.deptno='||v_deptno;
end if;
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
13 NO
13 YES ......
select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ
1,2,3,4
ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û
1
2
3
4
ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö???
ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó
SQL code:
wi ......