/* ************************************************ */
/*                                                  */
/* Author            : Rick Kupcunas                */
/*                   : rick@kupcunas.com            */
/* Name		     : show_obj.sql                 */
/* Run: C:\rkupcuna05_ora\OracleDBA\SQL\show_obj.sql  */
/* Original          : 2002-May-05                  */
/*                                                  */
/* This script will Shows data for a given object   */
/*                                                  */
/* ************************************************ */

spool show_obj.rslt;

set pagesize 100;
set linesize 132;
set long 300;
break on "OWNER" on "VIEW" on "USERNAME";

select substr(owner,1,12)          "OWNER",
       substr(object_name,1,25)    "OBJECT",
       object_type                 "TYPE",
       created                     "CREATED",
       last_ddl_time               "UPDATED",
       status                      "STATUS"
       from     sys.dba_objects
       where    object_name = upper('&&OBJECT_NAME');

spool off;
undefine OBJECT_NAME;

