是要这种效果吗?SQL> create table b (a number,b number,c number);Table created.SQL> insert into b values( 1 , 23.5, 23.5);1 row created.SQL> ed Wrote file afiedt.buf 1* insert into b values( 1 ,20, 20) SQL> /1 row created.SQL> select a ,b+c from b; A B+C --------- --------- 1 47 1 40SQL>
select a,b+c from table
题目 ORACLE ,如表结构: A B C 1 23.5 23.5 2 20 30最后一个数字是不是错了?应该是20吧
Wrote file afiedt.buf
1* insert into b values( 1 ,20, 20)
SQL> /1 row created.SQL> select a ,b+c from b; A B+C
--------- ---------
1 47
1 40SQL>
ORACLE ,如表结构:
A B C
1 23.5 23.5
2 20 30最后一个数字是不是错了?应该是20吧