PROCEDURE BASE_INSERT
(
V_TABLENAME VARCHAR2,
V_NAME VARCHAR2,
V_SCORE VARCHAR2
)
AS
V_STR VARCHAR2(10) := '';
SQLTXT VARCHAR2(2000):= '';
V_NAME1 VARCHAR2(50);
V_SCORE1 VARCHAR2(50);
BEGIN
V_SCORE1 := '||'||V_SCORE||'||';
SELECT A.STR INTO V_STR FROM DUAL LEFT JOIN
(SELECT '''' STR FROM DUAL) A ON 1=1;
SQLTXT := 'INSERT INTO '||V_TABLENAME||' VALUES ('||V_STR||V_NAME||V_STR||','||V_STR||V_SCORE||V_STR||')';
EXECUTE IMMEDIATE SQLTXT;
COMMIT;
END BASE_INSERT;
Oracle存儲過程中使用逗號
最新推荐文章于 2022-04-01 11:20:22 发布