Interested to Buy Any Domain ? << Click Here >> for more details...
Can u make a synonym for deptno=10 only from emp table.
- 1 Answers
- 2598 Views
- TCS, I also Faced
- E-Mail Answers
Can u make a synonym for deptno=10 only from emp table...
Answer / 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 |
More Oracle General Interview Questions
How many memory layers are in the shared pool?
What are the uses of Rollback Segment ?
What is where clause in oracle?
What is an oracle database?
Explain the blob datatype?
How to assign data of the deleted row to variables?
Explain the difference between sql and oracle?
How to increment dates by 1 in oracle?
what is grid in Oracle 10g...
What is sharded cluster?
What is Parallel Server ?
What are the various constraints used in oracle?
Oracle General 
