336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
SET SERVEROUTPUT ON
DECLARE f_name varchar(20);
BEGIN SELECT first_name INTO f_name FROM employees WHERE employee_id = 100; DBMS_OUTPUT.PUT_LINE(' The First Name of the Employee is '||f_name); END; |
PL/SQL doesn't have any functionality built in it.
- Enable output in iSQL PLUS with the command
SET SERVEROUTPUT ON - Use a predefined Oracle Package and its procedure
DBMS_OUTPUT.PUT_LINE
'Oracle > PL/SQL' 카테고리의 다른 글
| Use of Variables (0) | 2006.12.31 |
|---|---|
| Test the Output of a PL/SQL Block (0) | 2006.12.31 |
| Create a sample Anonymous block (0) | 2006.12.31 |
| Create a sample Anonymous block (0) | 2006.12.31 |
| Block Types (0) | 2006.12.31 |