view_seq_syn - Lab Exercise
view_seq_syn - Lab Exercise
| Practice questions |
|---|
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 readonly view for the emp table deptno=30.
|
4. create a table from scott. emp3 from emp add a column sno,
if data is insert into table the sno column should be increment by 1.
|