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
Assignment of Variable - Updating a Variable Syntax: SET SN = SID ('S2'); This can obviously be read as "set the variable SN to be equal in value to SID ( 'S2' )".

Parameter and Keyword Description: collection_name: This keyword identifies the index-by table, nested table, or varray formerly declared within the present scope. cu

PITS Depressions in secondary cell wall is called pit. A pit present on the free cell wall surface without its partner is called Blind pit. It consists of 2 parts -

Name Resolution In potentially uncertain SQL statements, the names of the database columns take precedence over the names of the local variables and formal parameters. For e.g.

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

Parameter and Keyword Description: label_name: This is an undeclared identifier which optionally labels a loop. When used, the label_name should be enclosed by double ang

Example of NOT EXISTS Operator - SQL Example is a translation into SQL of the corresponding example, which is included there merely to show that for any scalar comparison the

Inner Join We have learned how to retrieve data from one table by using SELECT statement. But, as we have learned, normalized relational databases mean the data is spread betw

DBMS_OUTPUT: The Package DBMS_OUTPUT enables you to display output from the PL/SQL subprograms and blocks, that makes it easier to test and debug them. The procedure put_ line

Consider the following set of database tables (same tables from Assignment 6-1). Please take note of foreign keys (most of them carry the same names as the corresponding primary ke