Display all student names and birth dates. Display birth dates with the format ‘20 OCTOBER, 1970’.
Write queries for the following. (Use tables created in Chapter 4 Lab Activity.)
```
SQL> SELECT Last, First, TO_CHAR(BirthDate, 'DD MONTH, YYYY')
2 FROM student;
LAST FIRST TO_CHAR(BIRTHDATE,
--------------- --------------- ------------------
Diaz Jose 12 FEBRUARY , 1983
Tyler Mickey 18 MARCH , 1984
Patel Rajesh 12 DECEMBER , 1985
Rickles Deborah 20 OCTOBER , 1970
Lee Brian 28 NOVEMBER , 1985
Khan Amir 07 JULY , 1984
6 rows selected.
```
You might also like to view...
A computer has a write-protected BIOS. What can you do to update the Flash BIOS?
A) Change the setting of a motherboard jumper or switch to remove the write protection. B) Replace the BIOS chip with another containing the latest version. C) Use the copy command to transfer the updated information from the CMOS to the BIOS. D) Reverse the chip in the socket to allow it to be updated.
COGNITIVE ASSESSMENT If a dog is identified by scanning the shoulder or neck of the animal, what provides the information about the dog?
A. an animal ID processor B. an ALU C. a microchip D. a tattooed ID number identified by the scanning device