PL/SQL Program to Multiply Two Numbers: A Beginner-Friendly Guide

by

Introduction

Multiplication is one of the most essential arithmetic operations used in programming, databases, and real-world applications. In this guide, we’ll walk through a simple yet powerful PL/SQL program that multiplies two numbers.

This tutorial is designed for both beginners and experienced developers, helping you understand the core logic behind multiplication in PL/SQL while ensuring best coding practices.

By following this guide, you will:
✅ Learn how to declare and use variables in PL/SQL
✅ Understand user input handling in SQL*Plus
✅ See how multiplication logic is implemented in PL/SQL
✅ Explore real-world applications of multiplication in databases

Let’s dive in!

PL/SQL Program to Multiply Two Numbers

sqlCopyEditDECLARE
  num1 NUMBER;
  num2 NUMBER;
  result NUMBER;
BEGIN
  -- Accept user input for both numbers
  num1 := &num1;
  num2 := &num2;

  -- Perform the multiplication
  result := num1 * num2;

  -- Display the output
  DBMS_OUTPUT.PUT_LINE('Multiplication of ' || num1 || ' and ' || num2 || ' is: ' || result);
END;
/

Explanation of the Code

1. Declaration Section

This section initializes three variables:

  • num1 – Stores the first number
  • num2 – Stores the second number
  • result – Stores the multiplication output

2. Execution Block (BEGIN…END)

  • The program prompts the user to enter two numbers dynamically.
  • The multiplication operation is performed:sqlCopyEditresult := num1 * num2;
  • The output is displayed using:sqlCopyEditDBMS_OUTPUT.PUT_LINE(...)

Example Output

yamlCopyEditEnter value for num1: 8
Enter value for num2: 5
Multiplication of 8 and 5 is: 40

Why Use This PL/SQL Multiplication Program?

🔹 Beginner-Friendly: Simple syntax makes it easy for new learners.
🔹 User Input Handling: Accepts dynamic values using substitution variables (&num1, &num2).
🔹 Optimized Execution: PL/SQL processes arithmetic operations efficiently.
🔹 Applicable in Real-World Scenarios: Multiplication is widely used in finance, inventory management, salary calculations, and data analytics.

How to Run This Program in SQL*Plus?

Running this PL/SQL program is straightforward. Follow these steps:

Step 1: Open SQL*Plus or any PL/SQL-supported tool like Oracle SQL Developer.

Step 2: Copy and paste the provided PL/SQL block into the editor.

Step 3: Press Enter and provide input when prompted.

Step 4: View the multiplication result on the console.

🔹 Alternative: You can also modify this script to use ACCEPT statements for better input handling.

Real-World Applications of Multiplication in PL/SQL

PL/SQL multiplication logic is used in many real-world scenarios, such as:

🔹 Invoice Calculations – Compute total cost (price × quantity).
🔹 Salary Processing – Calculate gross pay (hours worked × pay rate).
🔹 Financial Computations – Determine compound interest calculations.
🔹 Stock & Inventory Management – Track available stock levels in a database-driven system.

Final Thoughts

This simple yet powerful PL/SQL program helps you understand multiplication logic and how to handle user input dynamically.

💡 What’s Next? Try modifying this program to perform division, addition, or subtraction in PL/SQL!

💬 Have questions? Discuss your PL/SQL queries in our SQL Community Forum!

🔗 Join the SQL Queries Community: SQL Forum

For more in-depth SQL programming tutorials, check out this helpful guide on PL/SQL Procedures: Learn PL/SQL Procedures