Create database for account, customer, loan, branch as required., deposit 1.
Display the customers name who are living in the city Nagpur? 2. Display the names of Depositor having amount greater than 4000? 3. Display the names of all branches located in the city of Bombay? 4. Display the name of the borrower who having the loan number 206? 5. Display the account number and deposit amount of customers having amount opened in the year of 1996? 6. Display the list of depositors who deposited after date of 01/03/1996? 7. Display all the details of customer anil including his Account no,City,Branch Name, Amount deposited and loan details ? 8. Display the names of customers living in city Bombay and having city Nagpur as branch? 9. Display the names of customers having the same living city as their branch city? [Link] the names of customers living in city Bombay and having city Nagpur as branch? [Link] the names of borrowers having deposit amount greater than 1000 and loan amount greater than 2000? [Link] the living city of Anil and Sandip? [Link] all the customers who are depositors but not borrowers? [Link] all the customers who are depositors and borrowers? [Link] all the depositors living in the city Nagpur and having branch in city Delhi? [Link] the cities which are either branch city of Anil or living city of Sunil ? [Link] is the total amount of loan? [Link] is the total amount of deposit? [Link] the total amount taken from Nagpur branch? [Link] maximum deposit of customers living in Bombay? [Link] many number of customers having account in the Bombay branch? [Link] the total number of depositor By branch wise?
[Link] the number of customer who are depositor as well as borrowers? [Link] branch wise total loan amount? [Link] the branches having sum of deposit more than amount of 5000? [Link] the branches having sum of deposit more than 5000 and located in city Bombay? [Link] the names of customers having deposit in the branches where the average deposit is more than 5000? [Link] the name of the branch having highest? [Link] the name of the branch where number of depositors more than 5? [Link] the name of city having more customers living in Nagpur? [Link] the name of cities in which the maximum number of branches located? [Link] 10% of interest to all depositors? [Link] 10% of interest to all depositors living in Nagpur? [Link] Rs.100 from the account of Anil to Sunil? [Link] with sql statements with Rollback & Commit, distinct, between etc.
1. To write a PL/SQL program to fetch a particular Record for a given student number. 2. To write a PL/SQL program to fetch a Record and eliminate unnecessary Blank Spaces. 3. To write a PL/SQL program to fetch a Record and Eliminate Blank spaces in Error Handling method. 4. To write a PL/SQL program to demonstrate the usage of IF. . .ELSE Construct. 5. To write a PL/SQL program to Calculate the sum of the series by giving the starting and Ending number using Loop construct.
6. To write a PL/SQL program to Print the series by Giving Starting and Ending number and Increment value using Looping construct. 7. To write a PL/SQL program to check whether the given String is Palindrome or Not. 8. To write a PL/SQL program to compute NcR Value using Function. 9. To write a PL/SQL program to create a stored procedure for displaying Student Information. [Link] write a PL/SQL program to create a stored procedure and Function to Display available seats in a section. [Link] write a PL/SQL program to create cursor to display people who are eligible for voting. [Link] write a PL/SQL program to create cursor to display total Marks, Percentage, Grade of Class. [Link] write a PL/SQL program for implicit cursor [Link] write a PL/SQL program for explicit cursor [Link] write a PL/SQL program to user defined Exception.
