Interested to Buy Any Domain ? << Click Here >> for more details...
Can u make a synonym for deptno=10 only from emp table.
- 1 Answers
- 2694 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
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What is query image?
How to manage transaction isolation level?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
How to rollback the current transaction in oracle?
Please explain joins in oracle?
What is meant by a deadlock situation?
Explain the difference between sap and oracle?
How to handle a single quote in oracle sql?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
Explain the use of compress option in exp command.
What is memory advisor in Oracle?
Will you be able to store pictures in the database?explain.
What is redo log?
