I want to create a pivot report (Department wise sum salary). I need to use sub_query in pivot. XML cannot be used here. Example: SELECT * FROM ( SELECT DEPARTMENT_ID,SALARY FROM EMPLOYEES ) PIVOT (SUM(SALARY) FOR DEPARTMENT_ID IN (SELECT DISTINCT DEPARTMENT_ID FROM EMPLOYEES) )
Discy Latest Questions
The QR code of the report will show the link of the report. Clicking on that Report link will show the report.
ShimulProfessional
How Can i Send Bulk Email by using Mailchimp from Oracle Apex?
How to print directly when I click the Print button. No Print Preview. Bi Publisher or PLSQL Dynamic Content any one.
How to avoid a button from multiple clicking without Dynamic Action. Click to Disable Button or Avoid Multiple Clicking...
In Bi Publisher Report, How can i use multiple layouts through a Single query? That means my query will be one but the layout will be Many.
TABLE Like: Select Item_id,Item_name,Url from Item_Master. i have 300 Item And 300 Report Layout. But There is one print button.. when i will pressed print button. Item_Master Table Url Column Layout will be Preview.
Is it Possible to create a Dynamic master-detail entry screen in plsql Dynamic Content
How can i save dual table data into a table by Interactive Grid? Example: SELECT NULL AS DEPARTMENT_ID,NULL AS DEPARTMENT_NAME FROM DUAL I Want to insert it in Department Table. Select department_id,department_name from department.
ShimulProfessional
Department wise Employee Report. For IT Department: Employee_Id,Last_Name,Hire_date,Salary Column will Show. Other Column will be Hidden. For HR Department: Employee_Id,Salary Column will Show. Other Column will be Hidden. I want it will be show Hide from the database. For this Reason i created a Setup Employee Table and I have written a code in each item in server condition-> Plsql Function Body. Example: For Last Name Column: ======================= Declare V_LAST_NAME VARCHAR2(50); begin if :P443_TEST_NO is not null then select LAST_NAM into V_LAST_NAM from SET_EMPLOYEES where DEPARTMENT_ID=:P443_DEPARTMENT_ID; if V_LAST_NAME = '1' then return true; else return false; end if; end if; end; For Salary Column: ======================= Declare V_SALARY VARCHAR2(50); begin if :P443_TEST_NO is not null then select LAST_NAM into V_SALARY from SET_EMPLOYEES where SALARY_ID=:P443_SALARY; if V_SALARY = '1' then return true; else return false; end if; end if; end; But the problem is that I feel different Server Side Condition (Plsql Function Body) in each column.I want to do it by a function/Procedure. How Can i Do it?