Hi

One of the horrible thing is rewrite column in RECORD, VARRAY, for example:

declare
my_rec emp%ROWTYPE;

begin
select * into my_rec from emp;

dbms_output.put_line( my_rec. <- PLSQL dev should assist you selecting column name in RECORD

This functionality is normal in JAVA IDE, so we need them in PL/SQL