Answer Posted / kavitha nedigunta

CREATE TABLE FARE_DETAILS
( SOURCE VARCHAR2(100),
DESTINATION VARCHAR2(100),
FARES NUMBER(10,2));


CREATE OR REPLACE FUNCTION TCKT_RESERVATION_FUN
(
I_SOURCE IN FARE_DETAILS.SOURCE%TYPE,
I_DESTINATION IN FARE_DETAILS.DESTINATION%TYPE,
I_AGE IN FARE_DETAILS.FARES%TYPE
) RETURN VARCHAR2
AS
L_OUT_PUT VARCHAR2(2000) DEFAULT NULL;
L_FARES FARE_DETAILS.FARES%TYPE;
BEGIN

IF UPPER(TRIM(I_SOURCE)) = UPPER(TRIM(I_DESTINATION)) THEN
l_OUT_PUT := 'SOURCE, DESTINATION SHOULD NOT BE SAME';
RETURN l_OUT_PUT;
END IF;

SELECT FARES INTO L_FARES FROM FARE_DETAILS
WHERE UPPER(TRIM(SOURCE)) = UPPER(TRIM(I_SOURCE))
AND UPPER(TRIM(DESTINATION)) = UPPER(TRIM
(I_DESTINATION));

IF I_AGE >=60 THEN
l_OUT_PUT:= (L_FARES-L_FARES*0.3);
ELSE
l_OUT_PUT := L_FARES;
END IF;
RETURN l_OUT_PUT;
EXCEPTION
WHEN NO_DATA_FOUND THEN
l_OUT_PUT :='NO DATA FOUND ..ENTER COREECT
SOURCE/DESTINATION';
RETURN l_OUT_PUT;
END TCKT_RESERVATION_FUN;

Can you rollback after commit?

976

---

What is a mutating table and a constraining table?

1107

---

Why triggers are used?

987

---

What is the size of partition table?

1043

---

What is record data type?

911

---

How do you create a db file?

1012

---

What is trigger in sql and its types?

1055

---

Explain cursor types?

1019

---

Define SQL and state the differences between SQL and other conventional programming Languages?

1207

---

what is a field in a database ? : Sql dba

1053

---

Is inner join same as self join?

1111

---

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

1023

---

What are the two virtual tables available at the time of database trigger execution?

1222

---

What is forward declaration in pl sql?

1076

---

Are subqueries better than joins?

971

---