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 differences between char and nchar? : Sql dba
Can we use commit inside a trigger?
What is pl sql in dbms?
What are sql functions? Describe in brief different types of sql functions?
Is not null in sql?
How does one load ebcdic data? : aql loader
How do I order by ascending in sql?
what is the difference between a web-garden and a web-farm? : Sql dba
How can we solve sql error: ora-00904: invalid identifier?
What are variables in pl sql?
What are predefined functions in sql?
Explain what is a column in a table?
What is t-sql? : Transact sql
When sql appeared?
What is pragma in pl sql?
