CODEWITHSUNDEEP
oracle-databaseshellcommand-lineterminal
mirzalazuardi
mirzalazuardi

Reputation: 45

what is tool like mycli or pgcli on oracle database?

Is there any tool like mycli or pgcli for oracle database? Because it is very useful when I'm querying inside terminal, and their autocomplete feature also help me a lot.

I often use terminal, so I really need this kind of software tool.

Upvotes: 1

Views: 539

Answers (2)

APC
APC

Reputation: 146239

The command line tool which comes bundled with Oracle is SQL*Plus. Find out more.

SQL*Plus is now a rather old tool so it doesn't necessarily do everything we'd want in a command line tool, or do things in the most intuitive fashion. Even its name looks old-fashioned. Oracle realise this and have a new product, sqlcl. It does lots of neat things (command history, autocompletion, scripting, oh my!) but it is a standalone download and install. Find out more.

Upvotes: 1

Ole Tange
Ole Tange

Reputation: 33685

If you want a general wrapper: GNU SQL http://www.gnu.org/s/parallel/sql.html

Upvotes: 0

Related Questions