Yes you can create a view for retrieving data of deptno=10 employees and yo

Can u make a synonym for deptno=10 only from emp table.

Question Posted / preethi raju

1 Answers
2600 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / preethi raju

Yes you can create a view for retrieving data of deptno=10 employees and you can create a synonym for it.

create or replace view v2 as select *from emp where deptno=10;

CREATE OR REPLACE SYNONYM sv2
FOR v2;

select *from sv2;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the various constraints used in oracle?

993

What do you mean by group by clause?

978

Explain what does a control file contain?

1034

What is the exact use of Collections?

2095

How do we get field detail of a table?

1022

How to manage transaction isolation level?

951

What is program global area (pga) in oracle?

960

What is the difference between a user and a schema in oracle?

984

What is Trigger in Oracle?

1076

Explain temporal data types in oracle

1044

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1060

What is a cursor variable?

1047

How many types of synonyms in Oracle?

1066

How do I know if oracle client is installed on windows?

956

What is blob datatype?

1056