how do get database name at sql prompt?

3 Answers  

---

How to pass a cursor variable to a procedure?

0 Answers  

---

Will you be able to store pictures in the database?explain.

0 Answers  

---

Can multiple columns be used in group by in oracle?

0 Answers  

---

how to tune oracle sql queries pls tell me step by step. urgent pls

1 Answers  

---

how to unbreak sequence numbers during intereptions

1 Answers   Ion Exchange,

---

can a table has a column that has only view data and in other columns we can change data?

2 Answers   Secon,

---

What is a initialization parameter file in oracle?

0 Answers  

---

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?

2 Answers   Philips,

---

Explain the use of record length option in exp command.

0 Answers  

---

write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c

1 Answers   KPIT,

---

What is the difference between PFILE and SPFILE in Oracle?

0 Answers   MCN Solutions,

---