oracle execute immediate command concatenation

Question

oracle execute immediate command concatenation. e.g.

BEGIN EXECUTE IMMEDIATE 'DROP TABLE Foo'; END;

works.

BEGIN EXECUTE IMMEDIATE '''DROP TABLE ' || tableName || ''''; END;
BEGIN EXECUTE IMMEDIATE '''DROP TABLE ' || 'Foo'''; END;

not working.

Table name is an input parameter in stored procedure.

Popeye · Accepted Answer · 2020-01-29 03:30:10Z

0

Your single quotes are improper.

Use following:

BEGIN EXECUTE IMMEDIATE 'DROP TABLE ' || tableName; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE ' || 'Foo'; END;

Cheers!!

answered Jan 29, 2020 at 3:30

Popeye

36k4 gold badges12 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1