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;

What is oracle pl sql developer?

963

---

What is procedure and function?

959

---

Does a join table need a primary key?

940

---

Which are the different character-manipulation functions in sql?

1039

---

How to avoid duplicate records in a query?

987

---

how many ways to get the current time? : Sql dba

988

---

how to select first 5 records from a table? : Sql dba

962

---

what is cursor. write example of it. What are the attributes of cursor.

1366

---

What are all ddl commands?

1065

---

What is the use of sql trace?

936

---

How can get second highest salary in sql?

964

---

What is parallel hint?

1301

---

Sql technical questions

1252

---

What is the requirement of self-join?

1100

---

what is difference between delete and truncate commands? : Sql dba

1104

---