Questions tagged [oracle-sqlcl]
The oracle-sqlcl tag has no usage guidance.
6
questions
1
vote
0answers
93 views
oracle sqlcl and sqlplus - seperate login.sql on linux
I feel I'm probably missing something obvious here, but I can't see an easy way to have a separate login.sql for sqlplus and sqlcl
This is problematic for me as the errors thrown up by sqlplus for the ...
0
votes
0answers
72 views
Liquibase on Oracle SQLcl - table and index drops not being propagated
I've been using Oracle's SQLcl, specifically the lb command to use Liquibase, for the last day or so to use for versioning my development, staging and production databases, which are using Oracle's ...
1
vote
1answer
231 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
196 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
370 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
2k 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
...