UNIQUE_SESSION_NAME v16

Suggest edits

The UNIQUE_SESSION_NAME function returns a name that is unique to the current session.

<name> VARCHAR2 UNIQUE_SESSION_NAME

Parameters

name

Unique session name.

Examples

The following anonymous block retrieves and displays a unique session name:

DECLARE
    v_session       VARCHAR2(30);
BEGIN
    v_session := DBMS_PIPE.UNIQUE_SESSION_NAME;
    DBMS_OUTPUT.PUT_LINE('Session Name: ' || v_session);
END;

Session Name: PG$PIPE$5$2752
← Prev

SEND_MESSAGE

↑ Up

DBMS_PIPE

Next →

UNPACK_MESSAGE