Answer / kart

select * from table where id is not null;

Answer / sumit

select id,name from table where id is not null;

Answer / ajit nayak

Delete from <tab_name>
where id is null;

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,

---

Describe sql comments?

0 Answers  

---

What is sql injection vulnerability?

0 Answers  

---

How do I know if I have sql express or standard?

0 Answers  

---

Store procedure will return a value?

4 Answers   eMids,

---

---

What is the use of non clustered index?

0 Answers  

---

Why is pl sql used?

0 Answers  

---

What is pl/sql table? Why it is used?

0 Answers  

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

0 Answers  

---

how to drop an existing table in mysql? : Sql dba

0 Answers  

---

Explain what is table in a database?

0 Answers  

---

Does postgresql run on the cloud?

0 Answers  

---