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
Can select statements be used on views in oracle?
How data locks are respected in oracle?
How many types of auditing in Oracle?
How to delete a column in an existing table?
What types of joins are used in writing subqueries?
what is port in oracle? how is it related to database application.
How many types of tables supported by oracle?
How to start a specific oracle instance?
How to work with data objects interactively?
How to rename an existing table?
What is oracle and what are its different editions?
can u plz provide me oca sql dumps please i need them
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How to insert a record into a table?
Who developed oracle & when?
