Hello.
The sentence in the discussion is next.
>>>>You use a VALUES statement when you do not have a FROM clause.
If we replace "statement" as "clause", it corresponds to "clause" of
FROM in the sentence.
I feel this seems to be the answer...
Best regards.
Laura Stewart wrote:
I think that "statement" should be used only for SQL statements like
SELECT, CREATE TABLE, GRANT. VALUES is not a statement in SQL. I
believe that "clause" is more accurate.
Laura
On 1/16/07, TomohitoNakayama <[EMAIL PROTECTED]> wrote:
Hello.
See ....
It is reason why I feel question that title of the page was "VALUE
expression" and there was "VALUE statement".
Then I feel question for the different word.
Reading comment from others, however ,
I came to conclude that it is quite right that the words are different
according to context which original writer thought .
Then I will respect original usage and keep it as "statement" in
translated manual.
Thank you for your comments :)
Best regards.
Bernt M. Johnsen wrote:
>>>>>>>>>>>>>Julius Stroffek wrote (2007-01-15 17:16:36):
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>Hi Tomohito,
>>
>>I would say that the VALUES construct is a statement not an
expression.
>>The result and usage is similar like SELECT statement.
>>
>>
>
>In the SQL standard the construct
> VALUES <row values expression list>
>is called a <table value constructor>
>
>
>
>
>>Cheers
>>
>>Julo
>>
>>TomohitoNakayama wrote:
>>
>>
>>>Hello.
>>>
>>>I found next one sentence in "VALUES expression" of Derby Reference
>>>Manual (http://db.apache.org/derby/docs/dev/ref/rrefsqlj11277.html)
>>>
>>>
>>>
>>>
>>>>You use a VALUES statement when you do not have a FROM clause.
>>>>
>>>>
>>>>
>>>I think statement should be expression here but not completely
sure ....
>>>I hope opinion from others ...
>>>
>>>Best regards.
>>>
>>>
>>>
>>>
>
>
>
--
/*
Tomohito Nakayama
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Naka
http://www5.ocn.ne.jp/~tomohito/TopPage.html
*/
--
/*
Tomohito Nakayama
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Naka
http://www5.ocn.ne.jp/~tomohito/TopPage.html
*/
