Find a table name

Quote:

---

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. :rolleyes:

Quote:

---

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