Write a pl/sql anonymous block that accepts an employee id, PL-SQL Programming

Based on the EMPLOYEE table created in Assignment #1, write a PL/SQL anonymous block that accepts an employee ID from the user input and finds whether the employee ID is in the EMPLOYEE table.

Example:

ACCEPT p_1 PROMPT 'Please enter the Employee ID:'

DECLARE

 -- Your statements

BEGIN

      -- Your statements

END;

Test your program to ensure that you get the following results.

Case 1)

2139_enter value.png

1075_dbms output.png

Posted Date: 4/1/2013 6:42:59 AM | Location : United States







Related Discussions:- Write a pl/sql anonymous block that accepts an employee id, Assignment Help, Ask Question on Write a pl/sql anonymous block that accepts an employee id, Get Answer, Expert's Help, Write a pl/sql anonymous block that accepts an employee id Discussions

Write discussion on Write a pl/sql anonymous block that accepts an employee id
Your posts are moderated
Related Questions
At times, Brewbean's has changed the id number for existing products. In the past, they have had to add a new product row with the new id to the BB_PRODUCT table, modify all the co

Initializing Objects: Till you initialize an object by calling the constructor for its object type, the object is automatically null. That is, the object itself is null, not me


Nested Tables versus Index-by Tables The Index-by tables and nested tables are just similar. For e.g.  They have similar structure and their individual elements are accessed in

Declaring and Initializing Objects: An object type is once defined and installed in the schema; you can use it to declare the objects in any PL/SQL, subprogram, block or packa

Scoping Within the similar scope, all the declared identifiers should be unique. So, even if their datatypes differ, the variables and parameters cannot share the similar name.

On occasion, some of Brewbean's customers mistakenly leave an item out of a basket already checked out, so they create a new basket containing the missing items. However, they requ

Keys in SQL SQL support for keys in the following respects: SQL does not require at least one key for every base table. If no key is explicitly declared, then KEY {ALL B

IF Statement The IF statement executes a series of statement conditionally. Whether the series is executed or not depends on the value of the Boolean expression. Syntax:

Defining and Declaring Collections To create the collections, you must define a collection type, and then declare the collections of that type. You can define the VARRAY types a