PL/SQL Code Examples: Procedures, Functions, and Cursors
PL/SQL Code Examples
Always do:
set serveroutput on;declare a number; b number; suma number;begina:=5;b:=4;suma:=a+b;dbms_output.put_line(suma);end; set serveroutput on declare a number; b number; nom varchar2(40); suma number; begin nom:='&nombre'; a:=&numero1; b:=&numero2; suma:=a+b; dbms_output.put_line(nom); dbms_output.put_line('The sum is: '||suma); end;declare a number; b CCNA Security Commands: Configuration and Best Practices
Chapter 2: CCNA Security
******** MD5 Authentication Configuration ********
-
Configure OSPF MD5 Authentication for all routers in area 0:
R1(config)# router ospf 1
R1(config-router)# area 0 authentication message-digest
R1(config)# interface s0/0/0
R1(config-if)# ip ospf message-digest-key 1 md5 MD5pa55(Password) -
Configure NTP:
R1(config)# ntp server 192.168.0.1
R1(config)# ntp authenticate
R1(config)# ntp trusted-key 1
R1(config)# ntp authentication-key 1 md5 NTPpa55(Password) - Configure
Industrial Equipment: Principles, Construction, and Uses
Ball Mill
Principle of Ball Mill
Ball mills operate on the principle of impact and attrition. The mill uses a combination of impact and friction to grind and mix materials.
Principle of Hammer Mill
Hammer mills operate on the principle of impact and attrition. The mill uses a series of hammers to crush and grind the material into a smaller size.
Construction of Ball Mill
- A cylindrical or conical shell made of steel or other materials, which contains the grinding media.
- Steel or ceramic balls, pebbles,
Mastering Data Manipulation with dplyr and reshape2 in R
This document demonstrates data manipulation techniques using the dplyr and reshape2 packages in R.
Introduction to dplyr
dplyr is much faster and easier to read than base R. Here are some of its key functions:
select(): Selects column variables based on their names.filter(): Filters rows based on their values.arrange(): Changes the ordering of the rows.summarize(): Reduces multiple values down to a single summary.mutate(): Creates columns that are functions of existing variables.
Let’s explore these
Read MoreRankine Cycle in Steam Power Plants: Diagrams & Formulas
A steam power plant converts heat energy into mechanical work by utilizing the Rankine cycle, which involves processes such as compression, heat addition, expansion, and heat rejection. Below, we will explain the P-V, T-S, and H-S diagrams of a steam power plant, the working of each cycle process, and the relevant formulas.
1. P-V Diagram (Pressure-Volume Diagram) for Steam Power Plants
The P-V diagram shows the relationship between pressure and volume during the Rankine cycle in a steam power plant.
Read MoreMovie Camera and Projector: Essential Components
The Essential Components of a Movie Camera
The essential components of a movie camera are:
A) The Objective
It is the camera’s optical component that carries the light to the film, forming the image in the focal plane. We will not talk more about them since they have been explained already in unit 3, but remember that you have two basic controls: focus and diaphragm.
B) The Viewfinder
It is the optical component that allows to point the camera and compose the picture. There are two types of viewers:
- Optical