?? char_like.txt
字號:
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';
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -