I very rarely mess with Oracle at my workplace

Recently I forgot the name of a table so wanted to list all the tables in the oracle database

Obviously I didn’t know the command so I had to muddle with it for a while and then the following command did the trick and can be used to display all tables in oracle

<strong>select * from cat;</strong>


3 comments untill now

  1. thanks helped me with my oracle problems

  2. Very helpful. Many Thanks!

  3. it will work to see all the tables in oracle

    Select * from tab;

Add your comment now