New Oracle Database Command Line Interface from ManQuantTech

#1

Post by cbeeson » Mon, May 13, 2019, 1:06 PM UTC

New Oracle Database Command Line Interface from ManQuantTech
ahl.com

Re: New Oracle Database Command Line Interface from ManQuantTech

#2

Post by gjvc » Mon, May 13, 2019, 1:13 PM UTC

This looks very useful.

See also "rlwrap", which is a very useful tool for enhancing those command line tools which lack readline support.

Not to steal the thunder of the guys behind the orignal post, but Google for "rlwrap sqlplus" to get an idea of how quickly useful it is.

Re: New Oracle Database Command Line Interface from ManQuantTech

#3

Post by notinventedhear » Mon, May 13, 2019, 1:30 PM UTC

gjvc wrote: post #2

This looks very useful. See also "rlwrap", which is a very useful tool for enhancing those command line tools which lack readline support. Not to steal the thunder of the guys behind the orignal post, but Google for "rlwrap sqlplus" to get an idea of how quickly useful it is.

Yes that's true, rlwrap gives you command history on top of sqlplus which makes it much more usable.

Actually, okcli started off as rlwrap with a complicated login file that queried the schema. But if you do that you can't use add a lexer for context-aware auto-complete which was one of the main goals, hence a new cli-tool using cx-oracle which gives way more control.

disclaimer: I'm the author.