Answered step by step
Verified Expert Solution
Question
1 Approved Answer
It's a data base program to develop in SQL No need of that u have to take it randomly and as per the question requires
It's a data base program to develop in SQL
No need of that u have to take it randomly and as per the question requires
Hey bro, we use this application do to oracle database Its database systems Im currently doing PL/SQL using oracle and I needed few answers for certain tasks
Task 3: write a stored function called init_func to read a text file containing the transactions and then insert them into the transaction table. Write another stored function called order_func which reads through transaction table and fills the order and item tables. The function should return true if it finishes without a problem otherwise it should print appropriate message by capturing relevant exceptions. You need to think about what exceptions could happen and take care of them in exception handling. The transaction id is a generated sequence. For this task you need to create a comma separated text file that each row in it corresponds to a row in transactions table. This text file contains: 30 transactions (which includes 15 orders, each with 2 items, 3 orders for each customer) Oracle VMG VirtualBox Task 3: write a stored function called init_func to read a text file containing the transactions and then insert them into the transaction table. Write another stored function called order_func which reads through transaction table and fills the order and item tables. The function should return true if it finishes without a problem otherwise it should print appropriate message by capturing relevant exceptions. You need to think about what exceptions could happen and take care of them in exception handling. The transaction id is a generated sequence. For this task you need to create a comma separated text file that each row in it corresponds to a row in transactions table. This text file contains: 30 transactions (which includes 15 orders, each with 2 items, 3 orders for each customer) Oracle VMG VirtualBoxStep 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