oracle定义pl sql变量（Oracle定义PL SQL变量）.docVIP

oracle定义pl sql变量（Oracle定义PL SQL变量） Preface： Using variables can store the data that the computer needs to handle, and in order to allocate the appropriate memory space to the variable, you also need to specify the data type, and some data types also need to specify the length, such as strings. Some types can be used to build tables (such as char), while others cannot (such as boolean, rowtype). The same string, when the table is limited to 4000, and more than 30 thousand in the script. Simple syntax: variable name data type; The complete syntax: [constant] [not null] variable type variable name = value]: [default value | [] means that you can not write, said | choose one. The following definitions and explanations of variables are given, and the data type first uses the data types used to build tables: V1 char: Explanation: the length is not given, so V1 can only save one character. If you exceed, you go wrong: numeric or value error: string buffer is too small. V2 VARCHAR2 (10); Explanation: V2 can save up to 10 characters only. If you dont write the length, you make a mistake: string length is limited to range (1, 32767) V3 number; Explanation: V3 saves a very large number of digits, almost without limitation. V4 number (5); Explanation: V4 can hold up to 5 bit integers at most. If there is a decimal, Oracle will automatically drop in at four five. If the integer part is more than 5 bits, it will be wrong: numeric or value error: the numerical accuracy is too high. V5 number (5,2); Explanation: V5 can hold up to 3 bit integers and 2 decimal places at most. If the decimal number is more than 2 bits, the Oracle will automatically drop in from four to five. Integer bits exceeding 3 bits will be declared wrong, ditto. V6 date; Description: you can directly save the value of sysdate; if the date is specified, use to_date to translate it. Otherwise, the error is wrong: the text does not match the format string. A variable is defined, and the default value of the variabl