SQL Queries and PL/SQL Functions Examples

Posted by admin on Jan 10, 2025 in Computing and Communications | 0 comments

SELECT s.nombre "NOMBRE SERIE"
FROM SERIE s
WHERE s.ID_CODSERIE = (
  SELECT e.SERIE_ID_CODSERIE
  FROM EPISODIO e
  WHERE e.NOMBRE = 'la manzana madura'
);

SELECT a.nombre "NOMBRE ACTOR"
FROM actor a
WHERE a.ID_ACTOR = (
  SELECT p.ACTOR_ID_ACTOR
  FROM personaje p
  WHERE p.NOMBRE = 'Sheldon'
);

SELECT a.NOMBRE "NOMBRE ACTOR", a.F_NAC "FECHA DE NACIMIENTO"
FROM ACTOR a
INNER JOIN GANA g ON a.ID_ACTOR 

Oracle Database Architecture: Components and Structure

Posted by admin on Jan 10, 2025 in Computing and Communications | 0 comments

Key Components of an Oracle Database

• Control File: Contains information about physical files, the name of the database, block sizes, and information for recovery. Control files are required to open the database.
• Data File: Contains information that records end-user applications.
• Redo Log: Records all changes made to the database and the recovery status.
• Pfile and Spfile: These are settings of the System Global Area (SGA) and optional features of Oracle background processes.

Oracle Instance and Server

• An

Understanding Isometries in R2 and R3: A Comprehensive Breakdown

Posted by admin on Jan 10, 2025 in Computing and Communications | 0 comments

Understanding Isometries in R2

Theory

It retains the standard distance i = A · A^T = Id. Det = +1 or -1.

Vector fix: v ∈ P associates at v ∈ P 1SI F ∈ G = T_v, then F o G also. Det H = Det G · Det F.

Equations: T_v(x, y) = (x, y). Base service: T_v = C_ne · T_n · C_ne^-1

Note: A * I must be symmetrical.

CNE

1. Find a point on the axis or plane (one that satisfies the equation).
2. From the equation equal to 0, if you are caught, separate subjects. If not equal to 0, they are roofed and left all depending on