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

Is pl sql different from sql?

935

---

how to concatenate two character strings? : Sql dba

1030

---

what is the difference between union and union all? : Sql dba

973

---

Does sql backup shrink transaction log?

914

---

Advantages and disadvantages of stored procedure?

1058

---

How do I count rows in sql query?

937

---

List the ways to get the count of records in a table?

852

---

how to select first 5 records from a table? : Sql dba

918

---

What can I use instead of union in sql?

902

---

What is native sql query?

968

---

What is not null in sql?

984

---

What are different sql data types?

953

---

What are the different types of joins in sql?

1651

---

what is a tablespace? : Sql dba

1004

---

Which nosql database is best?

923

---