Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions
Thanks for the question, Prakash.
Asked: November 29, 2018 - 8:09 pm UTC
Last updated: November 30, 2018 - 9:03 am UTC
Version: 11g
Viewed 1000+ times
record MY_REC is ( fname varchar2(20), lname varchar2(20) )
declare record MY_REC is ( fname varchar2(20), lname varchar2(20) ) l_rec my_rec; begin l_rec.fname := substr(file_line,1,6); -- CONNOR l_rec.lname := substr(file_line,7); -- MCDONALD (rest of line end;
Check out more PL/SQL tutorials on our LiveSQL tool.
PL/SQL reference manual from the Oracle documentation library