What is The UNIQUE_SESSION_NAME function ?

[beingchinmay]

The UNIQUE_SESSION_NAME function returns a name that is unique among the sessions currently connected to the database. You can use this function to obtain a name for a pipe that you know will not be in use by any other sessions. The specification is:

FUNCTION DBMS_PIPE.UNIQUE_SESSION_NAME RETURN VARCHAR2;
C.10.10

 

[salim11]

Very informative post thanks for sharing.

 

[Martin smith]

Unique _Session_name returns the unique name for the current session.

 

[jacks009]

I agree with this post.