Can u make a synonym for deptno=10 only from emp table.
- 1 Answers
- 2259 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 oracle update statement with inner join ?
Explain the use of full option in exp command.
State some uses of redo log files?
Explain the difference between sql and oracle?
Is the After report trigger fired if the report execution fails ?
How to connect to oracle using service name instead of sid?
what are stored procedures?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
What is the purpose of a cluster?
Why do we use bulk collect in oracle?
Youre getting high busy buffer waits - how can you find whats causing it?
How many categories of data types?
Oracle General 
