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
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What are the disadvantages of not performing database normalization?
What are different categories of sql commands?
Explain the savepoint statement.
what is a composite primary key ? : Sql dba
What is a function in oracle pl sql?
What does where 1 1 mean in sql?
Mention what are different methods to trace the pl/sql code?
What is sap sql?
How are functions and procedures called in PL/SQL?
How do you rank data in sql?
What is a record in a database?
What is pl sql block structure?
What are the benefits of stored procedures?
How do I find duplicates in two columns?
