Answer / rupa

Invalid

Answer / noorulahaq

as the package have 2 parts decl & body, decl part is valid
where as body wll be invalid. It means overall answer is
Invalid.

Answer / sridevi.o

its invalid

Answer / kolipaka

It shows valid, because the entire package will be executed
and it is valid. inside the procedure will show error when
the package reffers to that procedure. like EXEC
PKG_NAME.PROC_NAME.

What are the indexing methods?

0 Answers  

---

What is sqlservr exe?

0 Answers  

---

What is the syntax and use of the coalesce function?

0 Answers  

---

What is Histogram?

0 Answers   NIIT,

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

---

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,

---

Is stored procedure faster than query?

0 Answers  

---

How do you assign Construct the where clause without concatenating Field,value pairs?

1 Answers   Microsoft,

---

What are sql objects?

0 Answers  

---

What is %rowtype in pl sql?

0 Answers  

---

Can you skip header records while loading? : aql loader

0 Answers  

---

how to get a list of columns in an existing table? : Sql dba

0 Answers  

---