Sybase Adaptive Server Anywhere - Page 374

Alphabetical list of functions
356
SELECT PI( * )
♦ SQL/92 Vendor extension.
♦
Sybase The PI() function is supported in Adaptive Server Enterprise,
but PI(*) is not.
PLAN function [Miscellaneous]
Returns the optimization strategy of a SQL statement, as a string.
PLAN ( string-expression )
string-expression The SQL statement, which is commonly a SELECT
statement but which may also be an UPDATE or DELETE.
The following statement returns a string containing the plan for executing the
query. This information can help with decisions about indexes to add or how
to structure your database for better performance.
SELECT PLAN( ’select * from department where dept_id >
100’ )
♦ SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
POWER function [Numeric]
Calculates one number raised to the power of another.
POWER ( numeric-expression-1 , numeric-expression-2 )
numeric-expression-1 The base.
numeric-expression-2 The exponent.
The following statement returns the value 64.
SELECT Power( 2, 6 )
♦ SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
PROPERTY_DESCRIPTION function [System]
Returns a description of a property.
Standards and
compatibility
Function
Syntax
Parameters
Examples
Standards and
compatibility
Function
Syntax
Parameters
Examples
Standards and
compatibility
Function