Find a table name

[gandolf989]

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.