Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between SUBSTR and INSTR?
- 1 Answers
- 3049 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 |
what is the scenario where you take the database to NoArchivelog mode?
Explain the function of optimizer in oracle?
Explain do view contain data?
List out the types of joins.
What happens if you lost a data file?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
What is the relation of a user account and a schema?
What is the data type of dual table?
find the second highest salary of the emp table
What is the difference between RBBMS & DBMS?
Explain an index segment?
What are the different types of trigger and explain its various uses and functions?
Oracle General 
