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 are the execution control statements?
Can we create trigger on materialized view in oracle?
What is the difference between a hot backup and a cold backup in oracle?
How would you go about verifying the network name that the local_listener is currently using?
Explain about the analyze command in oracle?
What is the difference between formal parameters and actual parameters?
How to initialize variables with default values?
How to check the oracle tns settings?
What is index in Oracle?
Difference between inner join vs where ?
what is the difference between functional dependecy and multilevel dependency?
What is recovery manager in Oracle?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How do I learn what codesets are available in oracle?
Explain index?
