How do I recompile a procedure in oracle?

0 Answers  

---

I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.

4 Answers  

---

waht is referencial integrity?

2 Answers   Semantic Space,

---

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

2 Answers  

---

Explain the difference between a procedure and a function? What do you understand by those terms?

0 Answers  

---

How does one get the view definition of fixed views/tables?

0 Answers  

---

Is java required for oracle client?

0 Answers  

---

1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.

2 Answers   Wipro,

---

What is ordinary table in oracle?

0 Answers   MCN Solutions,

---

What is the max number of columns in an oracle table?

0 Answers  

---

What is Undo Management Advisor in Oracle?

0 Answers   MCN Solutions,

---

in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit

3 Answers   Polaris,

---