Answer Posted / sant

In oracle the below eg will help you to clear this:

DECLARE
D INTEGER :=NULL;
E INTEGER :=NULL;
BEGIN
IF (D = E) THEN
dbms_output.put_line('PASS);
ELSE
dbms_output.put_line('FAIL');
END IF;
END;

It will alwayz return FAIL.

What is break?

620

---

What is the difference between nvl function, ifnull function, and isnull function?

592

---

How do rank () and dense_rank () differ?

522

---

What is the use of triggers?

545

---

What are the types pl/sql code blocks?

611

---

---

What is the difference between microsoft sql and mysql?

512

---

How exception is different from error?

545

---

What is a sql instance vs database?

579

---

What are the types of index in sql?

533

---

How do I find duplicates in two columns?

553

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

573

---

What does truncate mean in sql?

536

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

635

---

What is cursor explain with example?

556

---

Which table is left in join?

516

---