Interested to Buy Any Domain ? << Click Here >> for more details...
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
| Is This Answer Correct ? | 65 Yes | 6 No |
Post New Answer View All Answers
What are the string functions in sql?
How to Declare Fixed Length String Value In PL SQL
What is the difference between subquery and correlated query?
What is left join example?
What is the difference between nvl function, ifnull function, and isnull function?
What is bitemporal narrowing?
What is varchar data type in sql?
what is 'mysqladmin' in mysql? : Sql dba
Mention what plvcmt and plvrb does in pl/sql?
explain advantages of myisam over innodb? : Sql dba
What is plpgsql language?
Why use subqueries instead of joins?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
Is it possible to update views?
Describe sql comments?
