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 […]
Write a program to enter two numbers and find their sum in PLSQL block .
Practical Practice 2 Oracle Practice Write a program to enter two numbers and find their sum in PLSQL block . Write a program to enter two numbers and find their sum in PLSQL block . SOLUTION –Static code set serveroutput on; DECLARE number1 number := 10; number2 number := 20; tot number; BEGIN tot := […]
Write a code to print “Hello World” in PLSQL block.
Practical Practice 1 Oracle Practice Write a code to print “Hello World” in PLSQL block. Write a program to print “Hello World” in PLSQL block. SOLUTION –Static code set serveroutput on; DECLARE mes varchar2(100) := ‘Hello World’; BEGIN dbms_output.put_line(mes); END; / –Dynamic code set serveroutput on; DECLARE mes varchar2(100) := ‘&mes’; BEGIN dbms_output.put_line(mes); END; / […]
Practical Practice for Oracle – 2
Practical Practice -2 Oracle Practice Overview Practice -2 SOLUTION create table infant ( item_code number primary key, item varchar2(100) not null, DatePurchase date, UnitPrice number, Discount number); SOLUTION insert into infant values(101,’Frock’,’23-Jan-2016′,700,10); insert into infant values(102,’Cot’,’23-Sep-2015′,5000,25); insert into infant values(103,’Soft Toy’,’17-Jun-2016′,800,10); insert into infant values(104,’Baby Socks’,’16-Oct-2014′,100,7); insert into infant values(105,’Baby Suit’,’20-Sep-2015′,500,5); SOLUTION 1 SELECT […]