PL/SQL is a modern, block-structured programming language. It provides several features that make developing powerful database applications very convenient. For example, PL/SQL provides procedural constructs, such as loops and conditional statements, that are not available in standard SQL.
You can directly enter SQL data manipulation language (DML) statements inside PL/SQL blocks, and you can use procedures supplied by Oracle to perform data definition language (DDL) statements.
PL/SQL code runs on the server, so using PL/SQL lets you centralize significant parts of your database applications for increased maintainability and security. It also enables you to achieve a significant reduction of network overhead in client/server applications.
#include <iostream>
#include <random>
#define INT_MIN -50
#define INT_MAX 50
int main()
{
setlocale(0, "ru");
std::cout << "Введите размер массива: ";
unsigned size{};
std::cin >> size;
int* parr{ new int[size] };
std::default_random_engine generator;
std::uniform_int_distribution<int> distribution(INT_MIN, INT_MAX);
for (unsigned i = 0u; i < size; i++)
{
parr[i] = distribution(generator);
std::cout << parr[i] << '\t';
}
std::cout << "\nВведите число: ";
int num{}, sum{}, min = INT_MAX;
std::cin >> num;
for (unsigned i = 0u; i < size; i++)
{
if (!(parr[i] % 5) && parr[i] > num)
sum += parr[i];
if (parr[i] > 0 && min > parr[i])
min = parr[i];
}
std::cout << "\nСумма чисел больших введенного числа и кратных 5: " << sum << std::endl;
std::cout << "Наименьшее число среди положительных: " << min << std::endl;
delete[] parr;
return 0;
}