Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between SUBSTR and INSTR?
- 1 Answers
- 2916 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How to divide query output into groups in oracle?
how to insert data into partitioned table partition done by Range partition
How do you bind variables in oracle?
Explain joins in oracle?
What is the diff between Oracle and SQL Server
material view and view disadvantages?
how to create a new database in oracle?
What is oracle thin client?
What is the difference between normal and corelated subqueries?
what is the use of system.effective.date variable in oracle?
How can you merge two tables in oracle?
How to define an oracle sub procedure?
Oracle General 
