Answer Posted / sureka

set serveroutput on;
DECLARE
D INTEGER :=NULL;
E INTEGER :=NULL;
BEGIN
IF (D = E) THEN
dbms_output.put_line('PASS');
ELSIF (D <> E) THEN
dbms_output.put_line('FAIL');
ELSE
dbms_output.put_line('NA');
END IF;
END;

will return NA

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

657

---

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

704

---

How do I order by ascending in sql?

741

---

What is pl sql architecture?

686

---

What is data abstraction in sql?

727

---

---

what happens if null values are involved in expressions? : Sql dba

736

---

Is pl sql still used?

684

---

what is single byte over head in oracle..?

2090

---

Why we use join in sql?

702

---

What are the built in functions of sql?

757

---

What are the different types of dbmss?

747

---

What is indexes?

754

---

What is sharding in sql?

738

---

How many scalar data types are supported in pl/sql?

716

---

What is a full join?

707

---