Questions tagged [oracle-sqlcl]
Oracle SQLcl is a command line interface for Oracle Database. It is a Java-based replacement for SQL*Plus, providing a more modern experience in addition to supporting most of the SQL*Plus features.
8
questions
0
votes
1
answer
57
views
How to format the output of query in SQLcl to have no header?
I want to execute a query that will produce an output that are SQL commands too to be executed later. Something like:
SELECT
'DROP ' || OBJECT_TYPE || ' "' || owner || '"."' || ...
- 133
0
votes
1
answer
254
views
SQLcl Oracle to export data to CSV without blank first line and without carriage return character at the end
For reasons, I am using the following here-doc approach to export data to CSV.
$ /oracle/sqlcl/bin/sql -s username/password@//host.mybiz.com.my:1521/dwh > arca.csv <<EOF
SET SQLFORMAT CSV
SET ...
- 111
1
vote
0
answers
130
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 ...
- 137
0
votes
0
answers
240
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
1
answer
460
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 ...
- 2,218
3
votes
1
answer
222
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
==== ======= =================== =====...
- 2,218
0
votes
1
answer
597
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....
- 2,218
1
vote
0
answers
3k
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
...
- 111