Question: 1 . Write a PL / SQL block to find out if a year is a leap year. A leap year is divisible by 4
Write a PLSQL block to find out if a year is a leap year. A leap year is divisible by but not divisible by or it is divisible by For example, and are leap years, but and are not leap years. Hint: The function MOD n d divides n by d and returns the integer remainder from the operationWrite a PLSQL block to print all odd numbers between and using a basic loopUsing a FOR loop, print the values to in reverse orderCreate a table called ITEM with one column ItemNum with NUMBER type. Write a PLSQL program to insert values of to for ItemNumInput a number with a substitution variable and then print its multiplication table using a WHILE loopInput a month number between and and a digit year, and print number of days in that month. For February month check for leap year to display number of days equal to or Use a PLSQL block to delete item number from the ITEM table created in question Write a PLSQL block to ask a user to input a valid employee IdRetrieve employees name, qualification description, salary and commission. Print name, qualification and sum of salary and commission.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
