--显示表的结构
desc customers;
--在表中使用binary_float和binary_double数据类型
create table binary_test(
bin_float binary_float,
bin_double binary_double
);
--插入数据
insert into binary_test values(123.4f , 23.6d);
--插入无穷大
insert into binary_test values(binary_float_infinity,binary_double_infinity);
--查询数据
select * from binary_test;
--2.PL/SQL简介
create or replace procedure update_product_price(
p_product_id in products.product_id%type,
p_factor in number
) as
product_count integer;
begin
select count(*) into product_count
from products
where product_id = p_product_id;
if product_count = 1 then
update products set price = price * p_factor
where product_id = p_product_id;
commit;
end if;
exception
when others then
rollback;
end update_product_price;
--调用存储过程,修改price
call update_product_price(1,2);
--查看修改后的price
select * from products where product_id = 1;