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.

can you call insert/update/delete in select statements. If yes how? If no what is the other way?

2 Answers  

---

What is oracle database 10g express edition?

0 Answers  

---

What is using clause and give example?

0 Answers  

---

structural difference between bitmap and btree index ?

1 Answers   Infosys,

---

Difference between hot backup vs. Cold backup?

0 Answers  

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

0 Answers  

---

What is difference between sid and service name in oracle?

0 Answers  

---

Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz

2 Answers  

---

Explain enable novalidate constraint.

0 Answers  

---

How to assign a tablespace to a users in oracle?

0 Answers  

---

Explain about integrity constraint?

0 Answers  

---

Can we call procedure inside function in oracle?

0 Answers  

---