Can u make a synonym for deptno=10 only from emp table.
- 1 Answers
- 1956 Views
- TCS, I also Faced
- E-Mail Answers
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 |
What is the difference between substr & instr functions?
What is meant by raw datatype?
How to store only time; not date and time?
find out the second highest salary?
55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,
Write a simple Store procedure and pass parameter to it ?
How do I spool to a csv formatted file using sqlplus?
How to write a query with a full outer join in oracle?
hai, when to use char and varchar2....?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How to export several tables together?
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
Oracle General 
