PLSQL Programing -3

Hi, I continue to write PL / SQL. In the previous article, we have examined the simple block structure and made a small start, now we will continue with the function and procedure blocks. If you haven’t looked at my previous post, you can find it here.

The functions return a single value in the code, the code that will run in the function runs in the BEGIN-END block, I will refer to the data description later.

 

Function Block:

Syntax rule is  ,

FUNCTION function_name

RETURN data_type

IS

BEGIN

PL/SQL code

END

Procedure Block:

Unlike the function block, it can return more than one value to the result value. I will share your detailed narrative in future articles.

PROCEDURE prodecure_name

IS

BEGIN

PL/SQL code

END

PL/SQL Data Assignment :

As with any software language, we can assign specific values to variables in PL / SQL. For these operations we use certain symbols, for example in assignment operations: = with the symbol assignment process.

DECLARE

isim VARCHAR2(40);

BEGIN

isim:='MUSTAFA KEMAL ATATÜRK';

DBMS_OUTPUT.PUT_LINE(isim);

END
/

We can also use SQL statements (UPDATE-INSERT-DELETE-SELECT, etc.) in the code. Let’s continue with an example,

 

As you can see, in this way, we can add and run the inquiries into our plsql code. In the next post I’ll continue with the characters data types and variables,

 

 28 views today,  1 views in last 3 hour

Deniz Parlak

I am a technical author on IT Tutorial. I am working on Oracle and Mysql databases, I also work on Datawarehouse and Big Data.If you need help, please contact deniz.parlak@yahoo.com.

Leave a Reply