1.Repeat Statement以下是Repeat Statement的语法:Repeat statement_listUntil logical_expression;Repeat Statement每执行完一次statement_list都会去执行logical_expression。如果返回为false,该循环仍然会按顺序执行,直到返回值为true。2.While state
2.While statement 以下为While statement 的语法: While logical_expression statement_list End-while; While statement会在执行statement_list之前进行逻辑判断。他们会一直顺序执行直到 逻辑判断返回值为false 。 参考: Repeat While 16 Company Confidential - For internal use 文档名称 2.5 函数 本章主要讨论: ...
logical_expression ?statement_list ?End-while; While statement会在执行?statement_list之前进行逻辑判断。他们会一直顺序执行直到逻辑判断返回值为false。参考: Repeat While 函数本章主要讨论:被支持的函数函数定义函数的声明函数的调用函数返回值函数的命名冲突同时参考: Understanding Objects and Classes in People...
You can use PeopleSoft Query in the following ways: • To display data in a grid (on the Run tab). You can preview queries within Query Manager, displaying the result set in a grid for review. This option is useful as you refine your queries. • To run queries as a separate ...
要获取使用选项LIST STALE收集自动统计信息定位的对象列表,请使用以下过程: 您应该在GLOBAL级别设置以下内容: 1. 要让Oracle确定样本大小,请设置以下参数: ESTIMATE_PERCENT => DBMS_STATS.AUTO_SAMPLE_SIZE Example 速度为10%的样品: RunNumAUTO_SAMPLE_SIZE10%SAMPLE100%SAMPLE ...
SoftProductionReporting•UnderstandingPeopleSoftReportContext•QuestionsMoreaboutthePresenter•LarryGrey•PeopleSoftEmployeefrom1994-2005•ProductManagerforReportingToolsfrom1996–2005.•Co-founderofGreySparlingSolutions•PS/nVision•PS/Query•TreeManager•Crystal•CubeManager•ProcessScheduler•Report...
Chapter 3 Data Source Data Object Column Built-in Function Constant Value Creating Source Data Objects Select this option to display a list of data object fields. Select a field and click Insert to have the selected data object appear in the expression statement. Select this option to display ...
[1.0] Copyright © 2023, Oracle and/or its affiliates / Public List of figures Figure 1: PeopleSoft Maximum Availability Architecture Figure 2: Oracle Database Maximum Availability Architecture Figure 3: PeopleSoft High Availability Architecture Figure 4: PeopleSoft Maximum Availability Architecture ...
要获取使用选项LIST STALE收集自动统计信息定位的对象列表,请使用以下过程: 您应该在GLOBAL级别设置以下内容: 1. 要让Oracle确定样本大小,请设置以下参数: ESTIMATE_PERCENT => DBMS_STATS.AUTO_SAMPLE_SIZE Example 速度为10%的样品: RunNumAUTO_SAMPLE_SIZE10%SAMPLE100%SAMPLE ...
The main objection to having the database terminate a PS/Query running in the PIA is that the resulting Oracle error message will be displayed in the browser without any further explanation. Therefore, I think it is better to allow the PIA to handle termination of the query. However, I als...