spool get_tabs.rslt 

set linesize 80;
set pagesize 1000;
set long 50;
set echo on;

break on "OWNER" on "TBL - NAME";

/* ****************************************************** */
/*                                                        */
/* substitute the table_name variable with the new        */
/* name in CAPITAL LETTERS                                */
/*  - will show the attributes associated with a table    */
/*                                                        */
/* name:    @c:\oracle\sql\get_tbls.sql                   */
/* date:    12-MAY-95                                     */
/* creator: Rick Kupcunas (Oracle)                        */
/*                                                        */
/* ****************************************************** */

select 	owner                      "OWNER",
        table_name                 "TBL - NAME",
        count(*)
from 	all_tab_columns 
where   owner != 'SYSTEM' and
        owner != 'SYS'    and
        TABLE_NAME = '&&TABLE_NAME'
group by owner,
        table_name
order by 1 asc;

set echo off;
spool off;
set long 80;
commit;









