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
Why stored procedures are faster than query?
What is sqlca in db2?
Why do we need sharding?
Explain how exception handling is done in advance pl/sql?
What is a unique constraint?
Who developed sql?
Is natural join and inner join same?
How to return an array from java to pl/sql?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
what are the types of subquery? : Sql dba
What is information schema in sql?
What is your daily office routine?
which types of join is used in sql widely? : Sql dba
How can we implement rollback or commit statement in a trigger?
How many columns should be in an index?