Answer / Avdhesh P.singh

RAISE_APPLICATION_ERROR is a PL/SQL built-in function that allows developers to generate custom errors with a user-defined error number, message, and arguments. This can be used to manage exceptions in a more structured manner and provide better error handling for end-users.

what is the different between now() and current_date()? : Sql dba

1 Answers  

---

Can pl sql procedure have a return statement?

1 Answers  

---

What is nosql db?

1 Answers  

---

What is bulk collections?

2 Answers  

---

Define sql delete statement.

1 Answers  

---

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

4 Answers   Tech Mahindra,

---

package specification-3 procedures package body-2 procedures will is execute

2 Answers   PWC,

---

Does pdo prevent sql injection?

1 Answers  

---

What is column?

1 Answers  

---

Does mysql_real_escape_string prevent sql injection?

1 Answers  

---

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

---

What are aggregate functions in sql?

1 Answers  

---