You have tagged this question SQL Server, but the error message does not likely anything from SQL Server. Furthermore, I notice the function nvl
, this is not a function in SQL Server. With help of Google I found that this is an Oracle function. It may be the same as isnull
in SQL Server.
As for your list of requirement, we generally don't like to help with class assignments and similar here. We can help with specific aspects of your problem, but it would be wrong to write the code for you - then you would not learn anything.