How to get the 3rd column(i.e all the data along with the column name)in a table?

2 Answers   Logica CMG,

---

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 is composite data type in pl sql?

0 Answers  

---

What are procedures used for?

0 Answers  

---

write a query to delete similar records in same table

13 Answers   TCS,

---

---

Does truncate remove indexes?

0 Answers  

---

How is a PL/SQL code compiled?

0 Answers  

---

What is %type in sql?

0 Answers  

---

What are the methods of filing?

0 Answers  

---

Is postgresql a server?

0 Answers  

---

Can you alter start with clause?

1 Answers   TCS,

---

How do you sort in sql?

0 Answers  

---