Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / atchala ramanareddy
substr:
select substr('atchala ramanareddy',2,9) from dual;
it will return tchala ra.
instr:
select instr('atchala ramanareddy','a',1,2) from dual;
it will return 5.
| Is This Answer Correct ? | 19 Yes | 3 No |
Post New Answer View All Answers
How to execute a stored procedure?
What is range partitioning?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
how to rename an existing column in a table? : Sql dba
what is the difference between inner and outer join? Explain with example. : Sql dba
What is the source code of a program?
Who is the owner of mysql database?
Can a composite key be null?
What is an implicit commit?
What is coalesce in sql?
What is union?
Can I learn sql in a week?
How does a covering index work?
explain commit and rollback in mysql : sql dba
How can you know that statistics should be updated?
