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 synchronize 2 schema's objects?
What is query image?
how many triggers we can create on a table
11 Answers G2 Technology, TCS,
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??
can u call user defined functions in select statements
What are privileges and grants?
What is Parallel Server ?
What is a dynamic performance view in oracle?
What happens if the update subquery returns multiple rows?
How to assign a table row to a record variable?
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.
What are advantages fo Stored Procedures?