Hi all, I hope you can help. I have SQL which is the data source for an IG. The SQL aggregates hours spent working on specific tasks and gather info from other tables in sub-queries. The duration is stored in minutes but I want to display the duration in hh: mm format. I have done this successfully for the primary query, however, the sub-queries fail with "ORA-00921: unexpected end of SQL command". The query is below. If I remove the trim()... from the sub-query it works fine but the format of the duration is just in minutes rather than hh:mm. I would appreciate any help you might be able to offer. This code fails select c.week_starting, trim(to_char(trunc(sum(c.DUR_IN_MINS) / 60), '9')) || ':' || trim(to_char(trunc(mod(abs(sum(c.DUR_IN_MINS)), 60)), '09')) AS CLIENT_HHMM, ( select trim(to_char(trunc(sum(r.DUR_IN_MINS) / 60), '9')) || ':' || trim(to_char(trunc(mod(abs(sum(r.DUR_IN_MINS)), 60)) AS ACT_HHMM from FPO_CLIENT_REL_ACT r where c.week_starting = r.week_starting ) from FPO_SECT_A_PRO_PRAC c group by c.week_starting THIS WORKS FINE select c.week_starting, trim(to_char(trunc(sum(c.DUR_IN_MINS) / 60), '9')) || ':' || trim(to_char(trunc(mod(abs(sum(c.DUR_IN_MINS)), 60)), '09')) AS CLIENT_HHMM, (
Discy Latest Questions
Hi Is it possible to select a local variable in a sql query when using Function Body PLSQL returning SQL query type. Example: declare l_query varchar2(4000); l_practice varchar2(100); cursor c1 is select * from TABLE; begin for r1 in c1 loop //some code here l_practice := l_practice + r1.c001; end loop; l_query :='select '|| l_practice||' from TABLE'; return l_query; end;
Hi everyone, How to insert multiple values into single column using insert into statement? For example, i have booking say ID = B1, i made 2 issue against Booking Id = B1, say issue numbers are Is1, Is2 now while Invoicing, Invoice No = In1 , i have to store Issue Numbers(both Is1 & Is2) against the Booking ID =B1 in invoice . Any help would be highly appreciated..
Current sql is "select case when connect_by_isleaf =1 then 0 when level = 1 then 1 else -1 end as status, level, name, null as icon, id, null as tooltip, 'f?p=&APP_ID.:&APP_PAGE_ID.:'||:APP_SESSION||'::::P1015_GL_TYPE:'||"PREFIX" as link from nbfi_gl_type start with HEAD is null connect by prior ID = HEAD order siblings by ID" this send tree's prefix to table's column in same region. My trying to do thing is when i click tree page's column then take that column's prefix and link to other modal dialog page. /sry me bad english im junior/
Dear Vinish Sir i'm trying to send email from my apex 19.1,i'm getting following error ORA-04063: package body "APEX_190100.WWV_FLOW_MAIL" has errors ORA-06508: PL/SQL: could not find program unit being called: "APEX_190100.WWV_FLOW_MAIL" Can You help me out.? and in my toad if i try to compile this APEX_190100.WWV_FLOW_MAIL package i'm getting error as package body is wrapped cannot do anything any solution please?
Dear Vinish i want to create a login page with new user and old user authentication.. for eg if a user has user id and password he can login from login page. but if a user is new to he has to create login credentials.. currenty i have already created custom authentication as shown in your link 'https://www.foxinfotech.in/2019/09/create-custom-authentication-in-5-easy-steps-in-oracle-apex.html' i have also placed a link on login page 'to create new user press here' and redirected the link to another page in application but as i have created autentication i'm not able to redirect to other page from login screen thanks in advance can anyone help me out?