3 top SQL Queries really useful to check table exists

Many of the times during validation, initially, you need to check, if Table is created by DBA or not. If Table is created, then, you can do validation, and you can check if data is written to Oracle database Table or not. If no Table is created…it is not possible to validate.

DB2 tough interview questions e-book

DB2 Tough Interview Questions an e-book

DB2 is most popular database. You need a quick refresher to revise your DB2 knowledge before you attend an interview. This e-book helps you to refresh DB2 quickly.

$1.00

Listed below are useful SQL queries to check if Table exists in Oracle…

I found the best question on this subject is “How to check if table exists in Oracle database”. I am here to give solution for you.

So..you can use anyone of the below SQL queries to find if Table exists in Oracle using SQL developer.

--First I have created one Table
create table srini_table_one(name char(20),rollnum int);
--Inserted values
insert into srini_table_one values('rama',20);
--Selected rows
select * from srini_table_one;

--How to find table exists
--Method:1
desc srini_table_one;

--Method:2
select * from srini_table_one where rownum=1;

--Method:3
select table_name from user_tables;

Conclusion

3 SQL queries given in this post mostly used in production validation. By  using these queries, you will know not only Table exists also if you have access to read it

References

Questions

  • If you have any questions, you can send to our review
Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.