Answer / lenka

select *
from global_name;

Answer / pradeeshkumar

this will also work.

select global_name from global_name;

Answer / pradeeshkumar

select global_name from global_name;

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)

what is pragma?

2 Answers  

---

how do get database name at sql prompt?

3 Answers  

---

Differentiate between post-database commit and post-form commit?

0 Answers  

---

Explain what are the advantages of views?

0 Answers  

---

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

2 Answers   Mind Tree,

---

5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.

6 Answers   Wipro,

---

What is oracle host variable?

0 Answers  

---

How would you begin to troubleshoot an ORA-3113 error?

0 Answers  

---

How to add a new column to an existing table in oracle?

0 Answers  

---

hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4

1 Answers   CTS,

---

What is index in Oracle?

0 Answers   MCN Solutions,

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

---