Interested to Buy Any Domain ? << Click Here >> for more details...
Can u make a synonym for deptno=10 only from emp table.
- 1 Answers
- 2664 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
Is there an oracle sql query that aggregates multiple rows into one row?
what is meant by magic query
How many types of table in Oracle?
How remove data files before opening a database?
When do we use group by clause in a sql query?
How to join two tables in a single query using oracle?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is meant by an index?
How to experiment a data lock in oracle?
What are the ways tablespaces can be managed and how do they differ?
What is blob datatype?
What is a dynamic performance view in oracle?
What is rowid and rownum in oracle?
ABOUT IDENTITY?
How to create an initialization parameter file?
