Interested to Buy Any Domain ? << Click Here >> for more details...
how to insert data into partitioned table partition done by
Range partition
- 1 Answers
- 15578 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 are the various constraints used in oracle?
What is the implicit cursor in oracle?
How to connect the oracle server as sysdba?
How to delete a column in an existing table in oracle?
Give the Types of modules in a form?
What is format trigger?
How to use "in" parameter properly?
How to use windows user to connect to the server?
How do I recompile a procedure in oracle?
what is candidate key & super key
What is bind variable in oracle 11g?
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
Oracle General 
