Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between SUBSTR and INSTR?
- 1 Answers
- 3045 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 use subqueries with the exists operator in oracle?
How to get a create statement for an existing table?
How to delete a column in an existing table?
Difference between an implicit & an explicit cursor.?
How to execute a stored procedure in oracle?
What is literal?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
Explain an extent?
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.
select * from emp what happened internally when we write this query in the sql prompt?
How to execute a stored program unit?
What is oracle and what are its different editions?
Oracle General 
