Page 935
This function should be created as
FUNCTION OGQUERYFILTER0 (chartobj IN og_object, query IN og_query) RETURN BOOLEAN IS whname VARCHAR2(50); BEGIN whname := OG_GET_CHARCELLL (query, OG_NEWDATA, `Warehouse'); if whname in (`Wharton, NJ', `Boise, ID') then RETURN TRUE; else RETURN FALSE; end if; END;
This filter returns a value of TRUE for all valid rows that will then be plotted on the chart.
This chapter presented many of the capabilities of Oracle Graphics 2.5 that enable most Oracle developers to use this tool constructively. By practicing and working with the tool set, you can quickly become an expert user of this powerful tool.
You can use Oracle Graphics to present graphical representations of Oracle data. The extensive options of this tool give the Oracle developer the capability to create more than 50 different chart types that can be customized to provide the functionality needed for today's high-level executive information systems. Graphical views of data deliver the impact that cannot be achieved with mere textual views of numerical data.
Page 936