Home » RDBMS Server » Server Utilities » into table clause Syntax
into table clause Syntax [message #72661] Wed, 20 August 2003 03:04 Go to next message
Thorsten
Messages: 1
Registered: August 2003
Junior Member
Hallo everybody!
Is it possible to insert a substitution variable as the tablename.
For example: INTO TABLE %year% or INTO TABLE &string
or something else.

greets
thorsten
Re: into table clause Syntax [message #72663 is a reply to message #72661] Wed, 20 August 2003 06:15 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
dbadmin@mutation_mutation > create table test(c1 number);

Table created.

dbadmin@mutation_mutation > insert into &tname values (1);
Enter value for tname: test
old   1: insert into &tname values (1)
new   1: insert into test values (1)

1 row created.

dbadmin@mutation_mutation > /
Enter value for tname: test
old   1: insert into &tname values (1)
new   1: insert into test values (1)

1 row created.

dbadmin@mutation_mutation > select * from test;

        C1
----------
         1
         1

Previous Topic: Importing tables in the default tablespace of a user
Next Topic: access to imp/exp from db.client
Goto Forum:
  


Current Time: Sat Jun 29 13:32:50 CDT 2024