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;

How many types of privileges are available in sql?

1400

---

how to return query output in html format? : Sql dba

1120

---

How do you truncate?

953

---

What is pl sql code?

1104

---

Is vs as in pl sql?

1036

---

Do ddl statements need commit?

1020

---

What is difference between function and trigger?

1108

---

what is auto increment? : Sql dba

1049

---

Why use stored procedures?

1140

---

how can we destroy the session, how can we unset the variable of a session? : Sql dba

1047

---

What are the different type of joins in sql?

997

---

What is a null value?

1187

---

Can we change the table name in sql?

1000

---

Explain locks? : Transact sql

1050

---

what are all different types of collation sensitivity? : Sql dba

1027

---