how to insert data into partitioned table partition done by
Range partition
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 meant by recursive hints ?
How to run the anonymous block again?
Explain drop constraint oracle?
What are the sql clauses supported in the link property sheet ?
Please explain drop constraint oracle?
how to get last monday of a month?
what is the use of rank function?
find out the third highest salary?
92 Answers CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,
Explain table?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
How to export your own schema?
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables