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..
What is Subquery in SQL? what is used for it. examples for the subquery. implementations of it.
Hello,I have one excel file with headings in it. I have one form which contains all fields related to excel file So what I want to do is when users fills the form and submits it should automatically open excel file filled with the data entered in form. Thanks in advance
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/
Hi all! How to redirect link from PL/SQL Dynamic Content region to modal dialog page. Thanks in advance!
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?
I have created application item and application Computation in shared component and refrenced it in desktop navigation menu but the thing is i want to change the colour of application item which i have refrenced ..