Programming > ANSWERS AND COMMENTARIES > Chandigarh University COMPUTER S DBMS anayaranjan (All)
Chandigarh University COMPUTER S DBMS anayaranjan
Document Content and Description Below
Experiment Title:- 3.1 Student Name: ANAYA UID: 20BCS5125 Branch: CSE Section/Group: 715-A Semester: 3 rd Date of Performance: 05-11-21 Subject Name: Database Management Lab Subject Code: 20CSP ... -215 QUESTION 1:- Create Local procedure to calculate the simple interest by passing the values of principal, rate and time. PROGRAM CODE:- DECLARE p NUMBER(9, 2); r NUMBER(9, 2); t NUMBER(9, 2); si NUMBER(9, 2); ci NUMBER(9, 2); BEGIN p := 33000; r := 7; t := 6; si := ( p * r * t ) / 100; ci := p * Power (1 + ( r / 100 ),t); dbms_output.Put_line('Simple Interest = '||si); dbms_output.Put_line('Compound interest = '|| ci); This study source was downloaded by 100000824368823 from CourseHero.com on 11-04-2022 08:03:46 GMT -05:00 https://www.coursehero.com/file/118681889/EX-31-DBMSdocx/ END; OUTPUT:- [Show More]
Last updated: 3 years ago
Preview 1 out of 5 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$4.50
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Nov 04, 2022
Number of pages
5
Written in
All
Additional information
This document has been written for:
Uploaded
Nov 04, 2022
Downloads
0
Views
94
