Answer / Vinesh Pratap Singh

In PL/SQL, the %rowtype pseudo-type allows you to declare a record type that corresponds to a table row. It's used when you want to work with multiple columns at once from a single record or table.

display null value rows with out using null function?

8 Answers   Infosys,

---

how many tupples can insert in 1 second in sql

1 Answers  

---

How to avoid using cursors?

1 Answers  

---

Explain commit, rollback and savepoint.

1 Answers  

---

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra

2 Answers   Zensar,

---

What is a .db file?

1 Answers  

---

Can you do multiple joins in sql?

1 Answers  

---

Can we use more than one null value for unique key?

31 Answers   A1 Technology, Wipro,

---

Explain autonomous transaction.

1 Answers  

---

What is recursive stored procedure?

1 Answers  

---

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

29 Answers   Alps, Aricent, Bank Of America, Wipro,

---

Differentiate between syntax and runtime errors.

1 Answers  

---