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)

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

Ask an Expert

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

Write your message here..

Related Questions

Python function, This task involves developing some functions that extract ... 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, Biconditional - SQL The biconditional p ↔ q can b... 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

Theory of panspermia - origin of life, THEO R Y OF PANSPERMIA - Arrh... 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

Sql query on hospital database, Perform the following queries on the Hospit... 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 - sql pseudocolumns, ROWNUM The ROWNUM returns a number represe... 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

Sql query for testing triggers and stored procedures , Description: Dem... 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, Effects of NULL for union - SQL The ... 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 - collection method, Using PRIOR and NEXT The PRI... 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

Difference between ttitle and btitle, TTITLE and BTITLE are commands in Pl-... 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

Help, help help