Path: news.netfront.net!newsgate.cuhk.edu.hk!goblin1!goblin.stu.neva.ru!news2.euro.net!newsfeed.freenet.de!news.tiscali.de!tiscali!newsfeed1.ip.tiscali.net!draco.tiscalinet.it!news-f1.tiscali.it!not-for-mail
Date: Mon, 11 Feb 2008 14:29:08 +0100
From: codadilupo <yossarian99@operamail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.12) Gecko/20070301 SUSE/1.8_seamonkey_1.0.9-1.2 SeaMonkey/1.0.9
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Select Current Session ID ?
References: <528ab0b3-a049-442c-a829-39d5b6020ba4@s37g2000prg.googlegroups.com>
In-Reply-To: <528ab0b3-a049-442c-a829-39d5b6020ba4@s37g2000prg.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Lines: 7
Message-ID: <47b04da4$0$16029$5fc30a8@news.tiscali.it>
Organization: Tiscali SpA
NNTP-Posting-Host: 82.85.0.130
X-Trace: 1202736548 news.tiscali.it 16029 82.85.0.130:37461
X-Complaints-To: abuse@tiscali.it
Xref: news.netfront.net comp.databases.oracle.server:182326

Cassiano wrote:

> How I can select *my* current session id (from v$session?) in sqlplus?

"select sys_context('USERENV','SID') from dual" ?

C.