Answer Posted / shanmugavelu

suppose u have create partition table like,

Sql>Create table Pixel_emp_details(emp_no number,
emp_name varchar2(10))
partition by range (emp_no)
(partition pixel_p1 values less than(10));
Sql>/
Table is created

After that u have use normal insert statement like

Sql> insert into pixel_emp_details partition(pixel_p1)
values(1,'gopi')
SQL> /

1 row created.

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2071

---

What is meant by an index?

1070

---

What do you mean by a deadlock?

1017

---

What is a subquery?

1064

---

What is an oracle table?

938

---

How to convert character types to numeric types?

1059

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1028

---

What is the difference between Delete, Truncate and Drop in Oracle?

1077

---

What is a initialization parameter file in oracle?

992

---

What is an oracle?

960

---

How data locks are respected in oracle?

1015

---

How to rebuild an index in oracle?

980

---

How to convert characters to dates in oracle?

1032

---

Explain about functional dependency and its relation with table design?

960

---

Differentiate between post-database commit and post-form commit?

984

---