Interested to Buy Any Domain ? << Click Here >> for more details...
how to insert data into partitioned table partition done by
Range partition
- 1 Answers
- 15410 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 |
What is the dynamic sql in oracle?
What is the difference between Outer join and Full outer join?
What is a server parameter file in oracle?
What are oracle functions?
What is the sid in oracle?
Why we choose emp number as primarykey?
what is the scenario where you take the database to NoArchivelog mode?
Describe varray?
Explain the blob datatype?
What are the differences between interval year to month and interval day to second?
How to convert numbers to characters in oracle?
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
Oracle General 
