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.

What is the implicit cursor in oracle?

1108

---

Differentiate between pre-select and pre-query?

1113

---

What is a named program unit?

1088

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4598

---

How to select all columns of all rows from a table in oracle?

1055

---

What is the data pump import utility?

1038

---

What do you mean by a deadlock?

1066

---

What is oracle host variable?

1068

---

What is the difference between truncate & delete command?

1186

---

Why is oracle database so popular?

1006

---

What is oracle and what are its different editions?

1068

---

How to work with data objects interactively?

989

---

How to drop an existing view in oracle?

947

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1990

---

How to drop a tablespace?

1048

---