菜鸟求教!!!

Question

库中一个varchar2型的字段"value",里面存放数值型的数据,我如何检索出此数据大于500的记录?

Answer 1

select * from 表  where value > 500

Answer 2

select * from 表 where value > 500

Answer 3

存数值型的 为什么要用varchar2呢？
那只能是用to_number()进行转换了
select *
from tb
where to_number(value)>500

Answer 4

create table goods(
  goods_id varchar2(5),
  goods_name varchar2(20),
  goods_num varchar2(5));
SQL> select * from goods;
/*
GOODS_ID GOODS_NAME           GOODS_NUM
-------- -------------------- ---------
1001     佳洁士盐白           510
1002     盛爽矿泉水           451
1005     碧浪洗衣粉           530
1025     高露洁要刷           1230
1100     天津锅巴             120
1010     乌江榨菜             320
*/
 
SQL> select * from goods
  2  where to_number(goods_num)>500;
/*
GOODS_ID GOODS_NAME           GOODS_NUM
-------- -------------------- ---------
1001     佳洁士盐白           510
1005     碧浪洗衣粉           530
1025     高露洁要刷           1230
*/
 
SQL> select * from goods
  2  where to_number(goods_id)>1010;
/*
GOODS_ID GOODS_NAME           GOODS_NUM
-------- -------------------- ---------
1025     高露洁要刷           1230
1100     天津锅巴             120
*/

Answer 5

select * from tb where cast(a as integer)>500

Answer 6

select * from 表 where value > 500