Sybernet / Supplied Functions Reference Release 3.00 Oct 14, 2002

HTTP.SYBSELECT

This function returns one column from your select statement. It relies on Oracle's ability to implicitly convert its result to a number or date if needed when the final result is evaluted. In the case of DATE variables, SYBSELECT returns the default date format.

Syntax

FUNCTION SYBSELECT
(
    SELECT_STATEMENT              VARCHAR2
)
RETURN VARCHAR2;

Parameters

select_statement

Returns

The column selected as a VARCHAR2 or NULL if no rows were found.

Example

The following example illustrates how to call sybselect:

select http.sybselect('select groupname from http.http_register where procname = ''HTTP.SP_HTML_ISQL''') from dual


------------------------------------------
HTTP.SP_HTML_UTILITIES