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;

Which normal form is best?

948

---

Which command is used to call a stored procedure?

1001

---

When sql appeared?

1102

---

What is pl sql architecture?

961

---

what is data control language? : Sql dba

1028

---

Does inner join remove duplicates?

943

---

What is the difference between join and natural join?

927

---

describe mysql connection using mysql binary. : Sql dba

1068

---

What is difference between group by and partition by?

1062

---

What is difference between mysql and postgresql?

1156

---

Explain the order of sql statement execution?

1045

---

what is the difference between clustered and non clustered index in sql? : Sql dba

1127

---

Where is pl sql used?

954

---

what is the difference between inner and outer join? Explain with example. : Sql dba

1025

---

what are the differences among rownum, rank and dense_rank? : Sql dba

1040

---