Home » RDBMS Server » Server Administration » How select particular columns in type object
How select particular columns in type object [message #372567] Fri, 23 February 2001 02:50 Go to next message
Balamurugan
Messages: 4
Registered: February 2001
Junior Member
Hai,

I have a type object
stud_add_type
------------
street varchar2,
city varchar2,
pincode varchar2

table is
student
-------
studname varchar2,
studno number,
address stud_add_type.

now i want to select the studname,studno with city only.

and i have to update the city only with particular studno.

Thanks in advance.

With regards,
Balu

Report message to a moderator

Re: How select particular columns in type object [message #372575 is a reply to message #372567] Fri, 23 February 2001 16:26 Go to previous message
amarpatgiri
Messages: 11
Registered: December 2000
Junior Member
TO Select:

SELECT studname,studno,s.address.city
FROM Student s;

TO Update:

UPDATE student s
SET s.address.city = <new value>
WHERE studno = <expr>

-amar

Report message to a moderator

Previous Topic: concatenate text in the same field
Next Topic: table created in SQL invisible in Oracle Navigator...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 06:57:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.