OraFAQ Forum: Forms » How to get the databasename within forms

Home » Developer & Programmer » Forms » How to get the databasename within forms

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to get the databasename within forms [message #80791]

Sat, 23 November 2002 05:13

Samuel Linjer
Messages: 5
Registered: July 2002

Junior Member

Hi,

How could I get the databasename into a parameter (:database)in forms.
I will use the dbname to logon a new user.
eg:

logon(:ID,:PW||'@'||:database);

Thanks!
//Sam

Report message to a moderator

Re: How to get the databasename within forms [message #80792 is a reply to message #80791]

Sat, 23 November 2002 15:01

Robert
Messages: 43
Registered: August 2000

Member

select name into :dbname from sys.v_$database;

Report message to a moderator

Re: How to get the databasename within forms [message #80795 is a reply to message #80791]

Mon, 25 November 2002 00:24

Samuel Linjer
Messages: 5
Registered: July 2002

Junior Member

Thanks ! It solved my problem! //SAM

Report message to a moderator

Previous Topic:	What is varcar2 max size in 9i
Next Topic:	form at runtime

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 05:43:55 CDT 2024