DECLARE
IRVINE VARCHAR2(30);
BEGIN
IRVINE := 'HELLO IRVINE';
dbms_output.put_line('*'|| '&input' ||'*');
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line(IRVINE);
END;
/
| No. | Subject | Author | Date | Views |
|---|---|---|---|---|
| 6 | NEW TABLE | admin | 2025.11.16 | 479 |
| 5 | OUTER.DECLARE | admin | 2024.02.03 | 724 |
| 4 | %TYPE | admin | 2024.02.02 | 693 |
| 3 | IF ... ELSE | admin | 2024.02.02 | 704 |
| » | EXCEPTION BLOCK | admin | 2024.02.02 | 727 |
| 1 | OUTPUT SHOWING | admin | 2024.02.02 | 708 |
