Interested to Buy Any Domain ? << Click Here >> for more details...
how to insert data into partitioned table partition done by
Range partition
- 1 Answers
- 15522 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 |
Can we create database in oracle using command line ?
How index is implemented in oracle database?
which institute and which faculty is providing best training for oracle sql, plsql in hyderabad
What are the components of Logical database structure of ORACLE database?
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
What are nested tables?
how to find out largest value in a table
How to load data through external tables?
What are joins, explain all types of joins?
how may join possible between (requisition with purchase order)
what is foreign key?
Oracle General 
