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;

What is a read only transaction in oracle?

0 Answers  

---

List out the types of joins.

0 Answers  

---

Explain view?

0 Answers  

---

What is the fastest query method to fetch data from the table?

0 Answers  

---

What privilege is needed for a user to query tables in another schema?

0 Answers  

---

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,

---

how to retrieve data from different tables ,place this data in different excel worksheets.

1 Answers   Gap Inc,

---

What is the maximum limit on the number of columns in a table?

0 Answers  

---

What is the function of Optimizer ?

1 Answers  

---

What are the values that can be specified for OPTIMIZER MODE Parameter ?

1 Answers  

---

How to open a cursor variable?

0 Answers  

---

How would you extract DDL of a table without using a GUI tool?

1 Answers  

---