Answer / Sandeep Kumar Sharma

A view is a virtual table based on the result-set of an SQL statement, while a stored procedure is a prepared SQL code that can be executed multiple times. A view cannot accept input parameters or return output parameters, whereas a stored procedure can. Also, views refresh each time they are queried, while stored procedures are compiled and stored in the database.

How can you load microsoft excel data into oracle? : aql loader

1 Answers  

---

1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,

---

Types of joins ?

3 Answers   Digital GlobalSoft, HeadStrong,

---

What is %type in sql?

1 Answers  

---

How do you update sql?

1 Answers  

---

what are the features and advantages of object-oriented programming? : Sql dba

1 Answers  

---

Why functions are used in sql?

1 Answers  

---

Please let me know if UNION ALL and Natural Join does the same operation and are same...

7 Answers   iGate,

---

How do you select unique values in sql?

1 Answers  

---

How do I quit sql?

1 Answers  

---

What are basic techniques of indexing?

1 Answers  

---

Mention what pl/sql package consists of?

1 Answers  

---