what happens if null values are involved in expressions? : Sql dba

0 Answers  

---

How can analyze query after generating explain plan ?

2 Answers   Thermotech,

---

What is the purpose of primary key?

0 Answers  

---

Does pl sql work in mysql?

0 Answers  

---

What is procedure function?

0 Answers  

---

---

What is sql used for?

0 Answers  

---

What is the most important ddl statements in sql are?

0 Answers  

---

Can we perform dml in function?

0 Answers  

---

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

---

Can function return multiple values in sql?

0 Answers  

---

What is dynamic sql in pl sql?

0 Answers  

---

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 Answers   Oracle,

---