Hi if we use this then will get the static value whatever is present inside single quotes only that will reflect. I need data from the oracle database if the user has entered in double-quotes then that double quotes also should come
Hi
if we use this then will get the static value whatever is present inside single quotes only that will reflect.
I need data from the oracle database if the user has entered in double-quotes then that double quotes also should come
Sir if manager login to approve the tasks for different member then in the app_user will get manager name but i want to get the name of the person who have entered the data Eg: If RAM has entered the data then the manager can view that the ram has entered it in the user field. if Shyam has entered tRead more
Sir if manager login to approve the tasks for different member then in the app_user will get manager name but i want to get the name of the person who have entered the data
Eg:
If RAM has entered the data then the manager can view that the ram has entered it in the user field.
if Shyam has entered the data then the manager can view that the Shyam has entered it in the user field.
if :p3_statusall = 'Approve All' then Update times set statusm = case when statusm is null then 'APPROVED' else statusm end; set statust = case when statust is null then 'APPROVED' else statust end; Where pid = :p3_pid; apex_util.set_session_state('P3_STATUSM', 'Approved'); elsif :p3_statusall = 'ReRead more
if :p3_statusall = 'Approve All' then Update times set statusm = case when statusm is null then 'APPROVED' else statusm end; set statust = case when statust is null then 'APPROVED' else statust end;
Where pid = :p3_pid; apex_util.set_session_state('P3_STATUSM', 'Approved');
elsif :p3_statusall = 'Reject All' then Update times set statusm = case when statusm is null then 'REJECTED' else statusm end; set statust = case when statust is null then 'REJECTED' else statust end; Where pid = :p3_pid; apex_util.set_session_state('P3_STATUSM', 'Rejected');
end if;
i have multiple fileds to be set approve i.e., 5 days a week(statusm,statust,statusw ...) will this plsql work
Data Extract in CSV with double quotes
Swarup
At query level it's working when we go to procedure level then the data are not getting as expected
At query level it's working when we go to procedure level then the data are not getting as expected
See lessData Extract in CSV with double quotes
Swarup
Hi if we use this then will get the static value whatever is present inside single quotes only that will reflect. I need data from the oracle database if the user has entered in double-quotes then that double quotes also should come
Hi
if we use this then will get the static value whatever is present inside single quotes only that will reflect.
I need data from the oracle database if the user has entered in double-quotes then that double quotes also should come
See lessRTF Template if else Condition
Swarup
I am using this statement in RTF template in BIP publisher word docs.
I am using this statement in RTF template in BIP publisher word docs.
See lessShowing information on IR Region
Swarup
thnx for you support how to get data from db in place of hello eg:Total Hours: (it is calculating dynamically )
thnx for you support how to get data from db in place of hello
eg:Total Hours: (it is calculating dynamically )
See lessInserting App user into the data table in Oracle apex
Swarup
Sir if manager login to approve the tasks for different member then in the app_user will get manager name but i want to get the name of the person who have entered the data Eg: If RAM has entered the data then the manager can view that the ram has entered it in the user field. if Shyam has entered tRead more
Sir if manager login to approve the tasks for different member then in the app_user will get manager name but i want to get the name of the person who have entered the data
Eg:
If RAM has entered the data then the manager can view that the ram has entered it in the user field.
if Shyam has entered the data then the manager can view that the Shyam has entered it in the user field.
See lessShowing information on IR Region
Swarup
Can it be possible to design this
Can it be possible to design this
See lessInserting App user into the data table in Oracle apex
Swarup
Thnx sir it works
Thnx sir it works
See lessApprove all dynamically in oracle apex
Swarup
Thanx so much sir for your kind support
Thanx so much sir for your kind support
See lessApprove all dynamically in oracle apex
Swarup
When i am trying to do multiple row update i am getting folowing error
When i am trying to do multiple row update i am getting folowing error

See lessApprove all dynamically in oracle apex
Swarup
if :p3_statusall = 'Approve All' then Update times set statusm = case when statusm is null then 'APPROVED' else statusm end; set statust = case when statust is null then 'APPROVED' else statust end; Where pid = :p3_pid; apex_util.set_session_state('P3_STATUSM', 'Approved'); elsif :p3_statusall = 'ReRead more
if :p3_statusall = 'Approve All' then
Update times
set statusm = case when statusm is null then 'APPROVED' else statusm end;
set statust = case when statust is null then 'APPROVED' else statust end;
Where pid = :p3_pid;
apex_util.set_session_state('P3_STATUSM', 'Approved');
elsif :p3_statusall = 'Reject All' then
Update times
set statusm = case when statusm is null then 'REJECTED' else statusm end;
set statust = case when statust is null then 'REJECTED' else statust end;
Where pid = :p3_pid;
apex_util.set_session_state('P3_STATUSM', 'Rejected');
end if;
i have multiple fileds to be set approve i.e., 5 days a week(statusm,statust,statusw ...) will this plsql work
See less