Answer Posted / tulsi

SUBSTR is used to extract a set of characters from a string
by specificing the character starting position and end
position and length of characters to be fetched.
example substr('hello',2,3) will return 'ell'

INSTR is used to find the position of any particular
character in a word which returns numeric value.
instr('hello','e') - will return the position of 'e' as 2

What are reports usually used for?

966

---

what is meant by nl2br()? : Sql dba

973

---

Does a user_objects view have an entry for a trigger?

958

---

What is pivot table in sql?

1013

---

Explain what is a database?

1033

---

What is difference between table and view?

972

---

Is t sql a programming language?

1001

---

Why join is faster than subquery?

1039

---

Define union, minus, union all, intersect ?

949

---

Which table is left in left join?

951

---

what is collation? : Sql dba

1077

---

What are the different sql languages?

984

---

What are the topics in pl sql?

930

---

how to use in conditions? : Sql dba

957

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

985

---