Hi all!

I have this query:

1.I would like to see all the columns and table_names for the query passed as under.

But there are 3 to 4 tables which have column names like STORE_CODE which is not getting
selected by the undermentioned query.

Could anyone please guide me as to where I had gone wrong.

Why this query is not selecting all the table names in the STORE Modules.

select distinct(ucc.column_name),ucc.table_name
from user_constraints u,user_cons_columns ucc
where ucc.column_name in ('STORE_NO','STORE_CODE','ISSUE_STORE_CODE','RECEIPT_STORE_CODE')
and ucc.owner = 'BALAJI'

Could anyone please guide me as to where I had gone wrong.


Thanks&Regards,

Amit.