What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

---

What are Nested Tables? How will u delete 5 rows from Nested Tables

3 Answers   IBM,

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---

What are character functions?

0 Answers  

---

what is the difference between $message and $$message? : Sql dba

0 Answers  

---

how will u find statistics of a database objects?

2 Answers   iFlex,

---

List the different type of joins?

0 Answers  

---

What is scope and visibility in PL/SQL?

0 Answers  

---

Which data type is a composite type?

0 Answers  

---

When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,

---

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 the use of prepared statement?

0 Answers  

---