Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started