how to insert data into partitioned table partition done by
Range partition
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.
Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What are the logical operations?
How to delete an existing row from a table in oracle?
What is columnar storage what is the advantage?
When system tablespace is created?
What is the difference between a hot backup and a cold backup in oracle?
What are the different types of record groups in oracle? Explain each of them
What is an oracle user account?
How to loop through a cursor variable?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
How would you change old and new values in an insert, delete and update triggers?
What is the difference between a user and a schema in oracle?
What is a data dictionary and how can it be created?
How to convert characters to dates in oracle?