Tag Archives: Oracle PL/SQL

Hi Folks,   Conversion functions convert a value from one datatype to another. Generally, the form of the function names follows the convention datatype TO datatype. The NULL-related functions facilitate null handling. The encoding and decoding functions let you inspect and decode data in the database. The following list contains …

Hi Folks,   Functions are similar to operators in that they manipulate data items and return a result. Functions differ from operators in the format of their arguments. This format enables them to operate on zero, one, two, or more arguments. SQL functions are built into Oracle Database and are …

Hi Folks,   Functions are similar to operators in that they manipulate data items and return a result. Functions differ from operators in the format of their arguments. This format enables them to operate on zero, one, two, or more arguments. SQL functions are built into Oracle Database and are …

Hi folks,   In this post, I’m going to discuss 8 features that you must know to work with PL/SQL. These are structures that I have been using most in my years of experience with Oracle. I know that there is a tremendous amount of important peculiarities when discussing PL/SQL. …

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 …

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 …

Hi folks,   A procedure is a subprogram that performs a specific action. This feature is extremely important and vastly that we can use when developing in PL/SQL. Before invoking a procedure, you must declare and define it. You can either declare it first (with procedure_declaration) and then define it later …

Hi there,   One of the most used features of PL/SQL is the exception handling. Exceptions can arise from many different sources such as coding mistakes and design faults. Although we can’t predict all failures that might happen, we can use exception handlers predefined in our programs or create our …

Hi there,   Well, cursors are widely used when programming in PL/SQL, so it is better to master it. In this article, I’m going to cover the basic structure for explicit cursors in FOR LOOP statement.   Basically, these cursors have to be declared with a SELECT statement in the …

Hi,   Other structures when programming in PL/SQL are the FOR LOOP and CURSOR. In this post, I’m going to show how to use both of them together. Well, there are plenty of ways to create a loop in PL/SQL, one of the most common using an implicit cursor. This …

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 …

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 …