oracle

Oracle SQL – Grouping based on time within one second

by

Oracle SQL – Grouping based on time within one second Problem Description: Sample Table: create table sampledata as select 78328696 pkid, 12848815 customer_id, to_date(’10/19/2022 11:05:38 AM’,’MM/DD/YYYY HH:MI:SS AM’) actdate, 0.5 units, to_timestamp(’19-OCT-22 11.05.38.947750000 AM’) datetime from dual union all select 78328697, 12848815, to_date(’10/19/2022 11:05:39 AM’,’MM/DD/YYYY HH:MI:SS AM’), 0.5, to_timestamp(’19-OCT-22 11.05.39.024819000 AM’) from dual union all … Read more

Making changes on a pivot table

by

Making changes on a pivot table Problem Description: I have the following query: SELECT CASE GROUPING_ID(status, CASE WHEN status IN (2, 4, 5) THEN 1 ELSE 0 END) WHEN 0 THEN TO_CHAR(status) WHEN 2 THEN ‘subtotal’ ELSE ‘total’ END AS status, COUNT(CASE user_type WHEN 1 THEN 1 END) AS "1", COUNT(CASE user_type WHEN 2 THEN … Read more

Making changes on a pivot table

by

Making changes on a pivot table Problem Description: I have the following query: SELECT CASE GROUPING_ID(status, CASE WHEN status IN (2, 4, 5) THEN 1 ELSE 0 END) WHEN 0 THEN TO_CHAR(status) WHEN 2 THEN ‘subtotal’ ELSE ‘total’ END AS status, COUNT(CASE user_type WHEN 1 THEN 1 END) AS "1", COUNT(CASE user_type WHEN 2 THEN … Read more

Making changes on a pivot table

by

Making changes on a pivot table Problem Description: I have the following query: SELECT CASE GROUPING_ID(status, CASE WHEN status IN (2, 4, 5) THEN 1 ELSE 0 END) WHEN 0 THEN TO_CHAR(status) WHEN 2 THEN ‘subtotal’ ELSE ‘total’ END AS status, COUNT(CASE user_type WHEN 1 THEN 1 END) AS "1", COUNT(CASE user_type WHEN 2 THEN … Read more

Can I use "order by" with user input in oracle?

by

Can I use "order by" with user input in oracle? Problem Description: I use the same procedure for several tasks. Each function also needs to use ORDER BY every time. I want to use ORDER BY with user inputs. I tried this but it didn’t work. PROCEDURE GET_DEPARTMENT_LIST(ORDER_BY_PARAM IN VARCHAR2, DEPT_DATA OUT T_CURSOR) IS V_CURSOR … Read more

Can I use "order by" with user input in oracle?

by

Can I use "order by" with user input in oracle? Problem Description: I use the same procedure for several tasks. Each function also needs to use ORDER BY every time. I want to use ORDER BY with user inputs. I tried this but it didn’t work. PROCEDURE GET_DEPARTMENT_LIST(ORDER_BY_PARAM IN VARCHAR2, DEPT_DATA OUT T_CURSOR) IS V_CURSOR … Read more

Can I use "order by" with user input in oracle?

by

Can I use "order by" with user input in oracle? Problem Description: I use the same procedure for several tasks. Each function also needs to use ORDER BY every time. I want to use ORDER BY with user inputs. I tried this but it didn’t work. PROCEDURE GET_DEPARTMENT_LIST(ORDER_BY_PARAM IN VARCHAR2, DEPT_DATA OUT T_CURSOR) IS V_CURSOR … Read more

Can I use "order by" with user input in oracle?

by

Can I use "order by" with user input in oracle? Problem Description: I use the same procedure for several tasks. Each function also needs to use ORDER BY every time. I want to use ORDER BY with user inputs. I tried this but it didn’t work. PROCEDURE GET_DEPARTMENT_LIST(ORDER_BY_PARAM IN VARCHAR2, DEPT_DATA OUT T_CURSOR) IS V_CURSOR … Read more

Can I use "order by" with user input in oracle?

by

Can I use "order by" with user input in oracle? Problem Description: I use the same procedure for several tasks. Each function also needs to use ORDER BY every time. I want to use ORDER BY with user inputs. I tried this but it didn’t work. PROCEDURE GET_DEPARTMENT_LIST(ORDER_BY_PARAM IN VARCHAR2, DEPT_DATA OUT T_CURSOR) IS V_CURSOR … Read more

Oracle SQL Uniquely Update Duplicate Records

by

Oracle SQL Uniquely Update Duplicate Records Problem Description: I have a STUDENT table and need to update the STUDENT_ID values by prefixing with the letter SS followed by STUDENT_ID value. For any duplicate STUDENT_ID records, I should prefix the duplicate records as SS1 SS2. Below is an example Before Update: NUM STUDENT_ID 1 9234 2 … Read more

We use cookies in order to give you the best possible experience on our website. By continuing to use this site, you agree to our use of cookies.
Accept
Reject
Read More…