Education platform for interview prep, online tests, tutorials, and live practice

Build skills with focused learning paths, mock tests, and interview-ready content.

WithoutBook brings subject-wise interview questions, online practice tests, tutorials, and comparison guides into one responsive learning workspace.

Search the library

Prepare Interview

SQL Interview Questions and Answers

← Previous
Next →

Question: Difference between SUBSTR and INSTR?

Answer: INSTR (String1, String2 (n, (m)),
INSTR returns the position of the m-th occurrence of the string 2 in string1. The search begins from nth position of string1.
SUBSTR (String1 n, m)
SUBSTR returns a character string of size m in string1, starting from n-th position of string1.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? Yes No

Most helpful rated by users:

What is SQL?
SQL*Plus
Date Functions
NVL
Character Functions