O'Reilly logo

Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ by Dan Scott, George Baklarz, Paul C. Zikopoulos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Dynamically Determining Result Sets

All of the examples up to this point have assumed that the developer knows what data is to be retrieved from a table. The SELECT statement columns are known beforehand, so the application can be written to handle the number of columns being retrieved, along with the data types required to accept the column values. However, some applications need to dynamically determine the columns being retrieved based on user input. Consider also the case in which a SELECT * is issued against a table. When a table is created, the columns that are retrieved by a SELECT * might be known. But over time, the design of the table might change, so the order and even the number of columns might be different. Errors will result if ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required