sql command 2 know current database
Answers were Sorted based on User's Feedback
Answer / pradeeshkumar
this will also work.
select global_name from global_name;
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / madhu sekhar
You want to know the What is the Data Base version you are
using you can go like this
1) show version (In sql*Plus)
2) Select * from v$version;(In Toad or PL/SQL Developer)
| Is This Answer Correct ? | 1 Yes | 0 No |
difference between imlicit cursor and explicit cursor ?
How many types of table in Oracle?
How can we create the complete backup of data in the oracle.
0 Answers IPEC, Satyam, SunTec,
How to use values from other tables in update statements using oracle?
How to find no of saturdays in a month using single sql ?
what is cartesian product?
How to bring a tablespace online?
How can we find out the current date and time in oracle?
what is the syntax of update command?
How to write an inner join with the where clause in oracle?
Explain an index segment?
How can Oracle users be audited?