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.

query optmization techniques and quwry analyser+projects+ppts

2469

---

What are the differences between primary key and unique key?

1065

---

How to establish administrator authentication to the server?

1099

---

How to drop a tablespace?

1087

---

Explain the use of parfile option in exp command.

1141

---

Briefly explain what is literal? Give an example where it can be used?

1091

---

What is index in Oracle?

1133

---

Explain oracle left join with an example?

1064

---

How to use existing values in update statements using oracle?

1116

---

How remove data files before opening a database?

1135

---

Is a rollback possible to any savepoint?

1156

---

How to display employee records who gets more salary than the average salary in the department?

1127

---

What is the usage of save points in oracle database?

1015

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2548

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1970

---