Interested to Buy Any Domain ? << Click Here >> for more details...
how to insert data into partitioned table partition done by
Range partition
- 1 Answers
- 15434 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 |
Is primary key = unique key,not null? If yes,please explain IF No,please explain
What is meant by joins? List out the types of joins.
What is SAVE POINT ?
What is currency type in database ?
Can we use bind variables in oracle stored procedure?
how to find out largest value in a table
What is varray?
How do we represent comments in oracle?
What is the difference between RBBMS & DBMS?
What is format trigger?
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example
How to start an oracle instance?
Oracle General 
