Answer / Apurav Garg

Functions in PL/SQL are subprograms that return a value to the calling program, while procedures do not. Procedures can perform operations but they don't return any value. A Package is a collection of related functions, procedures, and variables. It provides modularity by allowing multiple related subprograms and data to be combined into a single object.

What is online transaction processing (oltp)?

1 Answers  

---

using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

4 Answers   Fidelity,

---

Where is pl sql used?

1 Answers  

---

Explain unique key in sql.

1 Answers  

---

What is procedure function?

1 Answers  

---

what are myisam tables? : Sql dba

1 Answers  

---

What is sql data?

1 Answers  

---

Is pl sql and postgresql same?

1 Answers  

---

What is the difference between a subquery and a join?

1 Answers  

---

What is sorting in sql?

1 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

What is a boolean in sql?

1 Answers  

---