Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In this task, you will learn PL/SQL to create and use trigger, stored procedure, and function. For this exercise, you will use ORACLE. It is

image text in transcribed

In this task, you will learn PL/SQL to create and use trigger, stored procedure, and function. For this exercise, you will use ORACLE. It is assumed that you have set up your access to the Deakin ORACLE server. If you have not done so, please refer to the unit site for instructions to set up your access first. The help resources are also included in the task resources zip file for this task. Once you got access to your ORACLE database, check what tables are there in your database using the following command: SELECT table_name FROM user_tables; If there are tables called CUSTOMER and INVOICE, delete them using the following commands: DROP TABLE CUSTOMER; DROP TABLE INVOICE; Now, create two tables named CUSTOMER and INVOICE, and populate records using the ' 82D data.sql' script file provided in a zip file as part of the task resources. It will create the following tables for you. FIGURE P8.16 CH08_SIMPLECO DATABASETABLES Database name: Ch08_SimpleCo Table name: CUSTOMER Table name: INVOICE

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

Step: 3

blur-text-image

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

Object Databases The Essentials

Authors: Mary E. S. Loomis

1st Edition

020156341X, 978-0201563412

More Books

Students also viewed these Databases questions

Question

what are GAAPs? list and explain 10 GAAPs

Answered: 1 week ago

Question

4-6 Is there a digital divide? If so, why does it matter?

Answered: 1 week ago