Answer / sunil

if use dbms_output.put_line in every retriving value

What is %rowtype in pl sql?

0 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  

---

What is attribute indicator in pl sql?

0 Answers  

---

What is a merge query?

1 Answers  

---

what are the advantages of package?

7 Answers   iFlex,

---

---

Two Methods of retrieving SQL?

7 Answers   Atiric Software, Microsoft, Oracle, TCS, Wipro,

---

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

8 Answers   Satyam,

---

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 Answers  

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

0 Answers  

---

Mention what is the use of function "module procedure" in pl/sql?

0 Answers  

---

what is transaction? : Sql dba

0 Answers  

---

What is implicit cursor in pl sql?

0 Answers  

---