What is difference between SUBSTR and INSTR?
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 will you identify oracle database software release?
how the indexes are stored in the Oracle Database?
What is a trigger and what are its types?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What is a sub query? Describe its types?
How to find the duplicate rows count from employees table in oracle?
Can you create a synonym without having a table?
How to concatenate two text values in oracle?
What happens if you lost a data file?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How can you merge two tables in oracle?
how do u setup a replication site?