Where the Pre_defined_exceptions are stored ?

2 Answers  

---

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,

---

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 what is sql*plus?

0 Answers  

---

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

8 Answers  

---

what is the Default Libraries for Oracle Report 6i

0 Answers   IBM,

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

0 Answers  

---

Can sql developer connect to db2?

0 Answers  

---

what is the difference between pragma exception_init and raise_application_error

1 Answers   Aetins, State Street,

---

how many columns can be used for creating index? : Sql dba

0 Answers  

---

What is an intersect?

0 Answers  

---

What is the difference between a query and a report?

0 Answers  

---