How can we store rows in PL/SQL using array?

0 Answers   MCN Solutions,

---

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,

---

Why is there a need for sqlcode and sqlerrm variables?

0 Answers  

---

What is a file delimiter?

0 Answers  

---

what is explain plan?, given an example...

3 Answers   Polaris,

---

Define overloaded procedure?

0 Answers  

---

what are all different types of collation sensitivity? : Sql dba

0 Answers  

---

what is isam? : Sql dba

0 Answers  

---

Explain exception handling in pl/sql?

0 Answers  

---

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

---

Explain foreign key in sql?

0 Answers  

---

What are the advantages of pl sql?

0 Answers  

---