Answer / Ashish Singh

In PL/SQL, there are Scalar Variables, Array Variables, Record Variables, and Table Variables.

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,

---

What are the features of pl sql?

1 Answers  

---

Store procedure will return a value?

4 Answers   eMids,

---

How many parts of a pl sql block are optional?

1 Answers  

---

What is difference between cursor and ref cursor?

1 Answers  

---

How do you explain an index?

1 Answers  

---

which types of join is used in sql widely? : Sql dba

1 Answers  

---

Can you have multiple SPs with the same name on a database?

2 Answers   CGI, Quest,

---

what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,

---

What is bind variable in pl sql?

1 Answers  

---

What is pl sql variable?

1 Answers  

---

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  

---