What is difference between SUBSTR and INSTR?
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 do we get field details of a table?
How to assign data of the deleted row to variables?
which clause we are not used in where clause?
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
What does sharding mean?
How many data types are supported?
Is there any function in oracle similar like group_concat of mysql?
How to generate query output in html format?
Why do we need integrity constraints in a database?
Explain how are indexes update?
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
What is an index associated with a constraint?