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 / ajitnayak

Hi Aritra, Kavitha,
Ur logic is correct, but it's not complete all point, where ur program is identify tickets are available or not then u program should calculate fare and all details.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are joins in sql?

719


How many parts of a pl sql block are optional?

711


How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

864


give the syntax of grant and revoke commands? : Sql dba

800


What is the use of partition by in sql?

709






How does sql profiler work?

751


What is the difference between inner join and outer join?

712


What is set serveroutput on in pl sql?

808


when is the use of update_statistics command? : Sql dba

685


How do I run a sql query in pgadmin 4?

717


What is sqlite used for?

699


what is a relationship and what are they? : Sql dba

744


what are different types of keys in sql?

767


What are all the different normalizations?

742


what are date and time data types in mysql? : Sql dba

682