Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between SUBSTR and INSTR?
- 1 Answers
- 3129 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 delete a column in an existing table in oracle?
How many file formats are supported to export data?
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
What is the exact use of Collections?
why pl sql doesn't support retrieving multiple records
Can a View based on another View ?
How to use subqueries in the from clause in oracle?
What is the difference between RBBMS & DBMS?
Tell me New Feature of Oracle 10g?
How do you find current date and time in oracle?
Can you assign multiple query result rows to a variable?
How to delete all rows a table in oracle?
Oracle General 
