how to insert data into partitioned table partition done by
Range partition
- 1 Answers
- 15639 Views
- I also Faced
- E-Mail Answers
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
What is oracle latest version?
How to write a left outer join with the where clause in oracle?
How to use values from other tables in update statements using oracle?
Design database draw er diagram for a certain scenario ?
How to start an oracle instance?
How to put more than 1000 values into an oracle in clause?
How to select all columns of all rows from a table in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
