Answer Posted / parthasarathi
substr is used to get part of a string, instr is used to get particular string's position.
syntax of substr:-
substr(string,from which character we want,[how many characters we want])
syntax of instr:-
instr(string,'character')
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is meant by magic query
How to lock and unlock a user account in oracle?
How can windows applications connect to oracle servers?
How oracle handles dead locks?
What is background process in Oracle?
What are the different editions of oracle?
How to delete all rows a table in oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
How do I limit the number of rows returned by an oracle query after ordering?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
How to manage transaction isolation level?
Explain drop constraint oracle?
How to write date and time literals in oracle?
What is the difference between hot backup and cold backup in oracle?
What is an oracle tablespace?
