такими, как эти: SELECT AU.MAKE, AU.MODEL, AU.WEIGHT, AU.PRICE, AU.IN_STOCK FROM AUTOMOBILES AU WHERE (AU.MAKE = :MAKE OR :MAKE IS NULL) AND (AU.MODEL = :MODEL OR :MODEL IS NULL) AND (AU.PRICE <= :MAXPRICE состоит в том, что конечный пользователь может дополнительно ввести варианты для параметров :make, :model и :maxprice. Там, где сделан выбор, должен быть применен соответствующий фильтр. Везде, где :make, :model и :maxprice. существует только на уровне приложений. Прежде чем запрос передается серверу Firebird для подготовки, он должен быть преобразован в такую форму: SELECT AU.MAKE, AU.MODEL, AU.WEIGHT

10 Round corner @startuml skinparam rectangle { roundCorner<> 25 } rectangle "Concept Model" <> { rectangle "Example 1" <> as ex1 rectangle "Another rectangle" } @enduml 8 Research *** Initial Implementation Plan ** Design phase *** Model of AsIs Processes Completed **** Model of AsIs Processes Completed1 **** Model of AsIs Processes Completed2 *** Measure AsIs performance Research *** Initial Implementation Plan ** Design phase *** Model of AsIs Processes Completed ****< Model of AsIs Processes Completed1 ****> Model of AsIs Processes Completed2 ***< Measure AsIs performance

10 Round corner @startuml skinparam rectangle { roundCorner<> 25 } rectangle "Concept Model" <> { rectangle "Example 1" <> as ex1 rectangle "Another rectangle" } @enduml 8 Research *** Initial Implementation Plan ** Design phase *** Model of AsIs Processes Completed **** Model of AsIs Processes Completed1 **** Model of AsIs Processes Completed2 *** Measure AsIs performance Research *** Initial Implementation Plan ** Design phase *** Model of AsIs Processes Completed ****< Model of AsIs Processes Completed1 ****> Model of AsIs Processes Completed2 ***< Measure AsIs performance

EXISTS. Например, следующий запрос: Общие элементы языка 84 SELECT model, speed, hd FROM PC WHERE model IN (SELECT model FROM product WHERE maker = 'A'); использованием предиката EXISTS: SELECT model, speed, hd FROM PC WHERE EXISTS (SELECT * FROM product WHERE maker = 'A' AND product.model = PC.model); существуют модели, производитель которых начинается на букву «A»: SELECT model, speed, hd FROM PC WHERE model IN (SELECT model FROM product WHERE maker STARTING WITH 'A'); См

Research *** Initial Implementation Plan ** Design phase *** Model of AsIs Processes Completed **** Model of AsIs Processes Completed1 **** Model of AsIs Processes Completed2 *** Measure AsIs performance Research *** Initial Implementation Plan ** Design phase *** Model of AsIs Processes Completed ****< Model of AsIs Processes Completed1 ****> Model of AsIs Processes Completed2 ***< Measure AsIs performance commands, like title: @startuml skinparam titleFontSize 14 title Example of Tree |_ First line |_ **Bom(Model)** |_ prop1 |_ prop2 |_ prop3 |_ Last line end title [*] --> State1 @enduml Справочное руководство

Research *** Initial Implementation Plan ** Design phase *** Model of AsIs Processes Completed **** Model of AsIs Processes Completed1 **** Model of AsIs Processes Completed2 *** Measure AsIs performance Research *** Initial Implementation Plan ** Design phase *** Model of AsIs Processes Completed ****< Model of AsIs Processes Completed1 ****> Model of AsIs Processes Completed2 ***< Measure AsIs performance commands, like title: @startuml skinparam titleFontSize 14 title Example of Tree |_ First line |_ **Bom(Model)** |_ prop1 |_ prop2 |_ prop3 |_ Last line end title [*] --> State1 @enduml Справочное руководство

10 Round corner @startuml skinparam rectangle { roundCorner<> 25 } rectangle "Concept Model" <> { rectangle "Example 1" <> as ex1 rectangle "Another rectangle" } @enduml 8 Research *** Initial Implementation Plan ** Design phase *** Model of AsIs Processes Completed **** Model of AsIs Processes Completed1 **** Model of AsIs Processes Completed2 *** Measure AsIs performance Research *** Initial Implementation Plan ** Design phase *** Model of AsIs Processes Completed ****< Model of AsIs Processes Completed1 ****> Model of AsIs Processes Completed2 ***< Measure AsIs performance

Research *** Initial Implementation Plan ** Design phase *** Model of AsIs Processes Completed **** Model of AsIs Processes Completed1 **** Model of AsIs Processes Completed2 *** Measure AsIs performance Research *** Initial Implementation Plan ** Design phase *** Model of AsIs Processes Completed ****< Model of AsIs Processes Completed1 ****> Model of AsIs Processes Completed2 ***< Measure AsIs performance build a tree. @startuml skinparam titleFontSize 14 title Example of Tree |_ First line |_ **Bom(Model)** |_ prop1 |_ prop2 |_ prop3 |_ Last line end title [*] --> State1 @enduml 16.9 Special characters

Research *** Initial Implementation Plan ** Design phase *** Model of AsIs Processes Completed **** Model of AsIs Processes Completed1 **** Model of AsIs Processes Completed2 *** Measure AsIs performance Research *** Initial Implementation Plan ** Design phase *** Model of AsIs Processes Completed ****< Model of AsIs Processes Completed1 ****> Model of AsIs Processes Completed2 ***< Measure AsIs performance build a tree. @startuml skinparam titleFontSize 14 title Example of Tree |_ First line |_ **Bom(Model)** |_ prop1 |_ prop2 |_ prop3 |_ Last line end title [*] --> State1 @enduml 16.9 Special characters

Research *** Initial Implementation Plan ** Design phase *** Model of AsIs Processes Completed **** Model of AsIs Processes Completed1 **** Model of AsIs Processes Completed2 *** Measure AsIs performance Research *** Initial Implementation Plan ** Design phase *** Model of AsIs Processes Completed ****< Model of AsIs Processes Completed1 ****> Model of AsIs Processes Completed2 ***< Measure AsIs performance build a tree. @startuml skinparam titleFontSize 14 title Example of Tree |_ First line |_ **Bom(Model)** |_ prop1 |_ prop2 |_ prop3 |_ Last line end title [*] --> State1 @enduml 16.9 Special characters