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 upsert (update or insert into a table)?
what is primary key and foreign key when and where have to use
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
What happens in oracle commit?
How to create a table interactively?
Differnce between view and index
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
Explain what are the characteristics of data files?
Explain what does a control file contain?
How to run create database statement again?
hai, when to use char and varchar2....?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??