Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a stored procedure named Find_Employee . This procedure gets an employee number and prints the following employee information: First name Last name Email Phone

  1. Create a stored procedure named Find_Employee. This procedure gets an employee number and prints the following employee information:

First name

Last name

Email

Phone

Hire date

Job title

The procedure gets a value as the p_empid of type NUMBER.

See the following example for employee# of 107:

First name: Summer

Last name: Payn

Email: summer.payne@example.com

Phone: 515.123.8181

Hire date: 07-JUN-16

Job title: Public Accountant

The procedure displays a proper error message if any error occurs.

Show testing with one invalid employee Id and one valid Id.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database 10g Insider Solutions

Authors: Arun R. Kumar, John Kanagaraj, Richard Stroupe

1st Edition

0672327910, 978-0672327919

More Books

Students also viewed these Databases questions

Question

What is Environment and Ecology? Explain with examples

Answered: 1 week ago

Question

1. Explain the 2nd world war. 2. Who is the father of history?

Answered: 1 week ago