-
-
Replace and Translate
How and in what way REPLACE is different from TRANSLATE?
-
-
DUAL table in Oracle
Can you explain What is DUAL table in Oracle?
-
What is difference between SUBSTR and INSTR?
SUBSTR returns a specified portion of a string eg SUBSTR('BCDEF',4) output BCDEINSTR provides character position in which a pattern is found in a string. eg INSTR('ABC-DC-F','-',2) output 7 (2nd occurence of '-')
-