Find a table name

[tamilselvan]

Why? why would the front end user need to know what tables are being used in the gui?

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