Shell Programming and Scripting

Hi all,
Sorry for late reply.

Not one \ two \\ is enough( if we use one \ we will get ORA- errors)

I know only two \\ before $ (I am observed the same before) but three \\\ also working fine for me

Thanks for pointing that out scripter_online.

The table v$log_history is a standard table and I was able to try it.

Within the backticks we need three backslashes.
Without the backticks we need one backslash.

I was testing without the backticks !

Comment: It is much easier to put the whole sql program in a file and execute that. That way you do not have to protect shell characters.


Re-reading the posts, "plelie2" fixed the o/p issue yesterday.

Hi methyl,

Without the backticks we need one backslash.
Within the backticks we can use two or three backslashes.

Please check the example below

Code:

$ VALUE=`sqlplus -S "/ as sysdba" <<END
set pagesize 0 feedback off verify off heading off echo off
select max(sequence#) from v\\$log_history;
exit;
END`
$ echo $VALUE
1216
$ VALUE1=`sqlplus -S "/ as sysdba" <<END
set pagesize 0 feedback off verify off heading off echo off
select max(sequence#) from v\\\$log_history;
exit;
END`
$ echo $VALUE1
1216

Both are working

I use(required) three \\\ at one suituation to connect oracle !!!!! Sorry I forgot the suituation

To know how to connect to oracle from unix shell script
Connecting to oracle database from unix shell script | Scripter World

Interesting scenario scripter.online. I have been writing unix shell scripts to run Oracle processes for too many years and long ago stopped using unix "here documents" for Oracle programs because of the clashes with unix shell. I can explain the multiple backslash scenario, but continue to recommend storing Oracle programs in ".sql" text files.


BTW: The link provided leads to a website with many typos. View with caution.
P.S. forget to "quit" an Oracle session.