- 单项选择题You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?（）
A、Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property.
B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables.
C、Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables.
D、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property.
E、Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.
- E
关注下方微信公众号，在线模考后查看
- You work
- Examinethedescriptio
- RMAN offers
- Which of the followi
- View the E
- Which substitution v
- In Oracle̳
- You are
- Given: Whichthreeme
- 在恢复操作中，使用的最重要的结构是（），
- Which two̳
- ClicktheExhibitbutto
- Identify two situati
- Which of
- The EMP table has t
- 写出ORACLE的四种文件。（从物理存储
- 以下关于数据库过程和函数叙述正确的是（）
- Examine the&en
- You are
- While running&