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 |
how the indexes are stored in the Oracle Database?
How to call a stored function in oracle?
What are transaction isolation levels supported by oracle?
Does oracle database need java?
What is the relation of a user account and a schema in oracle?
What is connection pooling in oracle?
waht is the difference between primary key and super key?
How to use subqueries with the in operator using oracle?
What is the difference between implicit index and explicit index?
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
Does a Before form trigger fire when the parameter form is suppressed ?
How many types of synonyms in Oracle?