Answer / 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.

What is memory advisor in Oracle?

0 Answers   MCN Solutions,

---

what is difference between foreign key and reference key

3 Answers   AZTEC, Infosys,

---

What is difference between a formal and an actual parameter?

1 Answers  

---

How do I limit the number of oracle database connections generated by weblogic server?

0 Answers  

---

What to do if the binary spfile is wrong for the default instance?

0 Answers  

---

What are ACID properties in databases?

1 Answers  

---

Difference between the “verify” and “feedback” command?

0 Answers  

---

In Exception handling if we are using the when others first then what happens . whether it will show the compiler error

2 Answers   HCL,

---

Respected sir, Please send me technical questions related to oracle apps..

0 Answers  

---

How to find 1st, 2nd, 3rd highest using select select statement not using rownum

3 Answers  

---

What is a proxy object?

0 Answers  

---

What is Redo Log Buffer in Oracle?

0 Answers   MCN Solutions,

---