Answer / Shikha Raj

Data Manipulation Language (DML) is a subset of SQL used to modify the data in a database. DML commands include SELECT, INSERT, UPDATE, DELETE, and MERGE.

What are properties of the transaction?

1 Answers  

---

How to copy a table in another table with datas?

9 Answers  

---

What is sql basics?

1 Answers  

---

What is the difference between database trigger and stored procedure?

1 Answers  

---

What are types of exception?

1 Answers  

---

Is left join faster than join?

1 Answers  

---

What is the use of primary key?

1 Answers  

---

if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,

---

Difference between SUBSTR and INSTR?

3 Answers  

---

how to sort records in sql?

3 Answers  

---

What is difference between procedure and trigger?

1 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,

---