Hi All,
I have a report in which at the page footer I want to display the database name.
How can I achieve this?
Thanx in advance.
for sql server: db_name()
for oracle: SYS_CONTEXT('USERENV','DB_NAME')
or,
select substr(global_name,1,instr(global_name, '.',1)-1) "DB Name" from global_name