sql chapter 3

select * from dept_1;

create view v1 as select id,name from dept_1;

create table dept_1(id int,name varchar2(50));
insert into dept_1 values(1,’mitak’);
insert into dept_1 values(12,’sss’);
insert into dept_1 values(10,’mitak’);
insert into dept_1 values(3,’mitak’);

select * from v1;

CREATE SEQUENCE sequence_name
START WITH 1
INCREMENT BY 1
MINVALUE 1
MAXVALUE 90
NOCYCLE
CACHE 20;

insert into dept_1 values(sequence_name.NEXTVAL,’sheetal’);

CREATE SYNONYM e1 FOR hr.test;

select * from e1

grant

GRANT CREATE ANY VIEW TO c##scott;
GRANT CREATE ANY SYNONYM TO c##scott;