Skip to content
/ PL-SQL-fundamentals Public

This repo contains the code for various functionalities in PL/SQL, and in particular Oracle PL/SQL

1 star 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

IsaacMwendwa/PL-SQL-fundamentals

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

96 Commits
README.md
README.md
 
 
anonymous-block.sql
anonymous-block.sql
 
 
cursor_for_loop.sql
cursor_for_loop.sql
 
 
cursors.sql
cursors.sql
 
 
exceptions.sql
exceptions.sql
 
 
functions.sql
functions.sql
 
 
implicit_statement_results.sql
implicit_statement_results.sql
 
 
iterative_processing.sql
iterative_processing.sql
 
 
other_exceptions.sql
other_exceptions.sql
 
 
parameterized_cursor.sql
parameterized_cursor.sql
 
 
procedures.sql
procedures.sql
 
 
raise_exceptions.sql
raise_exceptions.sql
 
 
records.sql
records.sql
 
 
select_into.sql
select_into.sql
 
 
variables.sql
variables.sql
 
 

Repository files navigation

PL-SQL-fundamentals

Table of Contents

Introduction

This repo contains the code for various functionalities in PL/SQL, and in particular Oracle PL/SQL

Prerequisites

You need to have the following software installed:

  • Oracle Database XE (preferably 18c Edition)
  • Oracle SQL Developer
  • Oracle SQL* Plus

Installation

Follow this guide to set up the sample database for practice

Usage

Open the files and run the statements in Oracle SQL Developer

Authors

github follow

Acknowledgements

Oracle Tutorial.com

About

This repo contains the code for various functionalities in PL/SQL, and in particular Oracle PL/SQL

Topics

oracle-database pl-sql pl-sql-script oracle-pl-sql

Resources

Readme
Activity

Stars

1 star

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published