Interested to Buy Any Domain ? << Click Here >> for more details...
Can u make a synonym for deptno=10 only from emp table.
- 1 Answers
- 2663 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 literal?
What is an oracle and why it is used?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Is the After report trigger fired if the report execution fails ?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How to define a cusotmer as a supplier in ORACLE R12
What is the data pump import utility?
What are the attributes of the cursor?
What is the data type of dual table?
What is a deadlock ? Explain .
How to establish administrator authentication to the server?
How do you tell what your machine name is and what is its IP address?
Oracle General 
