set heading off
set feedback offset linesize [nr] - value between 1- 32767
set termout offset pagesize [nr] - "0" means no limit
set serveroutput on size unlimited - means no buffer limit for output dbms_output
set numwidth 50 - wyłączenie zaokrąglania cyfr
config $oracle_home/sqlplus/glogin.sql
set linesize 1000
set pagesize 1000
set sqlprompt "_user _connect_identifier> "
config $oracle_home/sqlplus/glogin.sql
set linesize 1000
set pagesize 1000
set sqlprompt "_user _connect_identifier> "
connectint without tnsnames.ora:
- client10g:
sqlplus user/password@//hostname:port_nr/db_sid
- client9i:
sqlplus user/password@"(descripteion=(address_list=(address=(pototcol=tcp)(host=hostname)(port=port_nr)))(connect_data=(sid=db_sid)))"
sqlplus linux vs previous command:
install rlwrap
rlwrap sqlplus
- client10g:
sqlplus user/password@//hostname:port_nr/db_sid
- client9i:
sqlplus user/password@"(descripteion=(address_list=(address=(pototcol=tcp)(host=hostname)(port=port_nr)))(connect_data=(sid=db_sid)))"
sqlplus linux vs previous command:
install rlwrap
rlwrap sqlplus