Interested to Buy Any Domain ? << Click Here >> for more details...
how to insert data into partitioned table partition done by
Range partition
- 1 Answers
- 15517 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 data pump export and import modes?
What are the limitations oracle database 10g xe?
What are transaction isolation levels supported by oracle?
how to retrive xml data for using sql query?
Without giving condition how to retrieve the unmatched records from table.
Explain database link?
How to put more than 1000 values into an oracle in clause?
What is a deadlock ? Explain .
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
Who developed oracle & when?
What is a cursor variable?
How to insert a record into a table?
Oracle General 
