Answer / ankush seth

three types of refreshment techniques for materialised
view
1)Fast refresh
2)Force refresh
3)Complete refresh

Answer / rajesh venati

The above one good,
There are Three Types of Refreshment Techniques in
Materialized View.
They are,

1. Fast Refresh
2. Force Refresh
3. Complete Refresh

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

0 Answers  

---

Why do we need 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,

---

How to use sql statements in pl/sql?

0 Answers  

---

define primary key & secondary key?

2 Answers  

---

what is union, minus and interact commands? : Sql dba

0 Answers  

---

What are inner and outer joins examples of both?

0 Answers  

---

Is delete faster than truncate?

0 Answers  

---

What is a common use of group by in sql?

0 Answers  

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---

What will happen after commit statement ?

2 Answers  

---

What is Overloading of procedures ?

2 Answers  

---