sql command 2 know current database

Answers were Sorted based on User's Feedback



sql command 2 know current database..

Answer / lenka

select *
from global_name;

Is This Answer Correct ?    7 Yes 0 No

sql command 2 know current database..

Answer / pradeeshkumar

this will also work.

select global_name from global_name;

Is This Answer Correct ?    4 Yes 1 No

sql command 2 know current database..

Answer / pradeeshkumar

select global_name from global_name;

Is This Answer Correct ?    2 Yes 0 No

sql command 2 know current database..

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

Post New Answer

More Oracle General Interview Questions

How can you use check constraints for self referential integrity?

1 Answers  


In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

4 Answers   Cap Gemini,


What is the sql query to concatenate column values from multiple rows in oracle?

1 Answers  


What is the difference between translate and replace?

1 Answers  


what is Single Byte Overhead...?

1 Answers  


What is ADDM Advisor in Oracle?

1 Answers   MCN Solutions,


How to use "out" parameter properly?

1 Answers  


dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.

3 Answers  


Explain index?

1 Answers  


Which are the five query types available in oracle?

1 Answers  


What is oracle database client?

1 Answers  


What are the arithmetic operations?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)