Assignment: Create Oracle table and query and maintain it

All of these questions need to be done using the table you created.
Remember, when I say single row function, I mean the functions we have looked at so far that return specific rows/records.

Create an Oracle table with at minimum a varchar2 field, a char field, a number field with decimal places, a number field without decimal places, and a date field.
Show me a description of the table.
Put several records into the table.
Show me all data in the table.
Add a record to the table.
Change a record on the table.
Delete a record from the table.
Alter the structure of the table by adding a field that contains a name in the format last, first.
Alter the structure of the table by adding characters to the varchar2 field.
Do a query that involves a condA AND either condB OR condC structure.
Do a query that involves a condA AND condB and a condC that stands alone.
Do a query using distinct.
Do a query using a calculation and give the field an alias.
Do a query using a single row function to do character manipulation.
Do a query using a different single row function to do character manipulation.
Do a query using a single row numeric function.
Do a query using a different single row numeric function.
Do a query using a single row date function.
Do a query using a different single row date function.
Do a query that involves a function within a function.
Do a query that involves formatting.
Do a query that involves another kind of formatting.
Do a query using a sort.
Do a query using a nested sort.
Do a query using single row functions that flip the name so that it reads first last instead of last, first.