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 is primary key secondary key alternate key candidate key?
what are the different index configurations a table can have? : Sql dba
What is cross join sql?
Define tables and fields in a database
What is the best sql course?
Are left and right joins the same?
What is the purpose of primary key?
How many sectors are in a partition?
how would you get the current date in mysql? : Sql dba
How to disable a trigger name update_salary?
Explain what is sql?
What is a unique constraint?
How do I run pl sql in sql developer?
how to get a list of indexes of an existing table? : Sql dba
what is the bond code in materialized view?
