Query a table in user_table by table_name : USER_TABLES « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. USER_TABLES

Query a table in user_table by table_name

  
SQL>
SQL> create table t(
  2    a int
  3  );

Table created.

SQL>
SQL>
SQL> select table_name, tablespace_name
  2    from user_tables
  3   where table_name = 'T';

TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
T                              SYSTEM

SQL>
SQL> drop table t;

Table dropped.

SQL>








Related examples in the same category

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