Answer Posted / shrikant

Hi,
Yes Tulsi is right.
Execute the below queries & you will see the diff clearly -

SELECT instr('hello','e') FROM dual
SELECT substr('hello',2,3) FROM dual

Is like operator in sql case sensitive?

1021

---

How to run sql functions in pl/sql?

1052

---

Is inner join same as self join?

1111

---

What are different types of triggers?

1107

---

When is the explicit cursor used ?

1031

---

what is myisam? : Sql dba

1077

---

how to include comments in sql statements? : Sql dba

953

---

what are date and time data types? : Sql dba

981

---

What is cte sql?

988

---

How does left join work in sql?

999

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

1020

---

what is data manipulation language? : Sql dba

1012

---

what is a stored procedure? : Sql dba

1127

---

What is the cause of mutating table error and how can we solve it?

1047

---

How to execute a stored procedure?

1085

---