Passing variables to sql from batch shell in linux

Linux and Unix-Like Linux
1

Hi,

I need to put this command in a batch shell.

sqlplus -s user/password @test.sql

and in the test.sql I have this command

select * from pbempl where pebempl_id = $1;

How I can pass the variable $1 from the batch shell???

Thanks

2

I found what we have to do

in the sql script we should put

select * from pbempl where pebempl = '&&1'

then in unix shell script we should put

#! /bin/sh

sqlplus usr/password @test.sql 23345

Thanks

3

Use a HERE document. Here is a link that will show you how.