Jump to content

[ Pl/sql ] - Simple Pl/sql Statement.


Recommended Posts

Hello everyone, today we will be looking at PL/SQL the basic syntax into the SQL programming language.

PL-SQL is
a block-structure language.. this means that the actual program that you write is splitted into diffirent parts.

Every PL/SQL block is split into 3 parts:

  • Declarations
  • Executable Commands
  • Exception Handling

The declaration section will start with the keyword DECLARE this section is not required as you don't always need variables in your PL/SQL program.

The Executable section is enclosed between The BEGIN and the ENDthis section is required as this is the core of your SQL program.

A simple example of a PL/SQL program:

 
DECLARE
message varchar2(20) := 'Hello MaxCheaters;
BEGIN
dbms_output.put_line(message);
END;
 

As you see in the exampe, we decalre a variabele called message as a varchar with a length of 20.
the := means that your gonna give the variabele a value, 'Hello MaxCheaters' in our example.
 
Dbms_output.put_line();
 
dbms_output.put_line(); will print a line, as of our example, the dbms_output.put_line() has a variabele passed within the () which holds our text.
 
The dbms will show 'Hello MaxCheaters' in our sql terminal.
 
You can compare the dbms_output.put_line() with a System.out.println() or a Console.writeLine(); in java or C#.
 
Cheers!

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Posts

    • Psychic Readings | Astrology | Love Spells | Black Magic spells | Witchcraft Spells | Spell Caster | Voodoo spells | Marriage spells | Divorce spells | Attraction spells | Bring back lost lover spells REUNITE WITH AN EX LOVER IN 72 HOURS If your lover is gone, don't be desperate anymore! You are a few clicks away from a prompt resolution of your problem: We will our spiritual powers to bring him/her back Let us show you our method with zero chances of rejection. Don't waste your precious time; get your lover back NOW! MAKE HIM/HER LOVE ME  Don't wait for the deluge and make him or her love you now. This service will create a great alchemy between this person and you. In just a few weeks, you can make the person you dream of falling in love with you. We recommend you to combine this service with a Marriage ritual if you want this person to commit you. BREAK UP A RELATIONSHIP The perfect service to break up a relationship you don't think legitimate. Your lover has gone with someone else Don't hesitate to break them up as this ritual and prayer is very powerful and will give very good results in a few weeks only. STOP A DIVORCE NOW  Order this service now to reinforce the bonds of your relationship and save your marriage. This service will make him/her realize that a divorce would be a mistake and will strengthen love and passion. With permanent results, this service will guarantee a long lasting marriage and will make you happy. FAITHFULNESS  Your partner cheats on you? This love ritual is definitely the one you need!  LOVE CHARMS   
    • Psychic Readings | Astrology | Love Spells | Black Magic spells | Witchcraft Spells | Spell Caster | Voodoo spells | Marriage spells | Divorce spells | Attraction spells | Bring back lost lover spells REUNITE WITH AN EX LOVER IN 72 HOURS If your lover is gone, don't be desperate anymore! You are a few clicks away from a prompt resolution of your problem: We will our spiritual powers to bring him/her back Let us show you our method with zero chances of rejection. Don't waste your precious time; get your lover back NOW! MAKE HIM/HER LOVE ME  Don't wait for the deluge and make him or her love you now. This service will create a great alchemy between this person and you. In just a few weeks, you can make the person you dream of falling in love with you. We recommend you to combine this service with a Marriage ritual if you want this person to commit you. BREAK UP A RELATIONSHIP The perfect service to break up a relationship you don't think legitimate. Your lover has gone with someone else Don't hesitate to break them up as this ritual and prayer is very powerful and will give very good results in a few weeks only. STOP A DIVORCE NOW  Order this service now to reinforce the bonds of your relationship and save your marriage. This service will make him/her realize that a divorce would be a mistake and will strengthen love and passion. With permanent results, this service will guarantee a long lasting marriage and will make you happy. FAITHFULNESS  Your partner cheats on you? This love ritual is definitely the one you need!  LOVE CHARMS   
    • Psychic Readings | Astrology | Love Spells | Black Magic spells | Witchcraft Spells | Spell Caster | Voodoo spells | Marriage spells | Divorce spells | Attraction spells | Bring back lost lover spells REUNITE WITH AN EX LOVER IN 72 HOURS If your lover is gone, don't be desperate anymore! You are a few clicks away from a prompt resolution of your problem: We will our spiritual powers to bring him/her back Let us show you our method with zero chances of rejection. Don't waste your precious time; get your lover back NOW! MAKE HIM/HER LOVE ME  Don't wait for the deluge and make him or her love you now. This service will create a great alchemy between this person and you. In just a few weeks, you can make the person you dream of falling in love with you. We recommend you to combine this service with a Marriage ritual if you want this person to commit you. BREAK UP A RELATIONSHIP The perfect service to break up a relationship you don't think legitimate. Your lover has gone with someone else Don't hesitate to break them up as this ritual and prayer is very powerful and will give very good results in a few weeks only. STOP A DIVORCE NOW  Order this service now to reinforce the bonds of your relationship and save your marriage. This service will make him/her realize that a divorce would be a mistake and will strengthen love and passion. With permanent results, this service will guarantee a long lasting marriage and will make you happy. FAITHFULNESS  Your partner cheats on you? This love ritual is definitely the one you need!  LOVE CHARMS   
    • Psychic Readings | Astrology | Love Spells | Black Magic spells | Witchcraft Spells | Spell Caster | Voodoo spells | Marriage spells | Divorce spells | Attraction spells | Bring back lost lover spells REUNITE WITH AN EX LOVER IN 72 HOURS If your lover is gone, don't be desperate anymore! You are a few clicks away from a prompt resolution of your problem: We will our spiritual powers to bring him/her back Let us show you our method with zero chances of rejection. Don't waste your precious time; get your lover back NOW! MAKE HIM/HER LOVE ME  Don't wait for the deluge and make him or her love you now. This service will create a great alchemy between this person and you. In just a few weeks, you can make the person you dream of falling in love with you. We recommend you to combine this service with a Marriage ritual if you want this person to commit you. BREAK UP A RELATIONSHIP The perfect service to break up a relationship you don't think legitimate. Your lover has gone with someone else Don't hesitate to break them up as this ritual and prayer is very powerful and will give very good results in a few weeks only. STOP A DIVORCE NOW  Order this service now to reinforce the bonds of your relationship and save your marriage. This service will make him/her realize that a divorce would be a mistake and will strengthen love and passion. With permanent results, this service will guarantee a long lasting marriage and will make you happy. FAITHFULNESS  Your partner cheats on you? This love ritual is definitely the one you need!  LOVE CHARMS   
    • Psychic Readings | Astrology | Love Spells | Black Magic spells | Witchcraft Spells | Spell Caster | Voodoo spells | Marriage spells | Divorce spells | Attraction spells | Bring back lost lover spells REUNITE WITH AN EX LOVER IN 72 HOURS If your lover is gone, don't be desperate anymore! You are a few clicks away from a prompt resolution of your problem: We will our spiritual powers to bring him/her back Let us show you our method with zero chances of rejection. Don't waste your precious time; get your lover back NOW! MAKE HIM/HER LOVE ME  Don't wait for the deluge and make him or her love you now. This service will create a great alchemy between this person and you. In just a few weeks, you can make the person you dream of falling in love with you. We recommend you to combine this service with a Marriage ritual if you want this person to commit you. BREAK UP A RELATIONSHIP The perfect service to break up a relationship you don't think legitimate. Your lover has gone with someone else Don't hesitate to break them up as this ritual and prayer is very powerful and will give very good results in a few weeks only. STOP A DIVORCE NOW  Order this service now to reinforce the bonds of your relationship and save your marriage. This service will make him/her realize that a divorce would be a mistake and will strengthen love and passion. With permanent results, this service will guarantee a long lasting marriage and will make you happy. FAITHFULNESS  Your partner cheats on you? This love ritual is definitely the one you need!  LOVE CHARMS   
  • Topics

×
×
  • Create New...