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 difference between sql and mysql?

750

---

How do you break a loop in pl sql?

730

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

724

---

What is the execution plan in sql?

758

---

Is delete faster than truncate?

751

---

---

What are different types of sql?

757

---

How sql query is executed?

782

---

What is the difference between clustered and non-clustered index in sql?

733

---

What does seeding a database mean?

689

---

What is foreign key and example?

706

---

Can %notfound return null after a fetch?

756

---

Is pl sql still used?

684

---

what is data integrity? : Sql dba

782

---

Can we use threading in pl/sql?

712

---

How can you create an empty table from an existing table?

799

---