Answer Posted / amit choubey

insert

How to load excel data sheet to oracle database

1024

---

Is there an oracle sql query that aggregates multiple rows into one row?

976

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1076

---

How to use attributes of the implicit cursor in oracle?

1008

---

Why does oracle 9i treat an empty string as null?

1055

---

How to save query output to a local file?

1026

---

What is a select query statement in oracle?

967

---

How do I limit the number of oracle database connections generated by weblogic server?

1070

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2292

---

What is a parameter file in oracle?

1134

---

what is the difference between substr and instr function in oracle?

1090

---

How to experiment a data lock in oracle?

1056

---

What are the various constraints used in oracle?

1045

---

Explain what are the different type of segments?

965

---

Can you assign multiple query result rows to a variable?

987

---