Interested to Buy Any Domain ? << Click Here >> for more details...
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
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
Can I create users through internet explorer in oracle 10g?
How to check your oracle database 10g xe installation?
How to create a table index?
What is the exact use of Collections?
What are named parameters?
Can group functions be used in the order by clause in oracle?
What do you mean by redo log file mirroring?
List out the difference between commit, rollback, and savepoint?
How can windows applications connect to oracle servers?
what is the difference between substr and instr function in oracle?
How to install oracle odbc drivers?
Difference between open_form and call_form in oracle.
Explain the use of ignore option in imp command.
What is a system tablespace?
