❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
How to display blob image in html css report oracle apex?
Vinish Kapoor
okay. Give it a try to this one: Declare c_img clob; Begin c_img := apex_web_service.blob2clobbase64(h); <img src="data:image/jpg;base64, '|| c_img ||'"/> End;
okay. Give it a try to this one:
See lessHow to setup email in oracle apex
Vinish Kapoor
Yes, I think so.
Yes, I think so.
See lessHow to give page under maintenance message on specific apex page
Vinish Kapoor
To show the page under maintenace message, follow these steps: Create a blank page and create a region inside and give the title "Page is under maintenance.". Create a table app_settings as below: Create Table app_settings (dev_mode varchar2(1) default 'N'); Insert a row as below: Insert into app_seRead more
To show the page under maintenace message, follow these steps:
This will do the job.
See lessHow to collapse right column on page load
Vinish Kapoor
On page load, create a dynamic action to execute JavaScript code and add the following code in it: jQuery("#t_Button_rightControlButton").click(); If the button id is not correct then you will have to inspect your right column button to get the correct id.
On page load, create a dynamic action to execute JavaScript code and add the following code in it:
If the button id is not correct then you will have to inspect your right column button to get the correct id.
See lessHow can we compare the checkbox page item(multiple selection) in where clause
Vinish Kapoor
Do not change anything in the below cursor. Use as-is: Cursor C1 is select EMPCD,EMPNAME,LSTSAL,ESEX,EMRTSTS,EDESGN from empmst where EDESGN in (SELECT t.column_value FROM table (Apex_String.Split(:P9944_EDESGN,':')) t WHERE t.column_value IS NOT NULL); In the above query, "table" and "coluRead more
Do not change anything in the below cursor. Use as-is:
In the above query, "table" and "column_value" are the keywords, so do not change them.
See less2 Buttons or more in one column classic report
Vinish Kapoor
Ok, we are very near 😃 Again modified: SELECT ROWID, '<a class="t-Button t-Button--noLabel t-Button--icon t-Button--tiny t-Button--success t-Button--simple" href="javascript:setItem('||chr(39)||rowidtochar(ROWID)||chr(39)||');"'||'>btn-1</a>' <br>' .. your next button AS BTNS
Ok, we are very near 😃
Again modified:
See lessCSS Styling of Apex Objects to make larger Buttons or Input boxes
Vinish Kapoor
Yes, the custom attribute is the shortcut 😀. And I tried increasing the size of icons, but it was not happening. So you can use the image instead of the icon. To do this, upload small images for buttons in the Shared Components > static files. Then you can use it in your CSS. Just add one more CSRead more
Yes, the custom attribute is the shortcut 😀.
And I tried increasing the size of icons, but it was not happening.
So you can use the image instead of the icon. To do this, upload small images for buttons in the Shared Components > static files.
Then you can use it in your CSS. Just add one more CSS to your style attribute as below:
See lessCreate column in interactive report to redirect to corresponding page
Vinish Kapoor
Usage of elsif with the case is wrong. Below is the right syntax: case when nvl(STATUS,'APPROVED')='APPROVED' then 'f?p=&APP_ID.:100:8:&APP_SESSION.:::8:P8_ID:'||ID when nvl(STATUS,'REQUESTED')='REQUESTED' then 'f?p=&APP_ID.:100:9:&APP_SESSION.:::9:P9_ID:'||ID else '#' end LINKRead more
Usage of elsif with the case is wrong. Below is the right syntax:
APEX: How can I refer a row in a report - Server-side conditions
Vinish Kapoor
Server-side condition is not for this purpose. To show the name instead of the id, you need to put the join in your report query. Below is an example: Select a.people_Id, p.name from yourReportTable a, people p where a.people_id = p.id; Then hide the people_id column from the report and show the namRead more
Server-side condition is not for this purpose.
To show the name instead of the id, you need to put the join in your report query. Below is an example:
Then hide the people_id column from the report and show the name column.
See lessTemporarily store and retrieve data
Vinish Kapoor
I think you can store the data temporarily in the tables, and if there is no consent or the user presses the cancel button, you can silently delete using the dynamic action to execute server-side code.
I think you can store the data temporarily in the tables, and if there is no consent or the user presses the cancel button, you can silently delete using the dynamic action to execute server-side code.
See less