set sqlplus variable based on query 1

[etprash]

Hi,
I need to set a sqlplus variable using a query (since the value is stored in database). It would be something like this:

define v_req_id = <select request_id from my_table>
HOST uuencode '&v_req_id' a.txt|/usr/lib/sendmail <email id>

Would it be possible.
I tried using ACCEPT but was not able to make it work.
Thanks a lot for your input.
-Prashant

 

[SantaMufasa]

ETPrash,

Here is some code you can use:

col v_req_id new_value v_req_id
select request_id v_req_id from my_table;
HOST uuencode '&v_req_id' a.txt|/usr/lib/sendmail <email id>

Let us know how this works for you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]