acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers   Polaris,

---

What is sequence?

0 Answers  

---

What is a cognitive schema?

0 Answers  

---

How to define an oracle cursor variable?

0 Answers  

---

How to Remove the 3rd highest salary person record from table?

9 Answers   HCL, IBM,

---

What are the uses of linked server and explain it in detail?

0 Answers  

---

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

2 Answers   Wipro,

---

which sql command we can use to get a print out from oracle?

2 Answers   iFlex, INDUS,

---

Can we create index on views?

19 Answers   CTS, Syntel, TCS,

---

How to handle a single quote in oracle sql?

0 Answers  

---

Explain a segment?

0 Answers  

---

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

0 Answers  

---