5.2.4 The nicer_but_slower_film_list View

The nicer_but_slower_film_list view contains a formatted view of the film table, with a comma-separated list of the film's actors.

The nicer_but_slower_film_list view differs from the film_list view in the list of actors. The lettercase of the actor names is adjusted so that the first letter of each name is capitalized, rather than having the name in all-caps.

As indicated in its name, the nicer_but_slower_film_list view performs additional processing and therefore takes longer to return data than the film_list view.

The nicer_but_slower_film_list view incorporates data from the film, category, film_category, actor, and film_actor tables.

Download this Manual
PDF (US Ltr) - 177.1Kb
PDF (A4) - 176.7Kb