set appinfo OFF
set appinfo "SQL*Plus"
set arraysize 15
set autocommit OFF
set autoprint OFF
set autorecovery OFF
set autotrace OFF
set blockterminator "."
set cmdsep OFF
set colsep " "
set compatibility NATIVE
set concat "."
set copycommit 0
set copytypecheck ON
set define "&"
set describe DEPTH ALL LINENUM ON INDENT ON
set echo OFF
set editfile "/opt/oracle/sql/afiedt.buf"
set embedded OFF
set escape OFF
set feedback on
set flagger OFF
set flush ON
set heading ON
set headsep "|"
set logsource ""
set long 2000000000
set longchunksize 80
set markup HTML OFF HEAD "<style type='text/css'> body {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} p {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} table,tr,td {font:10pt Arial,Helvetica,sans-serif; color:Black; background:#f7f7e7; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px;} th {font:bold 10pt Arial,Helvetica,sans-serif; color:#336699; background:#cccc99; padding:0px 0px 0px 0px;} h1 {font:16pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; border-bottom:1px solid #cccc99; margin-top:0pt; margin-bottom:0pt; padding:0px 0px 0px 0px;} h2 {font:bold 10pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; margin-top:4pt; margin-bottom:0pt;} a {font:9pt Arial,Helvetica,sans-serif; color:#663300; background:#ffffff; margin-top:0pt; margin-bottom:0pt; vertical-align:top;}</style><title>SQL*Plus Report</title>" BODY "" TABLE "border='1' width='90%' align='center' summary='Script output'" SPOOL OFF ENTMAP ON PRE OFF
set newpage 1
set null ""
set numformat ""
set numwidth 10
set pause OFF
set recsep off
set recsepchar "."
set serveroutput ON SIZE UNLIMITED FORMAT WORD_WRAPPED
set shiftinout invisible
set showmode off
set sqlblanklines OFF
set sqlcase MIXED
set sqlcontinue "> "
set sqlnumber ON
set sqlpluscompatibility 10.2.0
set sqlprefix "#"
set sqlterminator ";"
set suffix "sql"
set tab ON
set termout ON
set time OFF
set timing OFF
set trimout ON
set trimspool ON
set underline "-"
set verify ON
set wrap ON
set pagesize 50000
set linesize 157

#set sqlprompt "&&_USER@&&_CONNECT_IDENTIFIER#";

define identificador='{ NO CONECTADO }'
set termout off
column conexion new_value identificador 
select lower(user) || '@' || instance_name conexion from v$instance;
set termout on

set sqlprompt '&identificador# '

define _EDITOR=vi

-- Formato de columnas

COLUMN PARAMETER FORMAT A30
COLUMN VALUE FORMAT A50
COLUMN USERNAME FORMAT A30
COLUMN OBJECT_NAME FORMAT A30
COLUMN PRIVILEGE FORMAT A20;
COLUMN OWNER FORMAT A30
COLUMN TABLE_NAME FORMAT A30
COLUMN ACCOUNT_STATUS FORMAT A20
COLUMN PASSWORD FORMAT A30
COLUMN TABLESPACE_NAME FORMAT A30
column object_type format a25
column timestamp format a25
COLUMN PATH FORMAT A70
COLUMN GRIDBD FORMAT a16
column OBDESC format a30
COLUMN APENOM FORMAT A40
COLUMN TELEFONO FORMAT A9
COLUMN POBLACION FORMAT A20
column CORREOELECTRONICO format a15
column DIRECTORY_PATH format a70
COLUMN COLUMN_NAME FORMAT A30
column index_type format a30
column  DIRECTORY_NAME format a30
column db_link format a30
column host format a30
COLUMN cpu_used FORMAT a20
COLUMN run_duration FORMAT a20
COLUMN actual_start_date FORMAT a20
COLUMN log_date FORMAT a20
COLUMN job_name FORMAT a30
column grantee format a30
column object_type format a20
column property_name format a30
column property_value format a35
column description format a70
column name format a50
column member format a60
col ec_name format a30
column synonym_name format a30
column table_owner format a30;
column FILE_NAME format a70
column maxmeigas format a10;
COLUMN INCREM FORMAT A10;
COLUMN STATUS FORMAT A20;