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 union? : Sql dba

582

---

what is the use of double ampersand (&&) in sql queries?

625

---

What are sql queries used for?

536

---

Are subqueries better than joins?

536

---

How do I sort a table in sql?

597

---

---

what is the use of set statement in tsql? : Transact sql

536

---

what are date and time functions in mysql? : Sql dba

534

---

What is sql resultset?

531

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2570

---

What are all types of user defined functions?

532

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

557

---

Show code of a cursor for loop.

584

---

what is union, minus and interact commands? : Sql dba

659

---

what is transaction? : Sql dba

532

---

What is the most important ddl statements in sql are?

523

---