Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Object Oriented

 

Inserting a row into an object table using constructor

SQL> SQL> CREATE Or Replace TYPE ProductType AS OBJECT (   2    id          NUMBER,   3    name        VARCHAR2(15),   4    description VARCHAR2(22),   5    price       NUMBER(5, 2),   6    days_valid  NUMBER   7  )   8  / Type created. SQL> SQL> CREATE TABLE object_products OF ProductType   2  / Table created. SQL> SQL> INSERT INTO object_products VALUES (   2    ProductType(1, 'AAA', 'BBB', 3.95, 10)   3  ); 1 row created. SQL> SQL> select * from object_products;  ID NAME            DESCRIPTION                 PRICE DAYS_VALID --- --------------- ---------------------- ---------- ----------   1 AAA             BBB                          3.95         10 SQL> SQL> drop table object_products; Table dropped. SQL>