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 VirtualBox