select name from v$database

how do get database name at sql prompt?

Question Posted / mkumar.it

Answer Posted / mkumar.it

Is This Answer Correct ?

14 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to convert character types to numeric types?

1188

How can I introduce multiple conditions in like operator?

1045

is there a tool to trace queries, like profiler for sql server?

1188

How to execute a stored procedure in oracle?

1141

Is truncate autocommit in oracle?

1147

Can the query output be sorted by multiple columns in oracle?

1045

How to loop through data rows in the implicit cursor?

1116

What is data file?

1146

What is the string concatenation operator in oracle?

1226

How to select an oracle system id (sid)?

1112

How to use "if" statements on multiple conditions?

1215

How to use "startup" command to start default instance?

1094

How to name query output columns in oracle?

1237

Explain user account with reference to oracle.

1025

What do you mean by a tablespace?

1089