Answer / s

A.HASH partitioning is useful on columns which are unique
in nature where range or list partitioning cannot be done.
All the hash partitions hold an equal number of rows
thereby improving the performance and response time of the
query if the table is queried.

List partition is used on a table if you can divide table
based on column value. Something like region wise
partioning if the table contains a column like region.The
advantage of list partitioning is that you can group and
organize unordered and unrelated sets of data in a natural
way.

Why is there a need for sqlcode and sqlerrm variables?

0 Answers  

---

What are the different dml commands in sql?

0 Answers  

---

what is meant by nl2br()? : Sql dba

0 Answers  

---

What are the pre requisites?

1 Answers  

---

Can we create clustered index without primary key?

0 Answers  

---

What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

---

What does the sign mean in sql?

0 Answers  

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

0 Answers  

---

1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?

2 Answers  

---

How to get each name only once from an employee table?

0 Answers  

---

Can we perform dml in function?

0 Answers  

---

what is sql profiler

2 Answers   Fidelity,

---