Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can I define a VARRAY as a foreign key?

Re: Can I define a VARRAY as a foreign key?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 15 Jul 2002 07:03:22 +0200
Message-ID: <grl4ju4c5ennp5r4glccbcqn9cd1a019c4@4ax.com> 





On 14 Jul 2002 21:19:59 -0700, danesh583_at_yahoo.com (Gita Danesh)
wrote:



>I have a varray(10) of number and I want its elements to be foreign

>key.I tried it in Sql plus but I got error.If anyone knows how to do

>it ,I would be greatful to share it with me.





As a VARRAY is not a single column, it is NOT possible. Think about
it, how would it be?



Hth



Sybrand Bakker, Senior Oracle DBA



To reply remove -verwijderdit from my e-mail address
Received on Mon Jul 15 2002 - 00:03:22 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US