posted 22 years ago
Hi!
I created address_ty type for address.In that I used street1(varchar),street2(varchar),city(varchar),state(varchar),pincode(number).Particularly I want to get the city.
I used the Query like
select address.city from <Table Name>.But it is giving invalid column name error
Am using Oracle*i in windows NT.I don't what's wrong in this.
Thankx in advance
Raajesh