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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Database design question

Re: Database design question

From: Michael Gaab <mike-g_at_montana.com>
Date: Mon, 26 Jun 2006 11:25:28 -0600
Message-ID: <1151342257_41411@sp6iad.superfeed.net>

<sreedhardasi_at_gmail.com> wrote in message news:1151333970.145260.93970_at_y41g2000cwy.googlegroups.com...
>I have a database design questions. How can we specify one of two
> columns in a table should be not null? In other words, if one column is
>
> null then another column should not be null.

My first thought is the following, either at the dbms level or application level.

if( tableA.group_id == null)
{

    tableB.user_id = IDGenerator();
}

Mike

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Received on Mon Jun 26 2006 - 12:25:28 CDT

Original text of this message

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