select * from dept_1;<\/p>\n\n\n\n
create view v1 as select id,name from dept_1;<\/p>\n\n\n\n
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’);<\/p>\n\n\n\n
select * from v1;<\/p>\n\n\n\n
CREATE SEQUENCE sequence_name
START WITH 1
INCREMENT BY 1
MINVALUE 1
MAXVALUE 90
NOCYCLE
CACHE 20;<\/p>\n\n\n\n
insert into dept_1 values(sequence_name.NEXTVAL,’sheetal’);<\/p>\n\n\n\n
CREATE SYNONYM e1 FOR hr.test;<\/p>\n\n\n\n
select * from e1<\/p>\n\n\n\n
grant<\/strong><\/p>\n\n\n\n GRANT CREATE ANY VIEW TO c##scott; <\/p>\n","protected":false},"excerpt":{"rendered":" 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_nameSTART WITH 1INCREMENT BY 1MINVALUE 1MAXVALUE 90NOCYCLECACHE 20; insert into dept_1 values(sequence_name.NEXTVAL,’sheetal’); CREATE SYNONYM e1 FOR hr.test; select * from […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30],"tags":[],"class_list":["post-607","post","type-post","status-publish","format-standard","hentry","category-oracle"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t
GRANT CREATE ANY SYNONYM TO c##scott;<\/p>\n\n\n\n