Can we debug stored procedure?

0 Answers  

---

what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )

2 Answers   Tech Mahindra,

---

What is normalisation in sql?

0 Answers  

---

Cite the differences between execution of triggers and stored procedures?

0 Answers  

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

---

What does partition by mean in sql?

0 Answers  

---

How to find the count of letter "L" in HELLO

7 Answers   HP,

---

What is the usage of distinct keyword?

0 Answers  

---

how to check the 3rd max salary from an employee table?

23 Answers   IBM,

---

if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,

---

What is a subquery in sql?

0 Answers  

---

Do stored procedures prevent sql injection?

0 Answers  

---