Main diff between varray and nested tablea

3 Answers   Polaris, TCS,

---

counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

---

using comand prompt how can import table data and table space with example

2 Answers  

---

Why do we need a foreign key?

0 Answers  

---

What is the importance of sqlcode and sqlerrm?

0 Answers  

---

What is dense_rank in sql?

0 Answers  

---

what are the advantages of sql ? : Sql dba

0 Answers  

---

What is sqlservr exe?

0 Answers  

---

What is AUTH_ID and AUTH_USER in pl/sql ?

0 Answers   INDUS,

---

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2 Answers  

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

0 Answers  

---