plugin notepad format sql

 https://www.sqlinform.com/download-free-notepad-plugin/

cursor PLSQL

declare
  cursor public cur is
    select col1, col2
    from tabla;
begin
  for v_reg in cur loop
    dbms_output.put_line ('Col1: '|| v_reg.col1 ||'  Col2: '|| v_reg.col2);
  end loop;
end;

https://es.wikibooks.org/wiki/Oracle/PL/SQL/Cursores

excepciones PLSQL

https://www.tutorialspoint.com/plsql/plsql_exceptions.htm

show errors trigger

http://www.java2s.com/Code/Oracle/Trigger/Showerrorsforatrigger.htm

Delete Oracle

2 3 4 5

DELETE FROM     table_name WHERE     condition;