SQL LABS - Views, Sequence, Synonyms

 Views, Sequence, Synonyms

views and sequence

1. create a view whose deptno=10 and 20;

2. create a view without a table then create a table and compile the view;

3. create the read-only view for the emp table deptno=30;

4)create a table from Scott.emp3 from emp add a column sno,

if data is inserted into the table the sno column should be increment by 1;

synonyms

create user u1 and u2

-> Create a table emp and dept in u1.

-> From u1 create synonyms for table emp and dept tables

->grant only select privilleges to u2 from u1 on emp table.

->grant update and select privileges to u2 from u1 on the dept table.

-> From u2, call the table by using the synonym name