select table_name, block_size from dba_tables dt, dba_tablespaces dtbs : dba_tablespaces « System Tables Views « Oracle PL / SQL

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

select table_name, block_size from dba_tables dt, dba_tablespaces dtbs

  

SQL> select table_name, block_size from dba_tables dt, dba_tablespaces dtbs
  2  where dt.tablespace_name = dtbs.tablespace_name and dt.table_name = 'ATM_DATA';

no rows selected

SQL>
SQL>
SQL>

   
    
  

Related examples in the same category