作者:迷茫_信徒_476 | 来源:互联网 | 2023-02-02 19:48
变量声明
Syntax:
identifier [CONSTANT] datatype [NOT NULL] [:= | DEFAULT expr];
Scalar 标量 data type holds a single value and has no internal components.
number,
character,
date,
Boolean.
Character and number data types have subtypes that
associate a base type to a constraint. For example, INTEGERand POSITIVEare subtypes of the NUMBER
base type.
?CHAR [(maximum_length)]
? VARCHAR2(maximum_length)
? LONG
? LONG RAW
? NUMBER [(precision, scale)]
? BINARY_INTEGER
? PLS_INTEGER
? BOOLEAN
v_job: variable to store an employee job title
v_count: variable to count the iterations of a loop and initialized to 0
v_total_sal: variable to accumulate the total salary for a department and initialized to 0
v_orderdate: variable to store the ship date of an order and initialize to one week from today
c_tax_rate: a constant variable for the tax rate, which never changes throughout the PL/SQL block
v_valid: flag to indicate whether a piece of data is valid or invalid and initialized to TRUE