Tài liệu PL/SQL User’s Guide and Reference phần 8

Thảo luận trong 'Căn Bản' bắt đầu bởi Thúy Viết Bài, 5/12/13.

  1. Thúy Viết Bài

    Thành viên vàng

    Bài viết:
    198,891
    Được thích:
    167
    Điểm thành tích:
    0
    Xu:
    0Xu
    Keyword and Parameter Description
    cursor_name
    This identifies an explicit cursor previously declared within the current scope.
    datatype
    This is a type specifier. For the syntax of datatype, see Constants and Variables
    on page 11-33.
    db_table_name
    This identifies a database table (or view) that must be accessible when the
    declaration is elaborated.
    expression
    This is an arbitrarily complex combination of variables, constants, literals,
    operators, and function calls. The simplest expression consists of a single variable.
    When the declaration is elaborated, the value of expression is assigned to the
    parameter. The value and the parameter must have compatible datatypes.
    parameter_name
    This identifies a cursor parameter; that is, a variable declared as the formal
    parameter of a cursor. A cursor parameter can appear in a query wherever a
    constant can appear. The formal parameters of a cursor must be IN parameters. The
    query can also reference other PL/SQL variables within its scope.
     

    Các file đính kèm:

Đang tải...