Basic Report Select

@sql_show = <<ENDOFSQL;

select

'<tr><td>', seq,

'</td><td>', priority,

'</td><td>', open_date,

'</td><td>', to_char(open_date,'HH:MI PM'),

'</td><td>', name,

'</td><td>', email,

'</td><td>',substr(problem,1,30),

'</td></tr>' from oratut.calls;

ENDOFSQL