Substr and Instr in OracleExtracting data from String
YOUR LINK HERE:
http://youtube.com/watch?v=8BE__GoRRxg
Using Substr and Instr We can extract any string from a Text/Column,. • This video Explain Instr and Substr in detail along with 10 practice Exercises that will help you gain expertise in the topic • You can use the below code to create the table and insert the data • create table susbtr_instr • ( • text varchar2(1000) • ); • insert into susbtr_instr values('[email protected]'); • insert into susbtr_instr values('[email protected]'); • insert into susbtr_instr values('[email protected]'); • #Instr #Substr #TechCoach
#############################
