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.
School = {'1 A': 28,
'1 Б': 29,
'1 В': 29,
'2 А': 27,
'2 Б': 30}
print(School)
# for key, val in list(School.items()):
# print(f'{key} - {val}') - Альтернативный вариант вывода словаря
num = input('Введите номер класса')
if num not in School.keys():
print('Такого класса не существует')
else:
print(f'В классе {num}: {School[num]}')
# Не понял суть третьего задания
# Поэтому, запрашиваю ввод данных от пользователя
School['1 A'] = int(input('Сколько человек теперь в классе 1 A?'))
School['1 Б'] = int(input('Сколько человек теперь в классе 1 Б?'))
School['2 A'] = int(input('Сколько человек теперь в классе 2 A?'))
print(School)
# for key, val in list(School.items()):
# print(f'{key} - {val}') - Альтернативный вариант вывода словаря