Search Results

Thank you very much for your response.
Yes, that is what I wanted to do, and my table contains such records which have year as 2011.
Now I found the solution :b:, actually I inserted the records...

Hi,

Can any one help me...
the records are not deleting when I run the below script.
But if I issue the same delete command manually, the records are getting deleted.

script:

#!/bin/ksh...

Hi joeyg,
Please find the below details::

Testpurging.sh 2
Response::

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP,...

Hi,

Can any one help me, in deleting the records from the database table based on the following condition:
script should take a configurable parameter as input. The input is nothing but “no. of...

Hi,

when i tried with this I got the output as follows

sqlplus $user/$passwd@$sid << SQL 2>&1 >> session.log
select * from Testtab.sql
SQL

ksh: user: 0403-041 Parameter not set.
and I...

Hi Skrynesaver,

I can able to see the same response, after removing -s option

Hi,
Can anyone help me that, How to see the table fields in Oracle database through shell script(ksh).
I have tried with the following:

sqlplus -s $user/$passwd@$sid << SQL >> session.log
...