What are the benefits of stored procedures?

0 Answers  

---

What does an inner join do?

0 Answers  

---

What are the attributes of SQL*PLUS ?

2 Answers   Dream Careers, Oracle,

---

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  

---

How many parts of a pl sql block are optional?

0 Answers  

---

---

How do I filter in sql profiler?

0 Answers  

---

Can we use pl sql in sql server?

0 Answers  

---

how to decrement dates by 1 in mysql? : Sql dba

0 Answers  

---

What is a data manipulation language?

0 Answers  

---

Is nosql relational?

0 Answers  

---

How many functions are there in sql?

0 Answers  

---

what is the sql query to display current date? : Sql dba

1 Answers  

---