CSDD1006 – Business Database Systems

Version 1.

  1. For the table,  Book, populate the table with 50 rows using SQL*Loader ( you can make up data yourself or use https://mockaroo.com/to generate data). Use a sequence to populate the column, ISBN. Populate any column (other than ISBN) with VARCHAR data type with lower case values.

 

  1. Create a user-defined function that accepts a string data type and converts the string to all upper case. This function should return the string all in upper case.

 

  1. Create a stored procedure that calls the function in step 2 and use the function to convert the columns in the Booktable that have VARCHAR data type to upper case. Don’t use the UPDATE command from SQL Developer since this is an exercise for you to use the Oracle PL/SQL procedures and functions.
  2. For the table,  Airports, populate the table with 50 rows using SQL*Loader ( you can make up data yourself or use https://mockaroo.com/to generate data). Use a sequence to populate the column, Air_code. Populate any column with VARCHAR data type with lower case values.

Version 3

 

  1. For the table,  Customer, populate the table with 50 rows using SQL*Loader ( you can make up data yourself or use https://mockaroo.com/to generate data). Use a sequence to populate the column, Customer_OID. Populate any column with VARCHAR data type with lower case values.

 

  1. Create a user-defined function that accepts a string data type and converts the string to all upper case. This function should the return the string all in upper case.

 

  1. Create a procedure that calls the function in step 2 and use the function to convert the columns in the Customer table that have VARCHAR data type to upper case. Don’t use the UPDATE command since this is an exercise for you to use the Oracle functionalities.