Answer Posted / mahesh

select regexp_count('hello','l') from dual;

or

SELECT LENGTH('HELLO')-LENGTH(REPLACE('HELLO','L',NULL)) FROM DUAL;

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4101

---

Explain what is sql?

1182

---

What are the types of dbms?

1027

---

Why do you partition data?

1066

---

How to Declare Fixed Length String Value In PL SQL

1208

---

What does select * from mean in sql?

3337

---

how to calculate expressions with sql statements? : Sql dba

1096

---

Explian rowid, rownum?

1086

---

What is aggregate function in sql?

1081

---

What does desc stand for?

1125

---

how to enter numeric values as hex numbers? : Sql dba

1104

---

What is data profiling in sql?

1139

---

What is sql query optimization?

1195

---

What are triggers and its types?

1121

---

Is like operator in sql case sensitive?

1077

---