SUBSTR et INSTR

SELECT substr('CCNB Bathurst',3,2) FROM dual

• Bat

• NB

• CNB

• st

SELECT substr('Programmation',1,4) FROM dual;

• rogr

• g

• Prog

• tion

SELECT substr('12345678', 5) FROM dual;

• 5678

• 678

• 12345

• 5

SELECT instr('12345678', '1') FROM dual;

• 8

• 0

• 2

• 1

SELECT instr('Joel Boudreau', 'e',5) FROM dual;

• 11

• 3

• 2

• 10

SELECT instr('Joel Boudreau', 'e',1,2) FROM dual;

• 3

• 11

• 2

• 10