| dbms_output.put_line [message #1849] |
Tue, 04 June 2002 11:10  |
Mike Nibeck
Messages: 49
Registered: May 2002
|
Member |
|
|
This should be pretty easy. I want to output a text line, replacing a section of the line with a column from a table. Pseudo code:
FOR EACH Customer:
dbms_output.put_line('Your age is ', Customer.Age);
END;
Help a newbie......
- Mike
|
|
|
|
| Re: dbms_output.put_line [message #1850 is a reply to message #1849] |
Tue, 04 June 2002 11:58  |
Todd Barry
Messages: 4819
Registered: August 2001
|
Senior Member |
|
|
Make sure to SET SERVEROUTPUT ON in SQL*Plus:
begin
for r in (select name, age from customers) loop
dbms_output.put_line(r.name || ', your age is ' || r.age);
end loop;
end; |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
