Is stored procedure faster than query?

0 Answers  

---

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

7 Answers   Polaris,

---

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 Answers   Oracle,

---

Write a query to display the current date in sql?

0 Answers  

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

0 Answers  

---

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?

3 Answers   TCS,

---

How do I clear the screen in sql plus?

0 Answers  

---

List the different type of joins?

0 Answers  

---

What is procedure and function in sql?

0 Answers  

---

What's the difference between a primary key and a clustered index?

0 Answers  

---

How to install oracle sql developer?

0 Answers  

---

Query for second maximum salary in each in each department

15 Answers   DST Global Solutions, TCS,

---