RDBMS
EMPLOYEE CODE GENERATION USING SEQUENCE AND TRIGGERS SQL QUERIES : SQL> create table emp(snonumber,empcodevarchar(10),empnamevarchar(12)); Table created. SQL> create sequence seq1; Sequence created. SQL> create or replace trigger trig1 before insert on emp for each row when(new.empcode is null) begin select 'emp0'|| to_char(seq1.nextval) into :new.empcode from dual; end; / Trigger created. SQL> insert into emp(sno,empname)values(1,'ram'); 1 row created. SQL> insert into emp(sno,empname)values(2,'janu'); 1 row created. SQL> insert into emp(sno,empname)values(3,'stocks'); 1 row created. SQL> insert into emp(sno,empname)values(4,'butler'); 1 row created. SQL> select * from emp; SNO EMPCODE EMPNAME ---------- ---------- ------------ 1 emp01 ram 2 emp02 janu 3 emp03 stocks 4 emp04 butlerbutler Formatting tabl e Create table ttitle left 'pageno:' format99 sql.pno center 'product_report'; column dea...