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 |
State any two functions of oracle?
select statement does not retrieve any records. what exception is raised?
What is tns name?
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
what are steps for interface? where is exchange rate defined in which table?
What is recovery manager in Oracle?
Please explain joins in oracle?
What are the advantages of oracle 12c?
What is the difference between Outer join and Full outer join?
How can we find out the duplicate values in an oracle table?
What is the difference between 10g OEM and 11g OEM?
what is host string in sql plus? how does it related to database?