Answer / 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

Answer / 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

Answer / atchala ramanareddy

substr:
select substr('atchala ramanareddy',2,9) from dual;
it will return tchala ra.
instr:
select instr('atchala ramanareddy','a',1,2) from dual;
it will return 5.

What is the difference between SQL table and the PLSQL table?

3 Answers   Mastek,

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  

---

How much ram can sql express use?

0 Answers  

---

Explain the uses of a database trigger?

0 Answers  

---

What is union and union all keyword in sql and what are their differences?

0 Answers  

---

what is the sql query to display current date? : Sql dba

1 Answers  

---

What does “select count(*) from tab” result?

15 Answers   IBM, Student, Wipro,

---

what is the difference between binary_integer and pls_integer

2 Answers   TCS,

---

How do I write a sql query in pgadmin 4?

0 Answers  

---

What is %s in sql?

0 Answers  

---

Is truncate ddl or dml?

0 Answers  

---

Explain how can you save or place your msg in a table?

0 Answers  

---