char_like.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 51 行

DROP TABLE product_char;

CREATE TABLE product_char( 
     product_name     CHAR(4), 
     product_price    NUMBER(4,2),
     quantity_on_hand NUMBER(5,0),
     last_stock_date  DATE
     )
;

INSERT INTO product_char VALUES 
     ('AA', 99, 1, '15-1月-03');
select * from product_char where product_name ='AA';

select * from product_char where product_name like 'AA%';

select * from product_char where product_name like '%AA';
--结果如何？


--结果如何？
select * from product_char where product_name like 'A_';
--无纪录选出


-----------VARCHAR2----------------------------------------------------------

DROP TABLE product_char;

CREATE TABLE product_char( 
     product_name     VARCHAR2(4), 
     product_price    NUMBER(4,2),
     quantity_on_hand NUMBER(5,0),
     last_stock_date  DATE
     )
;


INSERT INTO product_char VALUES 
     ('AA', 99, 1, '15-1月-03');
select * from product_char where product_name ='AA';

select * from product_char where product_name like 'AA%';

select * from product_char where product_name like 'A_';
--结果OK
select * from product_char where product_name like '%AA';