What is difference between SUBSTR and INSTR?
- 1 Answers
- 2332 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 |
Explain an index?
What is an Oracle sequence?
What are the database administrators utilities available?
How to fetch the row which has the max value for a column?
What is oracle rownum?
What are virtual columns?
t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.
What is a procedure in oracle?
Which are the five query types available in oracle?
How to check your oracle database 10g xe installation?
What WHERE CURRENT OF clause does in a cursor?
How data locks are respected in oracle?
Oracle General 
