Answer Posted / kuldeep123

DECLARE
v1 NUMBER;
v2 NUMBER;
BEGIN
IF v1 = v2
THEN
DBMS_OUTPUT.put_line ('Null comapred successfully');
ELSE
DBMS_OUTPUT.put_line ('oops u have to use ISNULL opeartor');
END IF;
END;


output : oops u have to use ISNULL opeartor

What is a nested table in word?

952

---

How many types of functions are there in sql?

942

---

explain about mysql and its features. : Sql dba

1013

---

Where not exists in sql?

971

---

How do you bind variables in pl sql?

1088

---

How long it takes to learn pl sql?

1005

---

Why use triggers in sql?

948

---

what is data integrity? : Sql dba

1030

---

what is a composite primary key ? : Sql dba

1044

---

How can you save or place your msg in a table?

999

---

What is a common use of group by in sql?

1045

---

What is the difference between stored procedure and view?

1015

---

How to download oracle sql developer?

1096

---

What is a sql driver?

995

---

How does one load ebcdic data? : aql loader

1159

---