What oracle statement does oracle use to determine whether a table exists or not
- 2020-05-12 06:23:29
- OfStack
The ORACLE tutorial you are looking at is: what oracle USES to determine whether a table exists or not. The statement SQL SERVER USES to determine the existence of a table or view cannot be used in ORACLE.
thank you Questioner: - The best answer exists(select tname from tab where tname ='TABLENAME')
Remember to capitalize the table names, because ORACLE is case-sensitive and all table names are stored in the tab table
thank you Questioner: - The best answer exists(select tname from tab where tname ='TABLENAME')
Remember to capitalize the table names, because ORACLE is case-sensitive and all table names are stored in the tab table