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: Checking if a table is normalized using SQL

Re: Checking if a table is normalized using SQL

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Sun, 18 Mar 2007 18:52:57 -0500
Message-ID: <45fdc460$0$13928$88260bb3@free.teranews.com>


tech_Anay wrote:
> Hi,
>
> Is there any way to check if a particular table in Oracle is in normal
> forms 1,2,3 using SQL statements? Any pointers would be appreciated!
>
>
> Thanks.
>
> TechArl
>

Maybe if the database had some semblance of the defined Functional Dependencies, you might be able to query the DB to find out this information. But since that information is lacking in the DB, you can't query about it.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com
Received on Sun Mar 18 2007 - 18:52:57 CDT

Original text of this message

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