how to insert data into partitioned table partition done by
Range partition
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 |
What is the difference between alert log file and trace file ?
When do we use group by clause in a sql query?
What is a oracle database?
How to invoke the original export import utilities?
What is the difference between substr and instr?
How to start an oracle instance?
How to convert numbers to characters in oracle?
Explain an exception?
what is the uses of cusor
How to convert characters to dates in oracle?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What are the set operators union, union all, minus & intersect meant to do?