When the BULK COLLECT clause is included, the statement can return multiple rows; the variable in the INTO clause must be an array, and each row is stored in an array element.
在包括BULKCOLLECT子句后,该语句可返回多行;INTO 子句中的变量必须是阵列,且每一行存储在一个阵列元素中。
Parameter MARKER: an application may wish to call the same query multiple times, only changing specific values each time (ex: parameters sent to a stored procedure, or a value in a WHERE clause).
参数标志(PARAMETER MARKER):应用程序可能希望多次调用同一个查询,每次调用时只改变特定的值(例如,发送给存储过程的参数,或者where子句中的值)。
The WebSphere MQ functions can be invoked anywhere a function can be used: values clause, projection list, query filters, stored procedures, and triggers.
WebSpheremq函数可以在任何可使用函数的地方进行调用:值子句、投影列表、查询过滤器、存储过程和触发器。
If XMLQUERY is used within a SELECT statement, the PASSING clause can refer to either a table column or a stored procedure variable.
如果在select语句中使用XMLQUERY,那么passing子句可以引用表列或者存储过程变量。
The listing file name is used to generate the WITH listing in clause for the stored procedure.
清单文件名用于为存储过程生成WITHLISTINGin子句。
Since the employee id is stored in the id column, this filter is easy to implement by adding a range comparison in the where clause of the SQL statement.
因为职员id存储在id列中,所以很容易通过在sql语句的where子句中添加范围比较来实现这个筛选器。
Sybase existing tables can be used with a WHERE clause specifying column names of the existing table to restrict the output received from the stored procedure.
对于Sybase现有表,可以使用where子句指定现有表的列名,以限制存储过程的输出。
Sybase existing tables can be used with a WHERE clause specifying column names of the existing table to restrict the output received from the stored procedure.
对于Sybase现有表,可以使用where子句指定现有表的列名,以限制存储过程的输出。
应用推荐