Answer / Siddhartha Chaturvedi

An Oracle function is a block of reusable PL/SQL code that returns a single value. Functions can take zero or more input parameters and can be called within SQL statements, PL/SQL blocks, and other functions.

Explain the relationship among Database, Tablespace and Data file?

4 Answers  

---

What is the sid in oracle?

1 Answers  

---

Explain oracle’s server parameter file.

1 Answers  

---

How to run create database statement again?

1 Answers  

---

Can we write insert statement in function in oracle?

1 Answers  

---

How do we create privileges in oracle?

1 Answers  

---

What is the difference between truncate & delete command?

1 Answers  

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

1 Answers  

---

Explain the different normalization forms?

1 Answers  

---

how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group

2 Answers   Verizon,

---

what are bitmap indexes? How does they work?

1 Answers  

---

What is ASM (Automatic Storage Management) in Oracle?

1 Answers   MCN Solutions,

---