Re: How do i get SQL command line? (i think it's right)

From: DenHang <DenHang_at_pi.be>
Date: Thu, 11 Jul 2002 23:36:22 +0200
Message-ID: <agktm5$7p2$1@reader07.wxs.nl>

You must finish your statement with ';' and press enter, then you get your result.
The 2 you are talking about is just the line numbering

Ex.:
SQL> select * from coffees;

ID NAME

---------- ----------------
         0 Black cat
         1 Java
         2 Douwe Egberts


SQL> select * from coffees
  2  where id < 2;                            (=> 2 stands for second line)

        ID NAME
---------- ---------------
         0 Black cat
         1 Java

"Konrad Den Ende" <konrad_at_voxway.com> wrote in message news:agkrs2$u7j$1_at_news.gu.se...
> Thank you for the answer. I'm not sure if we talk about
> the same thing here, however. The problem is that when
> i type:
>
> Select * From COFFEES
>
> I don't get the nice table i'd expect. I only get "2". That's
> all. Do i miss something?
> --
>
> Vänligen
> Konrad
> -------------------------------------------------------
> URL: http://konrads.webbsida.com
> E-Mail: konrad_at_voxway.com
> Phone: (+46) 0708 - 70 73 92
> ICQ: 132 250 451
>
>
>
Received on Thu Jul 11 2002 - 16:36:22 CDT