USER_TABLES « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. USER_TABLES
1.query table_name, tablespace_name from user_tables
2.Query a table in user_table by table_name
3.Query user_tables for the table just created
4.To get a listing of all tables that you own
5.User_tables structure
6.Get table name and table space for a table by its name
7.alter table emp move tablespace users and then check the result by querying user_tables
8.Create sql statements from user_tables
9.Verify the creation of the statistics by running the following queries: