Exercise 4 (Functions)

1. Display current date and 78 days after.

2. Display the current date in the following fashion.
Today's date is : Jan 4 1998.

3. Display Employee name and Job information from employee in the following fashion.
SMITH Works as CLERK.

4. Display all the information from department table where second character of city name is 'A'.

5. Display rowid, employee number from employee table.

6. Display rowid, row number, deptno from department table.

7. Display the last date in Feb-97

8. Display logged on user name in the following fashion.
Current User Name is : SCOTT

9. Display 'YOU ARE GOOD IN SQL' text as 'You Are Good In Sql' in a Select statement.

10. Display current date and 78 days before.