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 trigger and types?

552

---

What do you mean by field in sql?

528

---

What is pl sql quora?

638

---

What is sql comments?

646

---

what are the different functions in sorting an array? : Sql dba

577

---

---

Explain how exception handling is done in advance pl/sql?

548

---

When should I use nosql database?

547

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

1669

---

What is the difference between clustered and non-clustered indexes?

597

---

how to include numeric values in sql statements? : Sql dba

555

---

How can we link a sql database to an existing android app?

543

---

Difference between truncate, delete and drop commands?

552

---

What is file based approach?

483

---

Can we use ddl commands in pl sql?

552

---

When do we use triggers?

581

---