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 does COMMIT do ?

4 Answers  

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

0 Answers   Oracle,

---

Difference between the “verify” and “feedback” command?

0 Answers  

---

What happens if recursive calls get out of control?

0 Answers  

---

how to retrieve 1st and last row of table without using group functions??

6 Answers  

---

What is the difference between translate and replace?

0 Answers  

---

 What are the oracle DML commands possible through an update strategy?

0 Answers   Informatica,

---

which language is used to develop the oracle........?

4 Answers   Infosys,

---

How would you change old and new values in an insert, delete and update triggers?

0 Answers  

---

find out the second highest salary?

55 Answers   Cognizant, Nucsoft, Oracle, TCS, Wondersoft,

---

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

1 Answers   MasterCard,

---

When can Hash Cluster used ?

1 Answers  

---