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
This task involves developing some functions that extract data from an SQL database. The scenario is that a company which owns an online vehicle search website wants to generate so

Biconditional - SQL The biconditional p ↔ q can be expressed in Tutorial D by p = q and the same is true of SQL. The question then arises as to whether, in SQL, p = q is equiv

THEO R Y OF PANSPERMIA - Arrhenius (1908) postulated the cosmic panspermia theory that claims that organisms existed throughout the universe, and their spores, etc., could

Perform the following queries on the Hospital1.DB using SQL Anywhere (START EARLY!). a. Which patients have purchased the drug "Tylenol"? List the names and addresses. Arrange the

ROWNUM The ROWNUM returns a number representing the order in which a row was selected from the table. The first row selected has a ROWNUM of 1; the second row has a ROWNUM of

Description: Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that pr

Effects of NULL for union - SQL The treatment of NULL in invocations of EXCEPT is as for UNION. This is different from its treatment in those of NOT IN and quantified compari

Using PRIOR and NEXT The PRIOR(n) returns the index number that precede index n in a collection. The NEXT(n) returns the index number which succeed the index n. If n has no pr

TTITLE and BTITLE are commands in Pl-SQL to control report headings and footers. This Ttitle & Btitle are mainly used on creating SQL*PLUS report. Ttitle is used for toptitle headi