CODEWITHSUNDEEP
sqloracle-databasesqlplus
lsatch
lsatch

Reputation: 3

CREATE TABLE - Concatenating a variable with a string to name the new table

I want to create a tables concatenating a prefix with a given identifier. The prefix will change every time I create a new table with the same query.

I have tried a few variation of the following idea without success:

DEF  prefix_edms = 'z_edm';

CREATE TABLE CONCAT(&prefix_edms,'_TABLE_A') as
(
SELECT 'HolaPoho' from dual
);

Is there any way I can do this in Oracle?

Upvotes: 0

Views: 513

Answers (1)

Littlefoot
Littlefoot

Reputation: 142705

As it is SQL*Plus, you'd then

SQL> set ver off
SQL> def prefix_edms = 'z_edm'
SQL> create table &prefix_edms._table_a as select 'HolaPoho' name from dual;

Table created.

SQL> select * from z_edm_table_a;

NAME
--------
HolaPoho

SQL>

Upvotes: 1

Related Questions