Oracle PL/SQL

Sunday, September 03, 2006

Name of the Current User

I just noticed in a Function in Sybase that returns the name of the current Database user :-

select suser_name()

------------------------------
test_user

The equivalent of this in Oracle is :-

SELECT USER FROM DUAL;
------------------------------
test_user

0 Comments:

Post a Comment

<< Home