Answer Posted / sant

In oracle the below eg will help you to clear this:

DECLARE
D INTEGER :=NULL;
E INTEGER :=NULL;
BEGIN
IF (D = E) THEN
dbms_output.put_line('PASS);
ELSE
dbms_output.put_line('FAIL');
END IF;
END;

It will alwayz return FAIL.

Are pl sql variables case sensitive?

997

---

What is synchronized subquery?

1091

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1159

---

I need a function for a train ticket reservation please answer it thanks in advance

957

---

What is the difference between a primary key and a clustered index?

930

---

How delete all data from table in sql?

948

---

Do we need to create index on primary key?

853

---

Is oracle and sql same?

954

---

Explain the difference between triggers and constraints?

920

---

What are the different ddl commands in sql?

1065

---

Can we commit in trigger?

921

---

Explain what is sql*plus?

1085

---

What are the uses of sysdate and user keywords?

1051

---

What is number function in sql?

913

---

Mention what does the hierarchical profiler does?

1021

---