The << Operator and Running Apps From a Script 2

[Michael42]

Hello,

On Sun Solaris 8 I have the below Bourne shell script.

$ORACLE_HOME/bin/sqlplus / << SQLPLUS_SESSION
SELECT * FROM mytable;
SQLPLUS_SESSION

I use this techniqe alot to have an the Oracle sqlplus tool run using the commands I need all from a Bourne shell script.

My problem is that the commands on the 2nd and 3rd line must behave like they are at the beginning of the line, i.e. if I indent line 2 the script fails.

How can I use this technique (<< MYVAR) and be able to indent? I have been trying to put the command on one line but do not quite have it (this would work too). Unsuccessful example:

$ORACLE_HOME/bin/sqlplus / << SQLPLUS_SESSION SELECT * FROM mytable; ...

What advice can you give?

Thanks,

Michael42

 

[PHV]

In your shell man page read the Input/Output redirection section and pay attention to this syntax:
ORACLE_HOME/bin/sqlplus / << - SQLPLUS_SESSION
[tab char]SELECT * FROM mytable;
SQLPLUS_SESSION

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[feherke]

Hi

I think you need this :

If the redirection operator is <<-, then all leading tab characters are stripped from input lines and the line con­taining delimiter.

Feherke.

http://rootshell.be/~feherke/

 

[Michael42]

Guys that worked very well!

One more follow up please...

How can I specify\respecify how many spaces make up a tab?

My goal is to make my code easier to read. If I can redefine the tab stop in my script that would be great.

Thanks again all,

Michael42

 

[feherke]

Hi

This depends on the editor you use. I think you don't want to do [tt]expand[/tt] ( convert tabs to spaces ).

Feherke.

http://rootshell.be/~feherke/

 

[stefanwagner]

You may not convert tabs to N-spaces, because the tab is adressing a next position, and not jumping over a fix number of spaces.
If you start counting by 0, the positions are 8*i.

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung