<div>
to find the session id:<br />
<br />
declare<br />
v_par1 NUMBER;<br />
BEGIN<br />
v_par1 :=SYS_CONTEXT('USERENV','S<wbr />ESSIONID')<wbr />;<br />
dbms_output.put_line ('Session ID = '|| v_par1);<br />
end;<br />
/
</div>


to find the session id:

declare
v_par1 NUMBER;
BEGIN
v_par1 :=SYS_CONTEXT('USERENV','SESSIONID');
dbms_output.put_line ('Session ID = '|| v_par1);
end;
/

<div>
thanks for the quick response angel;<br />
<br />
i just need to know how do i get the machine info that the user is comming from ?<br />

</div>


thanks for the quick response angel;

i just need to know how do i get the machine info that the user is comming from ?


<div>
You can also use:<br />
<br />
sys_context('USERENV', 'HOST')<br />
<br />
to get the value of V$SESSION.MACHINE.<br />
<br />
Due to security audit reasons, some places may not allow access to the V$SESSION view.
</div>


You can also use:

sys_context('USERENV', 'HOST')

to get the value of V$SESSION.MACHINE.

Due to security audit reasons, some places may not allow access to the V$SESSION view.

<div>
<div class="content wysiwyg-content">
Hi All,<br />
In Oracle sql how can write a query to show the current session details, i.e. there are many people logged into the database but i want the pl/sql routine to just pickup the session details of the user currently executing the plsql;<br />
<br />
please help<br />
<br />
thanks<br />
H
</div>
</div>


Hi All,
In Oracle sql how can write a query to show the current session details, i.e. there are many people logged into the database but i want the pl/sql routine to just pickup the session details of the user currently executing the plsql;

please help

thanks
H

In Oracle sql how can write a query to show my current session details

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.