Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1236
  • Last Modified:

Display Userid in Oracle Report

Hello,

How to display userid on the Oracle Report

Thanks
Huong
0
hlinhdan
Asked:
hlinhdan
1 Solution
 
FarazMSyedCommented:
hi there ...

if u r asking about Oracle user from which u logon when u run your report then just write user in your select statement .... as follows :

in SQL of your report ....
Select empno, user from emp;
this will return ...
empno    user
-----    ----
7862     SCOTT
7863     SCOTT
7866     SCOTT

u can print this user in the header of your report as well ...

regards
Faraz
0
 
RMZCommented:
hi
u can make formulla column
declare
 v_user varchar2(25);
begin
select user into v_user from dual;
return(v_user);
end;
0
 
hlinhdanAuthor Commented:
Thank you very much for your help

Huong
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now