Deben estar encendidos los Servicios de
OracleService(instancia)
OracleListener
---------------------------------------------------------------
C:\Documents and Settings\Administrador>sqlplus
Enter user-name: sys as sysdba --en web va solo "sys"
Enter password: ora
Connected to: Oracle Database 10g Enterprise Edition
SQL>
---------------------------------------------------------------
sqlplus /nolog
SQL> conn / as sysdba
Connected.
SQL>
---------------------------------------------------------------
SQL> create user Rene identified by rex;
User created.
SQL> grant connect, resource to Rene;
Grant succeeded.
SQL> grant dba to Rene;
Grant succeeded.
SQL>
--------------
CREATE SEQUENCE PersonasID
START WITH 1
INCREMENT BY 1;
CREATE OR REPLACE TRIGGER trINSsecPersonas
BEFORE INSERT
ON Personas
REFERENCING NEW AS NEW
FOR EACH ROW
BEGIN
SELECT PersonasID.nextval INTO :NEW.ID FROM dual;
END;
INSERT INTO
Personas
VALUES
(
PersonasID.nextval
,'Rene'
,'Nuñez'
)
INSERT INTO
Personas
VALUES
(
null
,'juan'
,'mellado'
)
