Query data from table based on object



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> drop table address_table;

Table dropped.

SQL>
SQL>

Related examples in the same category

1.	Display the New Table (SELECT * and SELECT by Column Name)
2.	Query object table
3.	Use type member function in select statement
4.	SELECT Only One Column in the Composite
5.	SELECT with a WHERE Clause
6.	SELECTing Individual Columns in TCROs
7.	Use the function we created: use the table alias in our SELECT as well as the qualifier
8.	Use * to reference column with user-defined type
9.	demonstrates SQL operations on object types.
10.	Select the object type from the table, rather than the columns.
11.	Use %ROWTYPE to select from the relational table.

Query data from table based on object : Select « Object Oriented Database « Oracle PL / SQL

Related examples in the same category