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 |
26. Display the earliest shipping date in the format: DD/MON/YYYY
Can we call procedure inside function in oracle?
What is use of oracle?
what is the dual table in oracle?
What is a system tablespace and when it is created?
How to run queries on external tables?
Explain the use of analyse option in exp command.
you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??
what are the default admin accounts in Oracle 10g ?
What happens if recursive calls get out of control?
what is primary key and foreign key when and where have to use
What is an oracle tablespace?