WHT ARE THE AGGREATE FUNCTIONS?

7 Answers   GEITC, TCS,

---

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3

3 Answers  

---

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,

---

How to define a procedure inside another procedure?

0 Answers  

---

What is the use of file param in imp command?

0 Answers  

---

---

Difference between join and a subquery?

8 Answers   Base Automation, NMDC,

---

What is a Sequence ?

3 Answers  

---

How to pass a cursor variable to a procedure?

0 Answers  

---

what is difference between cartesian join & cross join even they give same result?

4 Answers   Bank Of America,

---

am completed mca2011 how get certification in oracle

1 Answers  

---

how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?

1 Answers   Infosys,

---

What is recycle bin in Oracle?

0 Answers   MCN Solutions,

---