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 |
What suggestions do you have to reduce the network traffic?
What are the differences between number and binary_float in oracle?
Can sub procedure/function be called recursively?
What is a nvl function?
definition of cluster and non-clustered index?
How would you go about verifying the network name that the local_listener is currently using?
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
How to use "if" statements on multiple conditions?
What are the advantages of oracle 12c?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to view all columns in an existing table?
Where do you use decode and case statements?