Home
Oracle PL / SQL
Aggregate Functions
Analytical Functions
Char Functions
Constraints
Conversion Functions
Cursor
Data Type
Date Timezone
Hierarchical Query
Index
Insert Delete Update
Large Objects
Numeric Math Functions
Object Oriented Database
PL SQL
Regular Expressions
Report Column Page
Result Set
Select Query
Sequence
SQL Plus
Stored Procedure Function
Subquery
System Packages
System Tables Views
Table
Table Joins
Trigger
User Previliege
View
XML
USER_TABLES « System Tables Views « Oracle PL / SQL
Oracle PL / SQL
System Tables Views
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: