Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Checking if a table is normalized using SQL
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.comReceived on Sun Mar 18 2007 - 18:52:57 CDT
![]() |
![]() |