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';