How to use SELECT to query this kind of table?

From: <ppakorn_at_my-deja.com>
Date: Thu, 06 Jan 2000 16:30:20 GMT
Message-ID: <852fu7$17u$1@nnrp1.deja.com>

I have a table named student as below

create type name_o as object (

first     varchar2(10),
middle    varchar2(10),
last      varchar2(15));

/

create type address_o as object (

street     varchar2(15),
city       varchar2(15),
state      char(2),
zip        char(5));

/

create table student(

sid       char(9) not null,
name      name_o,

address address_o,
telnum varchar2(11),
primary key (sid));

I know only how to insert information into this table, but have no idea how to query (SELECT statement) such as showing first name of student who live in NY. How can I do that? Actually I don't know how to do the updating (UPDATE TABLE statement)too. Please help me.

Thank you in advance
Pak

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 06 2000 - 10:30:20 CST