Results 1 to 6 of 6

Thread: Basics of PL/SQL programs

  1. #1
    Join Date
    Jan 2010
    Posts
    63

    Basics of PL/SQL programs

    I am as a new guy in oracle database. I need to grow my self in developer category and for this I need to learn the basics of SQL and PL/SQL.So tell me some beginner concepts of PL/SQL programs and made me available for the study related materials.I want to develop an small application which can be used with the database,So what are the tools to develop that applications resides in oracle database.

    I will be very thankful for your help.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,948

    Basics of PL/SQL programs

    Basics of PL/SQL programs :

    PL/SQL comes in the category of procedural language which is developed by Oracle experts as an extension to standard SQL which makes enable us to use the SQL with a proper logic to access the database.

    If you are going to develop either large or small application for oracle database then absolutely you would use oracle developer product which requires the PL/SQL implementation.

    That's why,The basic thing to develop an application for oracle database,you need to have the basic knowledge of PL/SQL language.

  3. #3
    Join Date
    May 2008
    Posts
    2,012

    Structure of PL/SQL programs

    Structure of PL/SQL programs :

    Upon the completion of introducing PL/SQL,now you are ready to construct the program in PL/SQL. The PL/SQL is referred as the block structured language.

    This follow the block level programming and contains different structures for different declarations.I am going to show you a syntax containing some blocks for different declaration :

    DECLARE
    variable_declarations /* The Declaration of variables would be performed
    BEGIN
    program_code /* Contains the main part of program
    EXCEPTION
    exception_handlers /* occurred errors are handle here
    END;

  4. #4
    Join Date
    Apr 2008
    Posts
    2,005

    Creating a program in PL/SQL

    Creating a program in PL/SQL :

    You can create a program after understanding the syntax and usage of PL/SQL . I am going to create a program which will show the value of variable :

    Code:
    DECLARE
     var   NUMBER;
    BEGIN
     var := 72600;
     dbms_output.put_line('The variable var = ');
     dbms_output.put_line(var);
    END;
    .The variable is declared in the DECLARE section and central logic of program is reside under the BEGIN and END.The value is assigned to the var variable with the help of ":="operator which is unique with all programming languages.

  5. #5
    Join Date
    May 2008
    Posts
    2,297

    Executing PL/SQL programs

    Executing PL/SQL programs :

    You can create the program in any editor but you have to compile your program on only SQL prompt.To do this you need follow some instructions as a steps :

    1- Start you SQL*PLUS from Start >Programs > Oracle >Ora92 >SQL*Plus.
    2- Login with the User name and Password .
    3- Type the SET SERVEROUTPUT ON at SQL prompt.
    4- Copy the codes form the editor and Paste it on SQL prompt and execute with pressing "/".
    5- The value of the variable would be appeared as a Output of the program.

  6. #6
    Join Date
    Oct 2005
    Posts
    2,393

    Tools to Develop the Application

    Tools to Develop the Application :

    When you are using PL/SQL and need to develop the applications.You can use the oracle provided tools to develop the applications.

    There are some tools of oracle which is built to create the application :

    1- SQL Developer
    2- SQL Developer Data Modeler
    3- Oracle Application Express
    4- Migration Technologies
    5- SQL*Plus

    To know more about the Oracle application development tools and downloads,you can visit on the oracle official site.

Similar Threads

  1. Basics to Mac management with SMP 7.1
    By Wayne R in forum Networking & Security
    Replies: 4
    Last Post: 28-05-2011, 07:50 PM
  2. Basics of My SQL
    By L 4 Life in forum Software Development
    Replies: 6
    Last Post: 01-03-2011, 09:13 AM
  3. PHP Course : Basics
    By Gyan Guru in forum Guides & Tutorials
    Replies: 1
    Last Post: 20-11-2008, 01:10 PM
  4. Java Programming Language Basics: Reflection Basics and Class Class
    By mayuri_gunjan in forum Guides & Tutorials
    Replies: 6
    Last Post: 29-08-2005, 12:04 AM
  5. Telnet Basics
    By the_last_rites in forum Guides & Tutorials
    Replies: 1
    Last Post: 19-06-2005, 11:35 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,711,683.95824 seconds with 17 queries