Answer / nishi

A view is a virtual table. Every view has a query attached to it. (The query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)

How to shutdown your 10g xe server from command line?

0 Answers  

---

how to find find & delete duplicate rows from two different tables?

3 Answers   Accenture, TCS,

---

what is the difference between first normal form & second normal form?

11 Answers   IBM, Oracle,

---

Difference between varchar and varchar2 data types?

0 Answers  

---

how to retrieve daily sal from emp table in oracle 10g

2 Answers   Infosys,

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

0 Answers  

---

What is SYSTEM tablespace and When is it Created?

2 Answers  

---

Who i will insert 1 lacks record in a Database table

4 Answers   TCS,

---

how to use sequence and what use of sequence cache

1 Answers  

---

what is trigger?

6 Answers   Oracle,

---

Explain the difference between a procedure and a function?

0 Answers  

---

18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>

2 Answers   Wipro,

---