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 to drop an existing view in oracle?
Explain the use of constraints option in exp command.
What is clustered table in Oracle?
What is oracle database client?
What are advantages of dateset in datastage?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
What is a Data Dictionary ?
Can objects of the same Schema reside in different tablespaces.?
Explain what are clusters?
what are the things that you consider while creating indexes on partitioning tables?
What is a user account in oracle?
How to rename an index?