Interested to Buy Any Domain ? << Click Here >> for more details...
Can u make a synonym for deptno=10 only from emp table.
- 1 Answers
- 2601 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 |
How many types of database triggers exist?
After using set unused can we enable the column again to use? Please give me some answers....
what are the advantages of running a database in NO archive log mode?
How to retrieve the count of updated rows?
Display the number value in Words?
What is a database table in oracle?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
What is oracle data type?
How to add a new column to an existing table in oracle?
Whether any commands are used for months calculation? If so, what are they?
How can I combine multiple rows into a comma-delimited list in oracle?
What is the difference between normal and corelated subqueries?
Oracle General 
