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 are Triggers?
How to Truncate Table in Oracle
select statement does not retrieve any records. what exception is raised?
What is transport network substrate (tns) in oracle?
How to create a table interactively?
How to write date and time interval literals in oracle?
What is a sub query? What are its various types?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is a package ? What are the advantages of package ?
What is recycle bin in Oracle?
What is a Sequence ?
Does facebook use oracle?