How to check if a table exist in Oracle?

Question

In Sql I check if a table exist with this code:

IF NOT EXISTS (SELECT NAME FROM SYSOBJECTS  
     WHERE NAME = 'Plane')
   CREATE TABLE Plane(Flight int)

How to do this check if a table not exist then i create it in Oracle because it throws exception if i try to create already existing table?

possible duplicate of [Oracle: If Table Exists](http://stackoverflow.com/questions/1799128/oracle-if-table-exists) — devnull, Mar 19 '14 at 03:12

score 2 · Answer 1 · answered Feb 23 '11 at 09:11

2

you can check the data dictionary for that table

select table_name from user_tables where table_name='MYTABLE';

answered Feb 23 '11 at 09:11

Mansuro

score 1 · Answer 2 · answered Dec 25 '12 at 18:37

1

CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name (create_definition,...) [table_options] [partition_options]

answered Dec 25 '12 at 18:37

Loay

2 Answers2