tabown.sql
テーブルの所有者を一覧表示させる
■使用法
SQL> @tabown <テーブル名-完全一致>
■例
SQL> @tabown employees
OWNER TABLE_NAME
--------------- ------------------------------
HR EMPLOYEES
code:SQL
-- List table owners.
-- Specify the table name as the first argument. (Perfect match)
-- Example: @tabown emp
define TBLNM=&1
set verify off
set timing off
@column_format
select OWNER,TABLE_NAME from dba_tables where TABLE_NAME =upper('&TBLNM');
undefine 1 TBLNM
@default_settings