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
Parameter Default Values As the illustration below shows, you can initialize the IN parameters to the default values. In that way, you can pass various numbers of actual par

%ISOPEN The %ISOPEN yields TRUE if its cursor or cursor variable is open; or else, the %ISOPEN yields FALSE. In the illustration, you use the %ISOPEN to select an action:

Using Operator DEREF: You cannot navigate through refs within the PL/SQL procedural statements. Rather than, you should use the operator DEREF in the SQL statement. The DEREF

I need to write one function and one procedure to query a Oracle 10.1 DB using PL SQL. I have the schema and exact queries...along with work Ive started and a template to put the a

Logical Operators The logical operators AND, NOT, and OR follow the tri-state logic shown in table below. The AND and OR are binary operators; NOT is a unary operator.

Parameter & Keyword Description: function_name: The user-defined function is identifying by that keyword. parameter_name: This identifies the formal parameter that

Architecture The PL/SQL run-time system and compilation is a technology, not an independent product. Consider this technology as an engine that compiles and executes the PL/SQL

LOB Types The large object (LOB) datatypes like BFILE, BLOB, CLOB, and NCLOB store the blocks of unstructured data (like graphic images, text, video clips, and sound waveforms)

Keyword and Parameter Description: label_name: This is an undeclared identifier which optionally labels the PL/SQL block. When used, label_name should be enclosed by the do

INSERT Statement The INSERT statement adds fresh rows of data to the specified database table or view. Syntax: