Oracle functionalities

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.

CSDD1006 – Business Database Systems Version 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. Create a […]

Scroll to top