Pages

Wednesday, July 2, 2014

sqlplus misc


Display large row data with sqlplus

SET SERVEROUTPUT ON SIZE 1000000;
SET LINESIZE 50000;
set pagesize 50000;
set long 50000;

Login w/o tns entry using ip address: 

sqlplus user@'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ip_addr)(PORT=1551))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XXXX)))'