RDBMS "PARTITION TABLE program code

PROGRAM:5 NAME:RUBUS C
DATE:02/08/2019 REGNO:20173081401230

PARTITION TABLE

SQL> create table sales009(year number(5).
2 product varchar( l0).
3 amt number(10.2))
4 partition by range(year)
5 (partition pl values less than(1992).
6partition p2 values less than(1993).
7partition p3 values less than( 1994),
8 partition p4 values less than( 1995).
9 partition p5 values less than( MAXVALUE)):
Table created.

SQL> insert into sales009 values(1991,'soap', 1000);
1row created.

SQL> insert into sales009 values(1991,'soap',1000);
1row created.

SQL> insert into sales009 values(1991,powder,9000):
I row created.

SQL> insert into sales009 values(1991,'book',8000):
I row created.

SQL> insert into sales009 values( 1992,'soap',9 100):
I row created.

SQL> insert into sales009 values(1992,'book"8900):R
row created.

SQL> insert into sales009 values( 1992.'pen',9000);AAC wh B
1row created.

SQL> insert into sales009 values( 1993.'soap'. l 100);
1row created.

SQL> insert into sales009 values( 1993,'book',1200):
1row created.

SQL> insert into sales009 values( 1993,'bag', 1500):
I rowcreated.

SQL> insert into sales009/alues( 1994\'soap', 1300):
I row created.