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 all types of user defined functions?
What are the most important characteristics of pl/sql?
What are the two characteristics of a primary key?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What are the possible values for the boolean data field?
How do you write an index?
What is java sql driver?
Does asenumerable execute the query?
what is the difference between char and varchar data types? : Sql dba
What is the difference between in and between in sql?
Which is faster joins or subqueries?
What is the difference between partition and index?
What is rtm stands for?
How many types of relationship are there?
How to return an array from java to pl/sql?
