Oracle Type Query

[email protected] Wed, 29 Jan 2003 04:03:27 +0000
Newsgroups gmane.comp.db.oracle.devel
Message-ID <LYRIS-1796914-852707-2003.01.29-03.59.05--gcdod-oracle#[email protected]>
I have a user defined type in my database schema (Oracle 8i).
I created a table based on thsi user type. 
I was able to insert data in the database. 
However I want to enter multiple data in the udt column.
How do I dod that?

Eg - 
Create Type ITSKILLS(SKILLNAME VARCHAR2(100), EXPMONTHS NUMBER) AS OBJECT;
Create Table SWDV( SWDVID NUMBER, SWNAME VARCHAR2(100), SWSKILL ITSKILLS);

How do I insert multiple rows in the SWSKILL column in the SWDV table?

Another question I have is how do I retrieve this in an ADO recordset, if I am 
using Visual Basic?

Thanks & Regards,
Abhijit



-------------------------------------------------
This mail sent through Nucsoft: http://nucsoft.co.in/


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].