new sql question
From: xgong <xgong_at_mediaone.net>
Date: Wed, 07 Mar 2001 00:40:36 GMT
Message-ID: <8sfp6.1085$G76.1024862_at_typhoon.ne.mediaone.net>
Date: Wed, 07 Mar 2001 00:40:36 GMT
Message-ID: <8sfp6.1085$G76.1024862_at_typhoon.ne.mediaone.net>
I appreciate if you answer my following sql newbie question.
Why did I get three number (800) by following sql statement?
SQL> descr bonus;
Name Null? Type ----------------------------- -------- ------------- ENAME VARCHAR2(10) JOB VARCHAR2(9) SAL NUMBER COMM NUMBER
SQL> select 200*4 from bonus;
200*4
800
200*4
800
200*4
800
Thanks a lot,
Tom Gong Received on Wed Mar 07 2001 - 01:40:36 CET