Can you please give notes of this playlist as I have my exams approaching the link which is in the desc box says that "Sorry, the file you have requested has been deleted." Please give me the notes or if anyone else has its notes please provide me.
Q5. Create a PL/SQL package to count the number of vowels in a string . Step 1: Package Specification CODE:- CREATE OR REPLACE PACKAGE vowel_counter IS FUNCTION count_vowels(input_str VARCHAR2) RETURN NUMBER; END vowel_counter; / Step 2: Package Body CODE:- CREATE OR REPLACE PACKAGE BODY vowel_counter IS FUNCTION count_vowels(input_str VARCHAR2) RETURN NUMBER IS vowel_count NUMBER := 0; BEGIN FOR i IN 1..LENGTH(input_str) LOOP IF SUBSTR(UPPER(input_str), i, 1) IN ('A', 'E', 'I', 'O', 'U') THEN vowel_count := vowel_count + 1; END IF; END LOOP; RETURN vowel_count; END count_vowels; END vowel_counter; Step 3: Calculate CODE:- DECLARE input_string VARCHAR2(100) := 'Hello World'; vowel_count NUMBER; BEGIN vowel_count := vowel_counter.count_vowels(input_string); DBMS_OUTPUT.PUT_LINE('Number of vowels in "' || input_string || '": ' || vowel_count); END;
Q3. Write a PL/SQL code to: Create a package named cust_sal that includes a procedure find_sal. The procedure should take a customer ID as input and print the salary of the customer with that ID. Step 1: Package Specification CODE:- CREATE OR REPLACE PACKAGE cust_sal AS PROCEDURE find_sal(c_id customers.id%TYPE); END cust_sal; Step 2: Package Body CODE:- CREATE OR REPLACE PACKAGE BODY cust_sal AS PROCEDURE find_sal(c_id customers.id%TYPE) IS c_sal customers.salary%TYPE; BEGIN SELECT salary INTO c_sal FROM customers WHERE id = c_id; dbms_output.put_line('Salary: ' || c_sal); END find_sal; END cust_sal; Step 3: Use the package in the PL/SQL code for converting the temperature. CODE:- DECLARE code customers.id%type := &cc_id; BEGIN cust_sal.find_sal(code); END;
Q1. Create a Package for Calculating Rectangle Area and Perimeter. Step 1: Package Specification for Rectangle Area and Perimeter Calculation. CODE:- CREATE OR REPLACE PACKAGE RectanglePackage AS PROCEDURE CalculateAreaAndPerimeter (length IN NUMBER, width IN NUMBER, area OUT NUMBER, perimeter OUT NUMBER); END RectanglePackage; Step 2: Package Body for Rectangle Area and Perimeter Calculation. CODE:- CREATE OR REPLACE PACKAGE BODY RectanglePackage AS PROCEDURE CalculateAreaAndPerimeter (length IN NUMBER, width IN NUMBER, area OUT NUMBER, perimeter OUT NUMBER) IS BEGIN area := length * width; perimeter := 2 * (length + width); END CalculateAreaAndPerimeter; END RectanglePackage; / Step 3: Now Calculate Rectangle Area and Perimeter Using the Package. CODE:- DECLARE l_length NUMBER := 5; l_width NUMBER := 3; l_area NUMBER; l_perimeter NUMBER; BEGIN RectanglePackage.CalculateAreaAndPerimeter(l_length, l_width, l_area, l_perimeter); DBMS_OUTPUT.PUT_LINE('The area of the Rectangle is ' || l_area); DBMS_OUTPUT.PUT_LINE('The Perimeter of the Rectangle is ' || l_perimeter); END; /
Q4. Create a PL/SQL package to calculate the compound interest for a given principal, rate, and time. Step 1: Package Specification CODE:- CREATE OR REPLACE PACKAGE interest_calculator IS FUNCTION calculate_compound_interest(principal NUMBER, rate NUMBER, time NUMBER) RETURN NUMBER; END interest_calculator; / Step 2: Package Body CODE:- CREATE OR REPLACE PACKAGE BODY interest_calculator IS FUNCTION calculate_compound_interest(principal NUMBER, rate NUMBER, time NUMBER) RETURN NUMBER IS BEGIN RETURN principal * POWER((1 + rate / 100), time); END calculate_compound_interest; END interest_calculator; / Step 3:Calculate CODE:- DECLARE principal_amt NUMBER := 1000; interest_rate NUMBER := 5; time_period NUMBER := 2; compound_interest NUMBER; BEGIN compound_interest := interest_calculator.calculate_compound_interest(principal_amt, interest_rate, time_period); DBMS_OUTPUT.PUT_LINE('Compound Interest: ' || compound_interest); END;
Q2. Temperature Conversion Package in PL/SQL. Step 1: Package Specification for Temperature Conversion. CODE:- CREATE OR REPLACE PACKAGE TemperatureConversion AS FUNCTION CelsiusToFahrenheit (celsius IN NUMBER) RETURN NUMBER; FUNCTION FahrenheitToCelsius(fahrenheit IN NUMBER) RETURN NUMBER; END TemperatureConversion; / Step 2: Package Body for Temperature Conversion Functions. CODE:- CREATE OR REPLACE PACKAGE BODY TemperatureConversion AS FUNCTION CelsiusToFahrenheit (celsius IN NUMBER) RETURN NUMBER IS BEGIN RETURN (celsius * 9/5) + 32; END CelsiusToFahrenheit; FUNCTION FahrenheitToCelsius(fahrenheit IN NUMBER) RETURN NUMBER IS BEGIN RETURN (fahrenheit - 32) * 5/9; END FahrenheitToCelsius; END TemperatureConversion; / Step 3: Use the package in the PL/SQL code for converting the temperature. CODE:- DECLARE celsius_temp NUMBER := 20; fahrenheit_temp NUMBER; converted_celsius_temp NUMBER; BEGIN fahrenheit_temp := TemperatureConversion.CelsiusToFahrenheit(celsius_temp); DBMS_OUTPUT.PUT_LINE('Temperature in Fahrenheit: ' || fahrenheit_temp); converted_celsius_temp := TemperatureConversion.FahrenheitToCelsius(fahrenheit_temp); DBMS_OUTPUT.PUT_LINE('Converted back to Celsius: ' || converted_celsius_temp); END; /
Can you please give notes of this playlist as I have my exams approaching the link which is in the desc box says that "Sorry, the file you have requested has been deleted." Please give me the notes or if anyone else has its notes please provide me.
Can you please give notes of this playlist as I have my exams approaching the link which is in the desc box says that "Sorry, the file you have requested has been deleted." Please give me the notes or if anyone else has its notes please provide me.
Can you please give notes of this playlist as I have my exams approaching the link which is in the desc box says that "Sorry, the file you have requested has been deleted." Please give me the notes or if anyone else has its notes please provide me.
Sir, Thank You So Much for This Amazing Lecture 🙂
Lecture - 3 Completed ✅
Notes tw milty nhi hain....
Pr video bht achi hai hmari mam tw pta nhi kesy smjhati hain kich smj nhi ata ...but ap bht acha smjhaty thanks...😁
hmari mam bhi lgta ap ki mam ki hi trah hay
i have no words you are so good...
But notes not available on that site ...
Can you please give notes of this playlist as I have my exams approaching the link which is in the desc box says that "Sorry, the file you have requested has been deleted."
Please give me the notes or if anyone else has its notes please provide me.
Q5. Create a PL/SQL package to count the number of vowels in a string . Step
1: Package Specification CODE:-
CREATE OR REPLACE PACKAGE vowel_counter IS
FUNCTION count_vowels(input_str VARCHAR2) RETURN NUMBER;
END vowel_counter;
/
Step 2: Package Body CODE:-
CREATE OR REPLACE PACKAGE BODY vowel_counter IS
FUNCTION count_vowels(input_str VARCHAR2) RETURN NUMBER IS vowel_count
NUMBER := 0;
BEGIN
FOR i IN 1..LENGTH(input_str) LOOP
IF SUBSTR(UPPER(input_str), i, 1) IN ('A', 'E', 'I', 'O', 'U') THEN
vowel_count := vowel_count + 1; END IF;
END LOOP;
RETURN vowel_count;
END count_vowels;
END vowel_counter;
Step 3: Calculate CODE:-
DECLARE input_string VARCHAR2(100) := 'Hello
World';
vowel_count NUMBER;
BEGIN vowel_count :=
vowel_counter.count_vowels(input_string);
DBMS_OUTPUT.PUT_LINE('Number of vowels in "' || input_string || '": ' || vowel_count);
END;
Q3. Write a PL/SQL code to: Create a package named cust_sal that includes a procedure find_sal. The
procedure should take a customer ID as input and print the salary of the customer with that ID. Step
1: Package Specification CODE:-
CREATE OR REPLACE PACKAGE cust_sal AS
PROCEDURE find_sal(c_id customers.id%TYPE); END
cust_sal;
Step 2: Package Body CODE:-
CREATE OR REPLACE PACKAGE BODY cust_sal AS PROCEDURE
find_sal(c_id customers.id%TYPE) IS
c_sal customers.salary%TYPE;
BEGIN
SELECT salary INTO c_sal
FROM customers
WHERE id = c_id; dbms_output.put_line('Salary: ' ||
c_sal); END find_sal;
END cust_sal;
Step 3: Use the package in the PL/SQL code for converting the temperature.
CODE:-
DECLARE code customers.id%type :=
&cc_id;
BEGIN
cust_sal.find_sal(code);
END;
Q1. Create a Package for Calculating Rectangle Area and Perimeter.
Step 1: Package Specification for Rectangle Area and Perimeter Calculation.
CODE:-
CREATE OR REPLACE PACKAGE RectanglePackage AS
PROCEDURE CalculateAreaAndPerimeter (length IN NUMBER, width IN NUMBER, area OUT NUMBER,
perimeter OUT NUMBER);
END RectanglePackage;
Step 2: Package Body for Rectangle Area and Perimeter Calculation. CODE:-
CREATE OR REPLACE PACKAGE BODY RectanglePackage AS
PROCEDURE CalculateAreaAndPerimeter (length IN NUMBER, width IN NUMBER, area OUT NUMBER,
perimeter OUT NUMBER) IS
BEGIN area := length * width;
perimeter := 2 * (length + width);
END CalculateAreaAndPerimeter;
END RectanglePackage;
/
Step 3: Now Calculate Rectangle Area and Perimeter Using the Package.
CODE:-
DECLARE l_length NUMBER := 5;
l_width NUMBER := 3;
l_area NUMBER;
l_perimeter NUMBER;
BEGIN
RectanglePackage.CalculateAreaAndPerimeter(l_length, l_width, l_area, l_perimeter);
DBMS_OUTPUT.PUT_LINE('The area of the Rectangle is ' || l_area);
DBMS_OUTPUT.PUT_LINE('The Perimeter of the Rectangle is ' || l_perimeter); END;
/
Q4. Create a PL/SQL package to calculate the compound interest for a given principal, rate, and time. Step
1: Package Specification
CODE:-
CREATE OR REPLACE PACKAGE interest_calculator IS
FUNCTION calculate_compound_interest(principal NUMBER, rate NUMBER, time NUMBER) RETURN
NUMBER;
END interest_calculator;
/
Step 2: Package Body CODE:-
CREATE OR REPLACE PACKAGE BODY interest_calculator IS
FUNCTION calculate_compound_interest(principal NUMBER, rate NUMBER, time NUMBER) RETURN
NUMBER IS
BEGIN
RETURN principal * POWER((1 + rate / 100), time);
END calculate_compound_interest;
END interest_calculator;
/
Step 3:Calculate CODE:-
DECLARE principal_amt NUMBER
:= 1000; interest_rate NUMBER
:= 5; time_period NUMBER := 2;
compound_interest NUMBER;
BEGIN compound_interest := interest_calculator.calculate_compound_interest(principal_amt,
interest_rate,
time_period);
DBMS_OUTPUT.PUT_LINE('Compound Interest: ' || compound_interest);
END;
Q2. Temperature Conversion Package in PL/SQL.
Step 1: Package Specification for Temperature Conversion.
CODE:-
CREATE OR REPLACE PACKAGE TemperatureConversion AS
FUNCTION CelsiusToFahrenheit (celsius IN NUMBER) RETURN NUMBER;
FUNCTION FahrenheitToCelsius(fahrenheit IN NUMBER) RETURN NUMBER;
END TemperatureConversion;
/
Step 2: Package Body for Temperature Conversion Functions.
CODE:-
CREATE OR REPLACE PACKAGE BODY TemperatureConversion AS
FUNCTION CelsiusToFahrenheit (celsius IN NUMBER) RETURN NUMBER IS BEGIN
RETURN (celsius * 9/5) + 32;
END CelsiusToFahrenheit;
FUNCTION FahrenheitToCelsius(fahrenheit IN NUMBER) RETURN NUMBER IS
BEGIN
RETURN (fahrenheit - 32) * 5/9;
END FahrenheitToCelsius;
END TemperatureConversion;
/
Step 3: Use the package in the PL/SQL code for converting the temperature.
CODE:- DECLARE celsius_temp NUMBER := 20; fahrenheit_temp NUMBER;
converted_celsius_temp NUMBER;
BEGIN fahrenheit_temp :=
TemperatureConversion.CelsiusToFahrenheit(celsius_temp);
DBMS_OUTPUT.PUT_LINE('Temperature in Fahrenheit: ' || fahrenheit_temp);
converted_celsius_temp := TemperatureConversion.FahrenheitToCelsius(fahrenheit_temp);
DBMS_OUTPUT.PUT_LINE('Converted back to Celsius: ' || converted_celsius_temp);
END;
/
Can you please give notes of this playlist as I have my exams approaching the link which is in the desc box says that "Sorry, the file you have requested has been deleted."
Please give me the notes or if anyone else has its notes please provide me.
How to get Complete notes on Architecture of Distributed Databases
Check it on lastmomenttuitions.com
Thank you 😊
Welcome
Affinity matrix aur Bond enery Algorithm pe video banao na bhai
Kaustubh Dhore paper ki baat hi upload Kare ga I think bond energy ki koi hai to paste Kar bro
Bro NC video
Thank you
peer to peer is mesh topology...not star
Sir, you understanding me good but, your notes are not view properly.
Notes?
in description details are given how you can buy the notes
Notes aa gaye kyaa
Transparency pr deitial sy videos bna do bhai
Can you please give notes of this playlist as I have my exams approaching the link which is in the desc box says that "Sorry, the file you have requested has been deleted."
Please give me the notes or if anyone else has its notes please provide me.
plz Or video DDBMS k liye bnavna Brow,,
Advance database management system ke topic banavo na sir plz
Can you please give notes of this playlist as I have my exams approaching the link which is in the desc box says that "Sorry, the file you have requested has been deleted."
Please give me the notes or if anyone else has its notes please provide me.
kuch samaj nhi atta yr
Hi
Everything is good but video uploaded very dirty and poor quality
provide the notes plzzz 🙏🏻
Check it on lastmomenttuitions.com