Scribd
Upload
22 views2 pages

PL/SQL Programming Exercises Guide

The document outlines a series of PL/SQL programming exercises, each focusing on different programming concepts such as checking odd/even numbers, printing multiplication tables, using loops, conditional statements, and exceptions. It includes tasks for implementing stored procedures, triggers, and string manipulation. Each slip represents a specific programming challenge to enhance understanding of PL/SQL functionalities.

Uploaded by

rohitshembde87
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
22 views2 pages

PL/SQL Programming Exercises Guide

The document outlines a series of PL/SQL programming exercises, each focusing on different programming concepts such as checking odd/even numbers, printing multiplication tables, using loops, conditional statements, and exceptions. It includes tasks for implementing stored procedures, triggers, and string manipulation. Each slip represents a specific programming challenge to enhance understanding of PL/SQL functionalities.

Uploaded by

rohitshembde87
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Slip 1

Write a PL/SQL program to check whether number is odd or


even.

Slip2
Write a PL/SQL program to print table of numbers.

Slip3
Write a PL/SQL program using simple loop.

Slip4
Write a PL/SQL program using if then elsif then else statement

Slip5
Write a PL/SQL program to print maximum number using
functions.

Slip 6
Write a PL/SQL program to print ‘Welcome BSC CS/DS AND AI’
using stored procedures

Slip 7
Write a PL/SQL program using Implicit Cursor.

Slip 8
Write a PL/SQL program using Trigger.

Slip 9
Write a PL/SQL program using System defined
exception(ZERO_DIVIDE)

Slip 10
Write a PL/SQL program using User defined exception.

Slip 11
Write a PL/SQL program using %Type attribute

Slip 12
Write a PL/SQL program using While loop.

Slip 13
Write a PL/SQL program using Explicit Cursor.

Slip 14
Write a PL/SQL program using Case Statement.

Slip 15
Write a PL/SQL program for string Concatenation.
1st String: Hello
2nd String: World

You might also like