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 it possible to insert comments into sql statements return in the data model editor ?

0 Answers   Oracle,

---

What are the attributes of the cursor?

0 Answers  

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

0 Answers   IBM,

---

What is SYSTEM tablespace and When is it Created?

2 Answers  

---

What is the difference between view and materialized view in Oracle?

0 Answers   MCN Solutions,

---

---

What is the difference between translate and replace?

0 Answers  

---

why can't we assign not null constraint as table level constraint

3 Answers   CTS, Wipro,

---

What are the different types of failures that occur in Oracle database?

0 Answers   HCL,

---

How to update values in a table in oracle?

0 Answers  

---

What is meant by joins? List out the types of joins.

0 Answers  

---

Maximum how many triggers can be updated in table ?

5 Answers   Accenture, Cap Gemini,

---

What are the arithmetic operations?

0 Answers  

---