CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloper
Ronen
Ronen

Reputation: 837

Oracle sqldeveloper - how to connect DB from command line

I am writing a small DB utility. I would like to give the user the ability to open an instance of Oracle sqldeveloper directly from this utility. Is it possible to open Oracle sqldeveloper IDE that already connected to a specific DB?

Something like sqldeveloper USERID/PASSWORD@DATABASE

Upvotes: 13

Views: 23010

Answers (4)

ikiddo
ikiddo

Reputation: 21

Luckily, yes. This is now possible using Oracle's ConnectionHelper extension.

It's a bit of hacky workflow, though. Hopefully they'll figure out a way to include in SQLDeveloper itself, because if management learns about adding a 'githubusercontent' repo they might misjudge the risks.

Also, be sure you make use of a pretty recent SQLDeveloper (20.2+).

But here goes:

  1. In SQLDeveloper, add the following update source, by going to Help -> Check for Updates and hitting 'Add': https://raw.githubusercontent.com/bjeffrie/sqldev-update-center/master/update-center.xml
  2. Select 'Connection Helper' and next-next-finish the wizard (you'll need to restart SQLDeveloper).
  3. Go to Tools -> Preferences and in the left pane, click the node 'Connection Helper', then in the main pane enable 'Accept command line connections'. You don't need any of the other check boxes for what you're asking.
  4. Close SQLDeveloper and start it from CLI: sqldeveloper -myCLIconnection=user/pw@host:port/service

[This is a combination of what's documented by Oracle's thatjeffsmith on his blog and what Oracle's Brian Jeffries put in Oracle's github repo.]

Upvotes: 2

thatjeffsmith
thatjeffsmith

Reputation: 22457

This is now possible with a free, open-source extension as long as you're using version 20.2 or higher of SQL Developer.

I have step-by-step instructions here

A quick GIF of it working...

enter image description here

Upvotes: 4

Anthony
Anthony

Reputation: 39

/? works rather than /h. There are options to override the cofiguration file so whether you can do that or not is probably determined by the facilities offered by the config file.

Upvotes: 2

Kirill Leontev
Kirill Leontev

Reputation: 10941

It doesn't seem so. sqldeveloper.exe /h shows us possible launch parameters, and none of them seem to have anything in common with your demand.

Upvotes: 0

Related Questions