UPDATE Data in a Table of Row Objects : Update « Object Oriented Database « Oracle PL / SQL






UPDATE Data in a Table of Row Objects

 


SQL> -- UPDATE Data in a Table of Row Objects
SQL>
SQL>
SQL> CREATE OR REPLACE TYPE address_obj as OBJECT(
  2        street VARCHAR2(20),
  3        city VARCHAR2(20),
  4        state CHAR(2),
  5        zip CHAR(5));
  6  /

Type created.

SQL>
SQL> CREATE TABLE address_table OF ADDRESS_OBJ;

Table created.

SQL>
SQL> INSERT INTO address_table VALUES ('4 D St.', 'Gulf Breeze','FL','32563');

1 row created.

SQL>
SQL> SELECT *
  2  FROM address_table;

STREET               CITY                 ST ZIP
-------------------- -------------------- -- -----
4 D St.              Gulf Breeze          FL 32563


SQL>
SQL>
SQL>
SQL> UPDATE address_table
  2  SET zip = 32514
  3  WHERE zip = 32504;

0 rows updated.

SQL>
SQL> UPDATE address_table
  2  SET street = '11 A Dr'
  3  WHERE city LIKE 'Gulf%';

1 row updated.

SQL>
SQL>
SQL> SELECT *
  2  FROM address_table;

STREET               CITY                 ST ZIP
-------------------- -------------------- -- -----
11 A Dr              Gulf Breeze          FL 32563


SQL>
SQL>
SQL> drop table address_table;

Table dropped.

SQL>
SQL>
           
         
  








Related examples in the same category

1.Use type constructor in update statement
2.update calls the constructor in the SET clause
3.Using UPDATE with Columns
4.UPDATE a Table that Contains Row Objects (TCRO)
5.Update using the PL/SQL variables
6.Update user-defined type column