--显示表的结构
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;

ITPub博客

Oracle Database 11g SQL 开发指南学习笔记：binary_float和binary_double数据类型

最新文章