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
Query to retrieve record for a many to many relationship ?
Can you assign multiple query result rows to a variable?
What do you mean by a tablespace?
How to open and close an explicit cursor in oracle?
Please explain joins in oracle?
How to increment dates by 1 in oracle?
How to best split csv strings in oracle 9i?
How do I know if oracle is installed on windows?
11. Display the client number and name and the client number and name of the person who referred that client.
What are a query and state the different types of queries and their uses?
How do you bind variables in oracle?
What is the use of aggregate functions in oracle?
What is ceil and floor in oracle?
How to install oracle database 10g xe?
Explain the use of parfile option in exp command.
