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;

Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)

4 Answers   Thermotech,

---

What is Parallel Server ?

3 Answers  

---

What is the difference between hot backup and cold backup in oracle?

0 Answers  

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

0 Answers  

---

find out the second highest salary?

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

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

---

what are the advantages of running a database in NO archive log mode?

1 Answers  

---

What is oracle instant client?

0 Answers  

---

How to assign query results to variables?

0 Answers  

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

0 Answers  

---

what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.

9 Answers   BPO, Excel, Wipro,

---

What do you understand by database schema and what does it hold?

0 Answers  

---