Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> get unix environment variable within PL/SQL in a a varchar2 type.
Hi ,
I need to read the value of the environment variable from within a
PL/SQL code and then store it in the a varchar2 datatype
How can I achive ?
e.g
declare
v_name varvar2(200);
begin
v_name := <GET HERE VALUE OF SAY $MYDTATADIR> end; Received on Tue Oct 26 1999 - 11:57:30 CDT