what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

0 Answers  

---

What is the difference between rename and alias?

0 Answers  

---

What are the uses of merge?

0 Answers  

---

..........refers to the disk mirroring

2 Answers   iFlex,

---

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

---

What is Highwatermark?

3 Answers   Thermotech,

---

How are sql commands classified?

0 Answers  

---

What is Temp Table and type of temp table?

1 Answers   HP, SLK,

---

what is Complex index. how to create it?

2 Answers  

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

What is a trigger in sql?

0 Answers  

---

what is the bond code in materialized view?

0 Answers  

---