four procedures is are there should i write their in a package

2 Answers  

---

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

1 Answers   TCS,

---

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

6 Answers   Accenture,

---

Does truncate need commit?

0 Answers  

---

Are sql connections encrypted?

0 Answers  

---

Does sql profiler affect performance?

0 Answers  

---

how many tables will create when we create table, what are they? : Sql dba

0 Answers  

---

how can we destroy the session, how can we unset the variable of a session? : Sql dba

0 Answers  

---

What are all ddl commands?

0 Answers  

---

what are different types of collation sensitivity? : Sql dba

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,

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

---