-
Originally Posted by tamilselvan
Assume the following two tables exist in a schema.
CUSTOMER
CUSTOMER_ID NUMBER
LAST_NAME VARCHAR2(30)
FIRST_NAME VARCHAR2(30)
SUPPLIER
SUPPLIER_ID NUMBER
LAST_NAME VARCHAR2(30)
FIRST_NAME VARCHAR2(30)
SELECT table_name FROM all_tab_columns
WHERE column_name = 'LAST_NAME'
will return both CUSTOMER and SUPPLIER tables.
Now tell me which one do you want?
Tamil
www.beaconinfotechcorp.com
If you know enough to write that query, than you should know the difference between a customer and a supplier.
-
Originally Posted by davey23uk
but thats nothing to do with the original quesrion
he had no idea what tables his app was using (and why should he)
No idea about table?
Then how does the original poster write a SQL?
Tamil
-
he just doesnt know what tables his app uses.
its nothing to do with knowing sql, its all about finding out which tables his front end gui uses
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|