apache > db
Apache DB Project
 
Font size:      

Creating Empty Queries

Creating Empty Queries

Developers using Derby in existing applications might need to create "empty" queries with the right result shape for filling in bits of functionality Derby does not supply. Empty queries of the right size and shape can be formed off a single values table and a "WHERE FALSE" condition:

SELECT *
FROM (VALUES ('',1,"TRUE")) AS ProcedureInfo(ProcedureName,NumParameters, 
ProcedureValid)
WHERE 1=0


Previous Page
Next Page
Table of Contents
Index