I m giving Source, Destination and Age. Write a procedure or
function, it will give to u this source to destination
tickets are available or not, if available then check this
person is senior citizen or not,if this person is senior
citizen then give some discount.
PLZ give this answer......
Thanks advance.....
Answer Posted / aritra
TRY THIS ONE ...
CREATE TABLE FARE_DETAILS
( SOURCE VARCHAR2(100),
DESTINATION VARCHAR2(100),
FARES NUMBER(10,2));
create or replace procedure PROC_TCKT_RESERVATION
(m_source IN VARCHAR2,
m_destination IN VARCHAR2,
m_age IN NUMBER
)
is
v_source FARE_DETAILS.SOURCE%TYPE;
v_destination FARE_DETAILS.DESTINATION%TYPE;
v_fares FARE_DETAILS.FARES%TYPE;
v_fares_out FARE_DETAILS.FARES%TYPE;
begin
IF m_source= m_destination THEN
RAISE_APPLICATION_ERROR(-20001,'SOURCE, DESTINATION
SHOULD NOT BE SAME');
END IF;
SELECT FARES
INTO v_fares
FROM FARE_DETAILS
WHERE SOURCE= m_source
AND DESTINATION= m_destination ;
IF m_age>=60 THEN
v_fares_out:= (v_fares-v_fares*0.3);
DBMS_OUTPUT.PUT_LINE('GIVEN AGE IS FOR SENIOR CITIZEN,
FARE IS '||v_fares_out);
ELSE
v_fares_out:= v_fares;
DBMS_OUTPUT.PUT_LINE(' FARE IS '||v_fares_out);
END IF;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RAISE_APPLICATION_ERROR(-20001,'NO DATA FOUND ..ENTER
COREECT SOURCE/DESTINATION');
end PROC_TCKT_RESERVATION;
Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What is union and union all keyword in sql and what are their differences?
How are functions and procedures called in PL/SQL?
Is it possible to read/write files to-and-from PL/SQL?
How many parts of a pl sql block are optional?
What do you understand by pl/sql packages?
What is the primary use of normalization?
what are the types of subquery? : Sql dba
What is sql dialect?
Why use truncate instead of delete?
What is the difference between sql and mysql?
What is auto increment?
What is difference between sql and oracle?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
Can a foreign key be a duplicate?
how to install mysql? : Sql dba