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 are the different approaches used by Optimizer in choosing an execution plan ?

2 Answers  

---

How do we know whether an index is created on a table ???

2 Answers   TCS,

---

How many categories of data types?

0 Answers  

---

What is Private Database Link ?

1 Answers  

---

master table and child table performances and comparisons in Oracle ?

0 Answers  

---

How to set a transaction to be read only in oracle?

0 Answers  

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

0 Answers  

---

4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>

1 Answers   Wipro,

---

What is archive log in Oracle?

0 Answers   MCN Solutions,

---

What is the difference between translate and replace in oracle?

0 Answers  

---

What are main difference between Stored Procedure and Functions.

6 Answers   CA, Metric Stream,

---

What are the tools for Oracle ?

0 Answers   Infosys,

---