| DECLARE | |
| code CHAR(10); | |
| status INT := 1; | |
| count SMALLINT = 0; | |
| limit INT DEFAULT 100; | |
| f UTL_FILE.FILE_TYPE; | |
| BEGIN | |
| status := 2; | |
| END; | |
| DECLARE code CHAR(10); | |
| DECLARE status, status2 INT DEFAULT 1; | |
| DECLARE count SMALLINT, limit INT DEFAULT 100; | |
| DECLARE dt DATE DEFAULT '2015-05-13'; | |
| DECLARE ts TIMESTAMP DEFAULT '2015-05-13 11:10:01'; |