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
Write the alter statement to enable all the triggers on the t.students table.
What is having clause in sql?
What is embedded sql with example?
What is information schema in sql?
Can dml statements be used in pl/sql?
How can you tell the difference between an index and a view?
What is meant by cursor in sql?
What plvcmt and plvrb does in pl/sql?
Can cursors be part of a trigger body?
What is rank dense_rank and partition in sql?
What is difference between stored procedure and trigger?
How many types of tables are there?
Why do we use joins in sql?
What are pl/sql cursor exceptions?
How much does sql cost?
