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, […]
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 / […]