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 |
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
Why use resource manager in Oracle?
What is the function of Optimizer ?
what is the bitmap index?
What would you do with an in-doubt distributed transaction?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
Is there a combination of "like" and "in" in sql?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
Can multiple columns be used in group by in oracle?
How do you store pictures in a database?
Explain do view contain data?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)