Create table sql in Oracle which prompts for table name

Question

I want to create table so that when the query runs, it asks for the table name. I am sure this is a duplicate post but would like to know if this is possible with Oracle?

Justin Cave · Accepted Answer · 2012-02-10 19:00:45Z

6

If you are using SQL*Plus, you can use substitution variables (&variable_name)

SQL> create table &name (
  2    col1 number,
  3    col2 date
  4  );
Enter value for name: fuzzy_bunny
old   1: create table &name (
new   1: create table fuzzy_bunny (

Table created.

SQL> select * from fuzzy_bunny;

no rows selected

answered Feb 10, 2012 at 19:00

Justin Cave

233k25 gold badges378 silver badges395 bronze badges

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

Collectives™ on Stack Overflow

Create table sql in Oracle which prompts for table name

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related