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: A Normalization Question

Re: A Normalization Question

From: Neo <neo55592_at_hotmail.com>
Date: 22 Jul 2004 12:16:41 -0700
Message-ID: <4b45d3ad.0407221116.791ea1ed@posting.google.com>


> > > > ..can't derive 'brown is composed of b, r, o, w, n' from empty db...
> > >
> > > SELECT "brown" AS [string], spell('brown') AS spelling;
> > > Function spell(s As String) As String...
> >
> > You derived that 'brown is composed of b, r, o, w, n'
> > not from an empty db but from info within the SQL statement.
>
> The SQL statement could ask for the spelling of any string
> not just for 'brown'.

True, and in every case the sequential symbols which compose the string are derived from the string itself in the SQL, not from an empty db.

> ... the info is not coming from the SQL statement or from the string "brown".

Try removing 'brown' from your SQL and see if it works. Received on Thu Jul 22 2004 - 14:16:41 CDT

Original text of this message

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