Answer / mk

An extent is a contiguous set (side-by-side) of Oracle data blocks allocated to a segment within a tablespace.

What is anonymous block in sql?

0 Answers  

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

What is a null value?

0 Answers  

---

What is the Diff b/w Constraints and Trigeer

4 Answers   HCL,

---

In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,

---

Does mysql_real_escape_string prevent sql injection?

0 Answers  

---

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,

---

how can we find the number of rows in a table using mysql? : Sql dba

0 Answers  

---

What will happen after commit statement ?

2 Answers  

---

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 Answers  

---

How do I filter in sql profiler?

0 Answers  

---