July 2026

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…

synonym

In Oracle, a synonym is an alias (alternate name) for a database object such as a table, view, sequence, procedure, function, package, or materialized view. Synonyms simplify object access and…