What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-10-29 09:26:11
check if table exists oracle
SELECT * FROM USER_TABLES WHERE TABLE_NAME = 'my_table'; -- Tables from schemes you can access SELECT * FROM ALL_TABLES WHERE OWNER = 'scheme_name' TABLE_NAME = 'my_table'; -- Tables from schemes you can access SELECT * FROM DBA_TABLES WHERE OWNER = 'sche... Add solution -
SQL 2021-10-26 02:21:05
oracle list tablespaces
SELECT * FROM USER_TABLES; -- Tables from connected schema SELECT * FROM ALL_TABLES; -- Tables available to connected schema SELECT * FROM ALL_TABLES WHERE OWNER = 'SCHEMA_NAME'; SELECT * FROM ALL_TABLES WHERE TABLES_NAME = 'TABLE_NAME'; SELECT * FROM... Add solution -
SQL 2021-10-09 09:27:06
oracle tablespace tables list
SELECT * FROM USER_TABLES; -- Tables from connected schema SELECT * FROM ALL_TABLES; -- Tables available to connected schema SELECT * FROM ALL_TABLES WHERE OWNER = 'SCHEMA_NAME'; SELECT * FROM ALL_TABLES WHERE TABLES_NAME = 'TABLE_NAME'; SELECT * FROM... Add solution