Show User Tables Oracle Database Tutorial Example

How To Show User Tables In Oracle Database Tutorial Example

Run MS-DOS command prompt then copy & paste the below code to show user tables in Oracle Database Server as HR Tutorial Example

-- connect as HR
-- i am using sqlplus as client. you can use anything as you like.
 

   SET LINE 30

   SELECT TABLE_NAME FROM TABS;
   -- OR --
   SELECT TABLE_NAME FROM USER_TABLES;
   -- OR --
   SELECT OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE='TABLE';
   -- OR --
   SELECT TNAME FROM TAB WHERE TABTYPE='TABLE';

      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How To Show User Tables In Oracle Database Tutorial Example - Result in MS-DOS SQLPLUS Client Tools

 

Related Tutorial Examples

1. How To Create USER In Oracle Database Tutorial Example
2. How To Drop USER In Oracle Database Tutorial Example
3. How To GRANT a USER In Oracle Database Tutorial Example
4. How To REVOKE ROLE from a USER In Oracle Database Tutorial Example
5. How To Disconnect From Oracle Database Tutorial Example
6. MySQL NULLIF() Function Number Value Example
7. How to Find MySQL Stored Procedure or Function Information
8. MySQL Sub-Query: INSERT INTO SELECT... Example
9. 19 Examples to Learn MySQL
10. 20 Steps to Learn CakePHP by Example