create or replace function getOrder(p_id IN number)
return number is
v_name varchar;
v_age number;
v_address varchar;
v_enter varchar;
v_trade varchar;begin
select a.Name,a.Age,a.Address,b.EnterDate,b.TradeDate into v_name,v_age,v_address,v_enter,v_trade from passenger a,orderRecord b where a.passengerID=b.passengerID and OrderID=p_id;
dbms_output_put_line('客户姓名:'||v_name);
dbms_output_put_line('年龄:'||v_age);
dbms_output_put_line('家庭住址:'||v_address);
dbms_output_put_line('入住时间:'||to_char(v_enter);
dbms_output_put_line('结账时间:'||to_char(V_trade);
return ;end getOrder;