Shell Programming and Scripting

#! /bin/sh
 
sqlplus -s uname/pwd@samplDB << EOF
 
set heading off
set feedback off
 
ACCEPT X PROMPT 'ENTER X: '
 
select * from sam_tab where s_name like '%&X%';
 
exit
 
EOF
 

#!/bin/ksh
echo "enter a value \c"
read value
printf "'%s'"  $value | read X
sqlplus -s uname/pwd@somedb << EOF
set heading off
set feedback off

 
select ${X} from dual;
 
exit
 
EOF

#! /bin/sh

sqlplus -s uname/pwd@samplDB << EOF

start mysqlscript
exit;
EOF

WHENEVER SQLERROR EXIT


set heading off
set feedback off

select * from sam_tab where s_name like '&X';
 
exit

sqlplus -s uname/pwd@samplDB << EOF
 
set heading off
set feedback off
 
ACCEPT X PROMPT 'ENTER X: '
 
select * from sam_tab where s_name like '%&X%';
here I want to get the user input again to delete the paricular row.--

ACCEPT is_ok PROMPT 'Shall I delete the Row? [Y/N] : '

-- here i want execute the delete stamt if the user enters "Y" 
if [ &is_ok == "Y" ] Then
delete from sam_tab where s_name like '%x%';
end if;

exit
EOF

WHENEVER SQLERROR EXIT
 
set heading off
set feedback off
select * from sam_db where no=&inp;
exit

#! /bin/sh
sqlplus -s uname1/pwd1@testDB << EOF
start t1.sql
exit;
EOF

Enter value for shall_i_show_you: old 1: 
select * from sam_db where no=&inp
new 1: 
select * from sam_db where no=exit;