Write a note on Joins.
ASSIGNMENT ASSIGNMENT ASSIGNMENT Q.2 Write a note on Joins. Answer :- In Oracle databases, join queries are used to retrieve data from multiple tables by combining rows based on a related column between them. Joins are essential for querying relational databases, as they allow for a comprehensive view of data spread across different tables. Types of Joins […]
Explain Codd’s Rules.
ASSIGNMENT ASSIGNMENT ASSIGNMENT Q.1 Explain Codd’s Rules. Answer :- Codd’s rules, proposed by Dr. Edgar F. Codd in 1985, serve as a benchmark for evaluating whether a database management system (DBMS) is truly relational. Codd originally defined 12 rules, including a rule 0, which collectively outline the characteristics a system must exhibit to qualify as […]
Write a program to convert days into years, weeks and days in PLSQL block.
Practical Practice 10 Oracle Practice Write a program to convert days into years, weeks and days in PLSQL block. Write a program to convert days into years, weeks and days in PLSQL block. SOLUTION –Static code SET SERVEROUTPUT ON; DECLARE total_days NUMBER := 400; years NUMBER; weeks NUMBER; days NUMBER; BEGIN years := FLOOR(total_days / […]
Write a program to enter temperature in Fahrenheit and convert to Celsius in PLSQL block.
Practical Practice 9 Oracle Practice Write a program to enter temperature in Fahrenheit and convert to Celsius in PLSQL block. Write a program to enter temperature in Fahrenheit and convert to Celsius in PLSQL block. SOLUTION –Static code SET SERVEROUTPUT ON; DECLARE fahrenheit NUMBER := 77; celsius NUMBER; BEGIN celsius := (fahrenheit – 32) * […]
Write a program to enter temperature in Celsius and convert it into Fahrenheit in PLSQL block.
Practical Practice 8 Oracle Practice Write a program to enter temperature in Celsius and convert it into Fahrenheit in PLSQL block. Write a program to enter temperature in Celsius and convert it into Fahrenheit in PLSQL block. SOLUTION –Static code set serveroutput on; DECLARE celsius NUMBER := 25; fahrenheit NUMBER; BEGIN — Conversion formula: Fahrenheit […]
Write a program to enter length in centimeter and convert it into meter and kilometer in PLSQL block.
Practical Practice 7 Oracle Practice Write a program to enter length in centimeter and convert it into meter and kilometer in PLSQL block. Write a program to enter length in centimeter and convert it into meter and kilometer in PLSQL block. SOLUTION –Static code set serveroutput on; DECLARE length_cm NUMBER := 15; length_m NUMBER ; […]
Write a program to enter radius of a circle and find its diameter, circumference and area in PLSQL block.
Practical Practice 6 Oracle Practice Write a program to enter radius of a circle and find its diameter, circumference and area in PLSQL block. Write a program to enter radius of a circle and find its diameter, circumference and area in PLSQL block. SOLUTION –Static code set serveroutput on; DECLARE radius number := 6; area […]
Write a program to enter length and breadth of a rectangle and find its area in PLSQL block.
Practical Practice 5 Oracle Practice Write a program to enter length and breadth of a rectangle and find its area in PLSQL block. Write a program to enter length and breadth of a rectangle and find its area in PLSQL block. SOLUTION –Static code set serveroutput on; DECLARE length number := 5; width number := […]
Write a program to enter length and breadth of a rectangle and find its perimeter in PLSQL block.
Practical Practice 4 Oracle Practice Write a program to enter length and breadth of a rectangle and find its perimeter in PLSQL block. Write a program to enter length and breadth of a rectangle and find its perimeter in PLSQL block. SOLUTION –Static code set serveroutput on; DECLARE length number := 5; width number := […]
Write a program to enter two numbers and perform all arithmetic operations in PLSQL block.
Practical Practice 3 Oracle Practice Write a program to enter two numbers and perform all arithmetic operations in PLSQL block. Write a program to enter two numbers and perform all arithmetic operations in PLSQL block. SOLUTION –Static code set serveroutput on; DECLARE number1 number := 30; number2 number := 20; tot number; sub number; mul […]