❇️ 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 intialize PL/SQL package on page load in oracle apex.
Huy Nguyen
Maybe that table you use not exists on application you build. You add schema before table such as schema.table or create synonym for table to the schema you build application.
Check box column interacive grid
Huy Nguyen
Thanks for your opinion. But I know, that article for select id of row. For my case, I want to get value of column I select
Show snow fall effect on my page of oracle apex
Huy Nguyen
Hi @Vinish, can you have the document or web about show css effect on oracle apex. I try other but it is not successfully. Thank you for your concern.
Check function on the web of oracle apex is not working
Huy Nguyen
Thank for your idea. But that function I return varchar2, can not to change type. So I can't check your function in my apps. I test that select statement select 0.5 from dual; On Db, it returns 0.5 while on oracle apex returns .5. I think the problem starts from here.
Dynamic action on column on Interactive Grid
Huy Nguyen
I find out a way to solve that problem by creation trigger for that table. Thank you every one, especially @Vinish
Dynamic action on column on Interactive Grid
Huy Nguyen
Yeah, I have a got idea with you. But When I try, it does not return value. It my Sql statement for true action of Set value for event change column C select case when lead_id is not null then 0 else 1 end from ( select u.lead_id from dierp.users_lead u where u.id = :C); Item submit is C, column affRead more
Dynamic action on column on Interactive Grid
Huy Nguyen
I try this, but column B still has value of 1. But I forgot to remove default select query of B. When I remove default, column B has no value or null.
Dynamic action on column on Interactive Grid
Huy Nguyen
Thank for your time. But it is my fault. Column A is display only, but it is column from I select from another table). It has value or not, belongs to another table. So, when A is not null B then 0 else 1. Sorry for my description, it is not clear.
Dynamic action on column on Interactive Grid
Huy Nguyen
Hi Vinish, I use default for that column B by select query: < select case when :B is not null then 0 else 1 end from dual; /> But when I create a new row, with :B null or not null, it still have value equal 1. Thank you.
Dynamic action on column on Interactive Grid
Huy Nguyen
Thank you for your good idea.