Answer / Rekha Rai

To return an array from Java to PL/SQL, you can use Java SQL Callable Statements. First, define the Java method that takes a parameter of type OracleArray and uses it as needed. Then, create an instance of the OracleArray, set its elements, and call the stored procedure with the array as a parameter.

what are the advantages of using stored procedures? : Sql dba

1 Answers  

---

Is sql between inclusive?

1 Answers  

---

What's the difference between inner join and left join?

1 Answers  

---

Which function is used to return remainder in a division operator in sql?

1 Answers  

---

Is time a data type in sql?

1 Answers  

---

is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,

---

what is a database lock ? : Sql dba

1 Answers  

---

what are null values? : Sql dba

1 Answers  

---

What are sql objects?

1 Answers  

---

What is the difference between rollback and rollback to statements?

1 Answers  

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1 Answers  

---

From an Employee table, how will you display the record which has a maximum salary?

29 Answers   Cap Gemini, Exilant, Synechron,

---