GRANT ORACLE

https://chartio.com/resources/tutorials/how-to-create-a-user-and-grant-permissions-in-oracle/

CREATE USER silvia IDENTIFIED BY silviapass;

GRANT CONNECT TO silvia;


GRANT CREATE SESSION TO silvia;
GRANT UNLIMITED TABLESPACE TO silvia;

restart path

https://search4fan.github.io/post/win10_new_system_variable_without_restart.html

CREACION DE TABLA

CREATE TABLE TIPO_EMPLEADO
(
  ID NUMBER NOT NULL
, DESCRIPCION VARCHAR2(20)
, CONSTRAINT TABLE1_PK PRIMARY KEY
  (
    ID
  )
  ENABLE
);

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