What is difference between SUBSTR and INSTR?
- 1 Answers
- 2494 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 |
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
Explain how you would restore a database using RMAN to Point in Time?
How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
What is oracle sid?
How to use in conditions in oracle?
What is the usage of synonyms?
Difference between an implicit & an explicit cursor.?
How to test null values?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
How to count duplicated values in a column in oracle?
How do we get field detail of a table?
Give syntax for SQL and ORACLE joins.
Oracle General 
