What is difference sql and mysql?

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,

---

What is query optimization in sql?

0 Answers  

---

Give the order of sql select?

0 Answers  

---

How to start the command-line sql*plus?

0 Answers  

---

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

0 Answers  

---

why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.

2 Answers  

---

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

8 Answers  

---

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,

---

What is a design view?

0 Answers  

---

Explain the structure of pl/sql in brief.

0 Answers  

---

Explain what is a view?

0 Answers  

---