How to make a simple dynamic query during the stored procedure of Oracle

xiaoxiao2021-03-06  101

Create or Replace Procedure ZXM_SB_GZ_GET

(p_table in varchar2,

p_name in varchar2,

P_Value in varchar2,

OUTPARA OUT LNTXDBA.ZXM_PAG_CS_POWER.C_TYPE

)

AS

Begin

Declare

WHEREVALUE VARCHAR2 (200);

Begin

Wherevalue: = 'Select * from' || p_table || 'Where' || p_name || '=' || p_value;

Open Outpara for

WHEREVALUE;

END;

END;

转载请注明原文地址:https://www.9cbs.com/read-104560.html

New Post(0)