Re: What's wrong with this question?

From: <ga11742_at_pop.iperbole.bologna.it>
Date: Sun, 13 Dec 1998 02:26:06 +0100
Message-ID: <367317AE.E03B81B0_at_pop.iperbole.bologna.it>


WLD1838 ha scritto:

> Hi,
>
> This is the question:
> You attempt to create a view with this command:
> CREATE FORCE VIEW lat_first vu
> AS SELECT first_name ||' ' || last_name " Emplyee Names"
> FROM employee
> ORDER BY lat_name, first_name;
> WHich clause caused an error? why?
>
> Anyone knows the anwser, please help.
>
> Thanks in advance!
>
> Helen

"CREATE FORCE VIEW lat_first vu" ---> I think "lat_first" is

       the name of the view, but what is "vu" ? I think this is incorrect.

"ORDER BY lat_name, first_name" ---> You cannot use the "ORDER BY"

       clause during the view creation : you can use "ORDER BY" selecting

       data form the view.

Hi Received on Sun Dec 13 1998 - 02:26:06 CET

Original text of this message