Oracle SqlPlus Command Line: There's a way to concatenate set options?

Posted by Lex on Stack Overflow See other posts from Stack Overflow or by Lex
Published on 2010-03-18T12:18:59Z Indexed on 2010/03/18 12:21 UTC
Read the original article Hit count: 451

Filed under:
|
|

Heya,

I need to set up some SET options in Oracle SQLplus command line program each time I use it, such as SET HEADING OFF and the likes to beautify my results. I found that I always have to input each line separately so Set different options and this is becoming annoying since I need to access it many times a day.

I found that there's no way to separate different SET commands with semicolumns because it doesn't accept it:

SET HEADING OFF; SET LINESIZE 100;

returns an error

A solution could be adding them to a control script and create a shell alias, but I know control scripts execute and then exit and don't return you control over the command line.

So, anybody knows another solution? Or am I missing something?

© Stack Overflow or respective owner

Related posts about oracleclient

Related posts about sqlplus