KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Guys is there any other way to determine a table exists other than below select count(*) from <table> where rownum =1 select * from user_table where table_name=<table> kindly let me know the best way to check whether a table exists using oracle sql. Thanks for the answer , my requirement is to check from the first date of current month ie 01/12/2010 with table name in the format suresh_20101201 exists in the database, if not then it should check for table suresh_20101202 and thereon till suresh_20101231 . is it possible to do in oracle sql query.
Tags (comma-separated)
Save Edits
Cancel