André Spadini | MultiCloud | DBA

André Spadini | MultiCloud | DBA

Oracle: glogin.sql

Oracle: glogin.sql

Subscribe to my newsletter and never miss my upcoming articles

$ vim $ORACLE_HOME/sqlplus/admin/glogin.sql 

-- Adicionar as seguintes linhas: 

SET PAGESIZE 1000 
SET LINESIZE 220 
SET SERVEROUTPUT ON SIZE UNLIMITED FORMAT WRAPPED 
DEFINE _EDITOR = /usr/bin/vim 
COLUMN segment_name FORMAT A30 WORD_WRAP 
COLUMN object_name FORMAT A30 WORD_WRAP 
SET TIMING ON 
SET TIME ON 
SET SQLPROMPT "_USER'@'_CONNECT_IDENTIFIER > "
 
Share this