Answer / revathy

create or replace function f1(
iip in varchar2,iip2 in char)
Return number
is
tot number;
Begin
select (length(iip)-length(replace(iip,iip2))) into tot
from dual;
return tot;
end;

What is group by in sql?

0 Answers  

---

What is window clause?

1 Answers   TCS,

---

How did you export data from database to excel file.

1 Answers   TCS,

---

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,

---

what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,

---

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,

---

How to download oracle sql developer?

0 Answers  

---

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,

---

Explain the components of sql?

0 Answers  

---

What are user defined stored procedures ?

3 Answers   BirlaSoft,

---

How do you handle exceptions. Give the syntax for it?

1 Answers   BCL, Microsoft,

---

write the Sql query for creating database backup?

7 Answers   TCS,

---