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 the difference between translate and replace in oracle?

0 Answers  

---

What are the different approaches used by Optimizer in choosing an execution plan ?

2 Answers  

---

i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?

5 Answers   Oracle,

---

How to open a cursor variable?

0 Answers  

---

Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks

2 Answers  

---

25. Display the client number and the value of the highest value order placed by that client.

2 Answers   Wipro,

---

We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?

3 Answers  

---

Why we choose emp number as primarykey?

4 Answers  

---

What are triggers?Where are they used?

3 Answers  

---

How to see free space of each tablespace?

0 Answers  

---

What is flashback Query ? And Use ?

4 Answers   Thermotech,

---

if you update view? where we store the data?

5 Answers   Cap Gemini,

---