Home » SQL & PL/SQL » SQL & PL/SQL » which tables to compare?
which tables to compare? [message #21176] Wed, 17 July 2002 03:53 Go to next message
a
Messages: 22
Registered: March 2002
Junior Member
How would I write something that a user would be able to type in the name of the tables and that would enter the table names into the sql?

Report message to a moderator

Re: which tables to compare? [message #21178 is a reply to message #21176] Wed, 17 July 2002 04:15 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
SQL> select * from &table_name;
Enter value for table_name: dept
old 1: select * from &table_name
new 1: select * from dept

DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORKS
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON

Report message to a moderator

Previous Topic: urgent
Next Topic: Procedure
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 27 00:15:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.