Home » SQL & PL/SQL » SQL & PL/SQL » the name of the aplication
the name of the aplication [message #21813] Mon, 02 September 2002 06:52 Go to next message
lucho
Messages: 1
Registered: September 2002
Junior Member
As I can obtain the name of the aplication the which I am working example: oracle, forms.

help!!!
Re: the name of the aplication [message #21815 is a reply to message #21813] Mon, 02 September 2002 20:48 Go to previous message
Manju
Messages: 10
Registered: November 2000
Junior Member
Hi,
You could try this statement

select distinct module from v$sql ;

This will give you the names of the various Oracle applications that are running.
If you want other details, you may consider removing the distinct and giving other appropriate filter criteria
Hope this helps

Cheers,
Manju
Previous Topic: Explicit Cursors with Variables
Next Topic: PL/SQL-Errors
Goto Forum:
  


Current Time: Fri Apr 19 02:55:48 CDT 2024