Hello everyone,
I use an interactive report on a table containing a blob column.
I use this request : it's an example
select
att_id, -- new primary key column
filename nom,
mime_type type_mime,
to_char(upl_date, 'DD/MM/YYYY HH24:MI:SS') upl_date_complete,
dbms_lob.getlength(data) data
from
att
where
a.fk = :px_fk
order by
upl_date desc
However, I saw that I can make the file downloadable. However, if it's a PDF, or an image, I would like it to be opened in another tab.
Is it possible to do so ?
Thank you for your help,