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;

How to create a testing table in oracle?

0 Answers  

---

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).

1 Answers  

---

Oracle

0 Answers   ABC, Genpact, HUI, Oracle,

---

What is oracle database 10g express edition?

0 Answers  

---

Explain the use of grant option in imp command.

0 Answers  

---

---

How to create a new user account in oracle?

0 Answers  

---

What is a table index in oracle?

0 Answers  

---

What is an Index ? How it is implemented in Oracle Database ?

4 Answers  

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 Answers  

---

What is open database communication (odbc) in oracle?

0 Answers  

---

What is a cluster?

2 Answers  

---

How to rename a column in an existing table?

0 Answers  

---