User-Defined Records Types in Oracle

#SQL #PLSQL #Oracle #ORACLEAPPS #OracelFusion #TechTalkswithNaresh #Naresh #R12 #EBSConsultant Join Our Telegram Group: https://t.me/techtalkswithnaresh FOLLOW US : ============ YouTube : https://youtube.com/c/TechTalkwithNaresh For More details Contact Us: Email: [email protected] -------------------------------------------------------------------------------------------------------------------------------------------------------- This video will help them who are in the learning phase of PLSQL/SQL. If you have any doubt's regarding this video write in comment section. If you want any other video related to SQL please comment in comment section. Please Like, Share and Subscribe the video. Example: DECLARE type emp_rec IS record ( e_ename emp.ename%type, e_sal emp.sal%type, e_deptno emp.deptno%type, e_job emp.job%type); new_rec emp_rec; BEGIN SELECT ename, sal, deptno, job INTO new_rec.e_ename, new_rec.e_sal, new_rec.e_deptno, new_rec.e_job FROM emp WHERE empno=7788; dbms_output.put_line('data'||new_rec.e_ename); END;