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].