Stack Overflow
Stack Overflow

Questions tagged [sqlcl]

sqlcl is a command line interface for Oracle databases.

sqlcl is a command line inteface for Oracle databases. It is similar to SQL*Plus but contains additional features such as in-line editing and auto-completion.

Questions with the tag should probably also have the tag.

81 questions
0
votes
0 answers

SQLcl Error in java : package oracle.jdbc.internal is sealed

I am not able to access (get/retrieve) any data from Database. I see this error every time when I need to work in SQLcl and, I was not able to find any solution in Oracle Community
mohamed essam
  • 19
  • 1
  • 10
0
votes
1 answer

Oracle SQLcl: Spool to json, only include content in items array?

I'm making a query via Oracle SQLcl. I am spooling into a .json file. The correct data is presented from the query, but the format is strange. Starting off as: SET ENCODING UTF-8 SET SQLFORMAT JSON SPOOL content.json Follwed by a query, produces…
cbll
  • 6,499
  • 26
  • 74
  • 117
0
votes
0 answers

Show feedback for errors but not success in SQL Developer

In SQL Developer, set feedback off hides all the output irrespective of error messages. I want to hide only the messages that are success and show the error messages. This is how SQL*Plus behaves. Is the same behaviour possible in SQL Developer and…
Sarthak
  • 1,076
  • 1
  • 12
  • 20
0
votes
3 answers

why does my sql query work in sqldeveloper but not from the command line using sqlcl?

select * from test where test like '%test%' This returns the expected data using sqldeveloper, but from the command line using sqlcl, when i type this command and hit enter, i just see a 2. If I hit enter again I see a 3. What am I missing here? …
Ben
  • 519
  • 1
  • 7
  • 14
-1
votes
1 answer

How to handle Oracle SQLcl syntax errors?

I'm using Jenkins for CI/CD Oracle PL/SQL scripts using Oracle SQLcl, so i want to catch syntax errors for Jenkins Pipeline, for example: SQL> seelect * from emp; Error que empieza en la línea: 1 del comando : seelect * from emp Informe de error…
Salvador Arreola Rojas
  • 45
  • 5
-1
votes
2 answers

Is there a way to establish a db connection and run a query in a single command with sqlcl?

I run the following command to connect to a remote db: /bin/sql user/pass@delphix-1.test.com:1521:vd4 I want to run this but with a query included in a single line. I tried just adding a space and the query after vdbsl4, but that did not work (I…
Ben
  • 519
  • 1
  • 7
  • 14
1 2 3 4 5
6