What is trigger point?

0 Answers  

---

What language is oracle sql developer?

0 Answers  

---

PL/SQL allocates memory for the variable's at runtime or at compile time

3 Answers  

---

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers   Satyam,

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

---

what is the difference between char and varchar data types? : Sql dba

0 Answers  

---

Explain the commit statement.

0 Answers  

---

How many levels can subqueries be nested in a FROM clause?

7 Answers  

---

Does pl sql work in mysql?

0 Answers  

---

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

---

What is the diff between Truncate table / delete <table name> purge

3 Answers   TCS,

---