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)))'