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 do I know if oracle is installed on windows?
What is an oracle cursor variable?
How to resolve the ORA-39133 error in Oracle?
How to execute a stored procedure in oracle?
what are steps for interface? where is exchange rate defined in which table?
what is the difference between data migration and production migration.
Name the various constraints used in oracle?
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
Hi Can any one tell me what are the API's used in requisition import.
How can I create database in oracle?
What is the usage of control file in oracle?
Does oracle charge for java?