Write a program to enter base and height of a triangle and find its area in PLSQL block.
Practical Practice 14 Oracle Practice Write a program to enter base and height of a triangle and find its area in PLSQL block. Write a program to enter base and height of a triangle and find its area in PLSQL block. SOLUTION –Static code set serveroutput on; DECLARE base_triangle NUMBER := 10 ; height_triangle NUMBER […]
Write a program to enter two angles of a triangle and find the third angle in PLSQL block.
Practical Practice 13 Oracle Practice Write a program to enter two angles of a triangle and find the third angle in PLSQL block. Write a program to enter two angles of a triangle and find the third angle in PLSQL block. SOLUTION –Static code DECLARE angle1 NUMBER := 70; angle2 NUMBER := 80; angle3 NUMBER […]
Write a program to enter any number and calculate its square root in PLSQL block.
Practical Practice 12 Oracle Practice Write a program to enter any number and calculate its square root in PLSQL block. Write a program to enter any number and calculate its square root in PLSQL block. SOLUTION –Static code DECLARE num NUMBER := 25; sqrt_result NUMBER; BEGIN sqrt_result := SQRT(num); DBMS_OUTPUT.PUT_LINE(‘Square root of ‘ || num […]
Write a program to find power of any number x ^ y in PLSQL block.
Practical Practice 11 Oracle Practice Write a program to find power of any number x ^ y in PLSQL block. Write a program to find power of any number x ^ y in PLSQL block. SOLUTION –Static code set serveroutput on DECLARE x NUMBER := 3; y NUMBER := 2; result NUMBER := 1; BEGIN […]
Explain Types of Cursors.
ASSIGNMENT ASSIGNMENT ASSIGNMENT Q.8 Explain Types of Cursors. Answer :-Â In PL/SQL, a cursor is a pointer or a handle to a context area in memory, where SQL query results are processed and stored. It allows you to retrieve and manipulate query results row by row. Cursors are particularly useful when working with queries that […]
Write a note on TCL & DCL.
ASSIGNMENT ASSIGNMENT ASSIGNMENT Q.7 Write a note on TCL & DCL. Answer :- Transaction Control Language (TCL) and Data Control Language (DCL) in SQL. SQL is divided into various categories based on the type of operations they perform. Among these are Transaction Control Language (TCL) and Data Control Language (DCL), which serve specific purposes in […]
Write a note on Relational Algebra.
ASSIGNMENT ASSIGNMENT ASSIGNMENT Q.6 Write a note on Relational Algebra. Answer :- Relational Algebra Operations are : Select, Project, Union, Intersection, and Rename Relational algebra provides a collection of algebraic operation that operate on relations (or tables) and it gives output result in the form of tables. Relational Algebra is a procedural query language used […]
Write a note on Sub Query.
ASSIGNMENT ASSIGNMENT ASSIGNMENT Q.5 Write a note on Sub Query. Answer :- Subqueries with INSERT, UPDATE, and DELETE in Oracle. A subquery in Oracle is a query nested within another SQL statement. It is used to retrieve intermediate data that can be used by the main query for various operations like INSERT, UPDATE, or DELETE. Subqueries can […]
Explain PL/SQL loops in detail.
ASSIGNMENT ASSIGNMENT ASSIGNMENT Q.4 Explain PL/SQL loops in detail. Answer :-Â PL/SQL loops are control structures that allow the repetition of a block of statements multiple times based on a specified condition. They help manage repetitive tasks efficiently and are an integral part of procedural programming in PL/SQL. Oracle PL/SQL provides different types of loops […]
Explain PL/SQL Block Structure.
ASSIGNMENT ASSIGNMENT ASSIGNMENT Q.3 Explain PL/SQL Block Structure. Answer :-Â The structure of a PL/SQL block is fundamental to writing and organizing code in Oracle’s Procedural Language/Structured Query Language (PL/SQL). PL/SQL blocks have a pre-defined structure in which the code is to be grouped. A PL/SQL block is divided into four main sections: Declaration, Execution, […]