DECLARE
name VARCHAR(25) NOT NULL := 'Smith';
surname name%TYPE := 'Jones';
BEGIN
DBMS_OUTPUT.PUT_LINE('name=' || name);
DBMS_OUTPUT.PUT_LINE('surname=' || surname);
END;
/
| No. | Subject | Author | Date | Views |
|---|---|---|---|---|
| 6 | NEW TABLE | admin | 2025.11.16 | 393 |
| 5 | OUTER.DECLARE | admin | 2024.02.03 | 630 |
| » | %TYPE | admin | 2024.02.02 | 605 |
| 3 | IF ... ELSE | admin | 2024.02.02 | 627 |
| 2 | EXCEPTION BLOCK | admin | 2024.02.02 | 639 |
| 1 | OUTPUT SHOWING | admin | 2024.02.02 | 620 |
