Questions tagged [oracle-sqlcl]
The oracle-sqlcl tag has no usage guidance.
4
questions
1
vote
1answer
102 views
SQLcl: set color in sqlprompt (ANSI/VT100 Control sequences)
This is my login.sql
SET sqlprompt "_user'@'_connect_identifier > "
SET sqlformat ansiconsole
SET serveroutput on
SET lines 3000
How to set the sqlprompt to color red for Prod (and green color ...
3
votes
1answer
173 views
SQLcl history (up-arrow) rewrites my queries
Version
sql -version
SQLcl: Release 18.4.0.0 Production
I type this:
SQL> exec dbaspace.long_ops;
SID % Done Start Time Rem [s] Elapsed Message
==== ======= =================== =====...
0
votes
1answer
179 views
use SQLcl with EZconnect and multiple hostnames (ADDRESS_LIST=)
this is our classic tnsnames.ora
test1=
(DESCRIPTION=
(CONNECT_TIMEOUT=4)
(TRANSPORT_CONNECT_TIMEOUT=3)
(ENABLE=BROKEN)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=example1....
1
vote
0answers
795 views
Removing REM INSERTING and SET DEFINE OFF from SQLcl Output
I ran below script to get data from Oracle, and then load to Postgres with psql.
SET SQLFORMAT INSERT
SET FEEDBACK OFF
SET TERMOUT OFF
SPOOL asset_file.sql
SELECT * FROM FINANCE.ASSET;
SPOOL OFF
...
