Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to get OS username in Oracle Form (V4.0 or V4.5) ?

Re: How to get OS username in Oracle Form (V4.0 or V4.5) ?

From: MarkP28665 <markp28665_at_aol.com>
Date: 1997/02/13
Message-ID: <19970213232501.SAA12351@ladder01.news.aol.com>#1/1

Why not just select the Oracle psuedo column 'user' as in:

select user

    into v_form_variable
    from sys.dual;

This is how we do it in Forms 3.0 and 4.0 You can also make use of the userenv function in a similiar manner. Received on Thu Feb 13 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US