how to insert data into partitioned table partition done by
Range partition
- 1 Answers
- 14862 Views
- I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 10 Yes | 3 No |
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is clusters ?
What is an Oracle view?
What is background process in Oracle?
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
what are steps for interface? where is exchange rate defined in which table?
How to define Data Block size ?
What is an Oracle index?
Which is faster join or subquery in oracle?
What privilege is needed for a user to create tables in oracle?
What is blob data type in oracle?
Explain view?
Oracle General 
