Scribd Logo
Upload

Welcome to Scribd!

  • 28 views

    Database Programming With PL/SQL 1-3: Practice Activities

    Uploaded by

    Adi Wibowo
    QUIZ

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Database Programming With PL/SQL 1-3: Practice Activities

    Uploaded by

    Adi Wibowo
    28 views2 pages
    QUIZ

    Original Title

    Tugas 1

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    QUIZ

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    28 views2 pages

    Database Programming With PL/SQL 1-3: Practice Activities

    Uploaded by

    Adi Wibowo
    QUIZ

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    academy.oracle.

    com

    Database Programming with PL/SQL


    1-3: Creating PL/SQL Blocks
    Practice Activities
    Vocabulary
    Identify the vocabulary word for each definition below:

    Unnamed blocks of code not stored in the database and do not exist
    after they are executed

    A program that computes and returns a single value

    Named PL/SQL blocks that are stored in the database and can be de-
    clared as procedures or functions

    Software that checks and translates programs written in high-level pro-


    gramming languages into binary code to execute

    A program that performs an action, but does not have to return a value

    Try It / Solve It
    1. Complete the following chart defining the syntactical requirements for a PL/SQL block:

    Describe what is included in


    Optional or Mandatory?
    this section

    DECLARE

    BEGIN

    EXCEPTION

    END;

    Copyright © 2019, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their
    respective owners.
    2

    2. Which of the following PL/SQL blocks executes successfully? For the blocks that fail, explain why
    they fail
    A. BEGIN
    END;

    B. DECLARE
    amount INTEGER(10);
    END;

    C. DECLARE
    BEGIN
    END;

    D. DECLARE
    amount NUMBER(10);
    BEGIN
    DBMS_OUTPUT.PUT_LINE(amount);
    END;

    3. Fill in the blanks:

    A. PL/SQL blocks that have no names are called __________________.

    B. _______________ and _______________ are named blocks and are stored in the database.

    4. In Application Express, create and execute a simple anonymous block that outputs “Hello World.”

    5. Create and execute a simple anonymous block that does the following:

    • Declares a variable of datatype DATE and populates it with the date that is six months from
    today

    • Outputs “In six months, the date will be: <insert date>.”

    Copyright © 2019, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their
    respective owners.

    You might also like