Answer / sumanamara

2)
select length('HELLO')- length(replace('HELLO','L',''))
FROM
dual;

how to use regular expression in pattern match conditions? : Sql dba

0 Answers  

---

What is sql and explain its components?

1 Answers  

---

How to handle bulk data?

1 Answers  

---

Can triggers stop a dml statement from executing on a table?

1 Answers  

---

What is multiple columns?

1 Answers  

---

Why is stored procedure faster than query?

1 Answers  

---

Is progress software supports to ( pl/sql )?

1 Answers  

---

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d

4 Answers  

---

What is the difference between an inner join and an outer join?

1 Answers  

---

Is sql better than access?

1 Answers  

---

What are the most important characteristics of pl/sql?

1 Answers  

---

How long it takes to learn pl sql?

1 Answers  

---