Interested to Buy Any Domain ? << Click Here >> for more details...
Can u make a synonym for deptno=10 only from emp table.
- 1 Answers
- 2768 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
how to join query for one source type is oracle another source type is sql server ?
How to get execution path reports on query statements?
State and explain about oracle instance?
What are the attributes of cursor?
How to empty your oracle recycle bin?
How to import one table back from a dump file?
What are temporal data types in oracle?
What is a nested table?
What are the predefined tablespaces in a database?
How to open a cursor variable?
How to login to the server without an instance?
what is the difference between substr and instr function in oracle?
What is transaction control statement and how many types of transaction control statement in Oracle?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
How to get a list of all background sessions in the database?
