PL/SQL:Single Line Output With different datatypes.

This example will explain different data types, and output in a single line.

Example:

declare

bday date:='21-apr-1994';

name varchar2(30):='Muhammad Talha Zubair';

salary number(5):=20000;

begin

dbms_output.put_line('Salary Of Mr. ' || name||' is ' ||salary ||' and has Birthday on '||bday);

end;

Output:

Salary Of Mr. Muhammad Talha Zubair is 20000 and has Birthday on 21-APR-94