Check if table, column exist in large database
523088Aug 2 2006 — edited Aug 2 2006Dear All!
I'm writing a perl script in which I use database manipulation (for Oracle), with the DBI module.
How can I check whether a given table name is exists in a large database. The command:
select table_name from user_tables where table_name =' name I look for'
always returns 0. I doesn' t work for me.
If I use select * from "my table name" : how it operates with the memory, because of the *
command?
Is there any way, that from the table (which existence I try check) I select a random column or the first one. ?
thank you!!
nagybaly