It is very easy to upload a image in form and show it in form. Here I give the sequence of task to do.
1. First add a column for IMAGE with BLOB type.
2. Create a report and it's data inserting form where there will be a FILE BROWSER type option for Image.
3. Select on REPORT then go to Properties then Code Editor - SQL Query
4. Then Add [ dbms_lob.getlength(Column Name) img ] respective of IMAGE column.
5. And finally select on IMAGE column then goto properties and change type as DISPLAY IMAGE
at the end save and run.
Now upload image and see it on your report.
Thank You.
Subscribe to:
Post Comments (Atom)
Restrict File Upload by File Type in Oracle Apex
If you want to restrict file upload by file type/extension/format you can follow the below steps. Goto File Browser Item --> Advanced --...
.png)
-
Search by keyword from Oracle Database Objects. select owner, type, name, line, text from dba_source where 1 = 1 and text like '%TEXT Y...
-
We Can Export Application Components individually from Oracle Apex. Application > Shared Components > Export Application Compo...
No comments:
Post a Comment