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  

---

Explain what is a field in a database and record in a database?

0 Answers  

---

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

6 Answers   IBM,

---

Show the two pl/sql cursor exceptions.

0 Answers  

---

What is an escape character in sql?

0 Answers  

---

---

Is sql sequential or random?

0 Answers  

---

Tell me what a package consists of.

3 Answers  

---

How do I access sql anywhere database?

0 Answers  

---

What is inner join in sql?

0 Answers  

---

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

---

How to avoid using cursors?

0 Answers  

---

Why we use joins in sql?

0 Answers  

---