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.

Why do we use coalesce function in oracle?

1050

---

What is oracle database client?

974

---

What is truncate oracle?

915

---

What is a proxy object?

1007

---

Is it possible to split the print reviewer into more than one region ?

2221

---

What is data file?

1044

---

What are the predefined tablespaces in a database?

1008

---

Where do we use decode and case statements?

942

---

What is oracle in java?

909

---

How to connect to oracle using service name instead of sid?

962

---

How to check the oracle tns settings?

989

---

 What are the oracle DML commands possible through an update strategy?

1004

---

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2070

---

What is the recommended interval at which to run statspack snapshots, and why?

2860

---

What are the different types of trigger and explain its various uses and functions?

1007

---