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.
```

Computer Science & Information Technology

You might also like to view...

Translate the brokerage into an SQL schema. Use the necessary SQL machinery to express all constraints speci?ed in the E-R model.

We will start with the diagram in Figure 4.30. In translating this E-R diagram, we choose to combine IsHandledBy with Account, WorksIn with Broker,and Office with ManagedBy. The rationale for these combinations is that in each case the entity type is a key role in the corresponding relationship. The reason why ManagedBy is combined with Office rather than Broker (which also happens to be a key role in the ManagedBy relationship) is that it is more likely for an o?ce to have a manager than it is for a broker to be a manager. Therefore, combining Office with ManagedBy into one table is unlikely to lead to many null values being stored with the Office table. In contrast, combining ManagedBy with Broker is likely to cause a situation where the value of the attribute Manages of the table Broker would be mostly NULL.

Computer Science & Information Technology

The Crosstab Query Wizard is the easiest way to create a crosstab query because all settings can be established within the wizard

Indicate whether the statement is true or false

Computer Science & Information Technology

A field in a table with an autonumber datatype is automatically populated with numbers ________ and those numbers do not change as records are added, deleted, or modified

A) differentiated B) exponentially C) in reverse order D) sequentially

Computer Science & Information Technology

If the Client Number field in a record always should display the two characters in the client number in uppercase, then the correct format for this field is ____.

A. < B. & C. % D. >

Computer Science & Information Technology