Tag Archives: Oracle PL/SQL

PL/SQL For Practitioners – #7 Packages

Hi folks,   A package is a schema object that groups logically related PL/SQL types, variables, constants, subprograms, cursors, and exceptions. A package always has a specification, which declares the public items that can be referenced from outside the package.  If the public items include cursors or subprograms, then the package must also …

Read More »

PL/SQL For Practitioners – #6 Functions

Hi folks,   A user-defined function is a set of PL/SQL statements you can call by name. Functions are very similar to procedures, except that a function returns a value to the environment in which it is called.   Syntax CREATE OR REPLACE FUNCTION <name> (<paramete1_name parameter1_type, .. ,parametern_name parametern_type>) RETURN …

Read More »

PL/SQL For Practitioners – #1 Block Structure

Hi,   PL/SQL is a block-structured language whose code is organized into blocks. A PL/SQL block consists of three sections, declaration (non-required), executable (required), and exception-handling (non-required) sections. All kinds of structures that a developer might create in PL/SQL such as procedures, functions, packages, and types are based on this …

Read More »

PL/SQL Programlama -1

Merhaba, yeni bir yazı serisine başlıyorum. Bu seride PL/SQL ile örnekler yapıp nasıl kullanıldığına ve neler yapıldığına değineceğim.     PL/SQL, Oracle firması tarafından geliştirilmiş SQL sorgu dilinin yazılım dillerine ait özelliklerinin eklenmesiyle oluşturulmuş bir programlama dilidir. Prosedürel bir yapıda olduğundan kod içerisinde SQL’in yapamayacaklarını yapabilmektedir.     Resimde PL/SQL …

Read More »