How to determine whether a table exists in oracle

Oracle method to determine whether a table exists:

1. Open the plsql client and log in to the oracle database;

2. Create a test table,

create table test_exists(id number, value varchar2(20));

3. Write sql, insert into the oracle system view, and query whether the newly created table exists,

select * from user_tables t where table_name= upper('test_exists')；

You can see that there are query results, which means that the table exists;

4. On the contrary, write sql to query whether the test_exists2 table Exists, because no result is returned, the table does not exist;

select * from user_tables t where table_name= upper('test_exists2')；

Oracle Tutorial"

The above is the detailed content of How to determine whether a table exists in oracle. For more information, please follow other related articles on the PHP Chinese website!