Search Results

Thanks a lot for ur useful reply.......

Hi,

I have a script in which i have to ask user to press the ENTER key to proceed further. can you please help me how can i achive this in my scripting?


echo "All the executables builded...

I have set all oracle env in the scripts, but still no luck

ORACLE_SID=cisa2;export ORACLE_SID
export ORACLE_BASE=/dboracle/orabase
ORACLE_HOME=/dboracle/orabase/product/9.2.0.6;...

hi,

I have prepared a script with contents

/dboracle/orabase/product/9.2.0.6/bin/sqlplus -s rcrp/rcrp<<EOF

CREATE TABLE ADDER_CUG_LIST
(
CUG_ID VARCHAR2(15) NOT NULL,
TEL_NO ...

Cameron,

That's Brilliant !!!!!!!!

Thanks a lot.

Cheers,
Plaban

sqlplus -s rcrp/rcrp<<EOF
update PRICE_CLASS_DET set PCD_VALUE=1 where PCD_ID=11313;
commit;
exit;
EOF

if [ $? != 0 ]
then
echo "The Tariff Group Revert Back...

Hi All,

I am not able to check the output of sqlplus command if it fails.

can any body please help me in this regard.