Answer / sumanamara

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

How to call shell script from pl sql procedure?

0 Answers  

---

How do I truncate a word?

0 Answers  

---

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

8 Answers   CGCI,

---

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

---

Which data type doesn't allow null data type?

6 Answers   TCS,

---

What is parallel hint?

0 Answers  

---

What are the types of triggers ?

26 Answers   Aspire, BirlaSoft, TCS,

---

Can a view be mutating? If yes, then how?

0 Answers  

---

What is a bitmap index?

4 Answers   Choice Solutions, Infosys,

---

Why do we use procedures in sql?

0 Answers  

---

What is the usage of when clause in trigger?

0 Answers  

---

Is sql harder than python?

0 Answers  

---