How can i insert data inro a table with 3 columns using FORALL?

2 Answers   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  

---

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

---

Mention what are the benefits of pl/sql packages?

0 Answers  

---

What's the difference between a primary key and a clustered index?

0 Answers  

---

check whether all the emp numbers are indeed unique.

6 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  

---

What are transaction and its controls?

0 Answers  

---

What is the advantage of index in sql?

0 Answers  

---

how to insert the records in particular position

1 Answers  

---

Explain what is table in a database?

0 Answers  

---