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 |
How many types of database triggers exist?
What is an Extent ?
What is autonomous transaction?
What are the predefined tablespaces in a database?
what is a view?
Explain temporal data types in oracle
Can a field be used in a report without it appearing in any data group ?
What are the different types of modules in oracle forms?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
How to create lov dynamically at runtime & attach to text field?