Noor Bappy - Oracle Specialist | Apex Expert

https://drive.google.com/file/d/1MaW__lwKVZGp6obxVZIptMKgkED9Z1r4/view?usp=sharing https://drive.google.com/file/d/1MaW__lwKVZGp6obxVZIptMKgkED9Z1r4/view?usp=sharing

Question 001: 1 - CREATE AN USER NAMED PRAC001 IN SQLPLUS AND GRANT DBA PREVILEGES. 2 - CREATE AN WORKSPACE NAMED PRAC001 AND CREATE AN APPLICATION NAMED "DEMO WEB APPLICATION". 3 - CREATE THE TABLES AS PER SCRIPT AT APEX : SQL WORKSHOPS >…

Report Practical - Master Details Report: 1 - CREATE A MASTER DETAILS REPORTS WITH THE FOLLOWING TABLES IN OE SCHEMA with parameter. e.g. ORDER_ID=2440 2 - IN THE ORDER ITEMS TABULAR REPORT ADD AN ITEM WHICH CALCULATE THE      UNIT_PRICE * QUANTITY. e…

PARAMETER REPORT : SELECT EMPLOYEE_ID,FIRST_NAME||' '||LAST_NAME NAME, EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY FROM EMPLOYEES where DEPARTMENT_ID=:P_DEPARTMENT_ID; -- ADD PARAMETER :P_DEPARTMENT_ID -- ADD LIST-OF-VALUES(LOV) IN :P_DEPARTMEN…

Matrix Report : MATRIX REPORT 1: SELECT CUSTOMER_ID,ORDER_ID,ORDER_DATE FROM ORDERS; SELECT ORDER_ID,PRODUCT_ID,NVL(UNIT_PRICE,0)*NVL(QUANTITY,0) AMOUNT FROM ORDER_ITEMS; SELECT A.CUSTOMER_ID,A.ORDER_DATE,B.PRODUCT_ID,B.AMOUNT FROM (SELECT CUSTOMER_I…

Group Above Report : 1 - CREATE A GROUP ABOVE REPORT WITH FOLLOWING QUERY : GROUP BY PRODUCT_ID AND ADD FUNCTION  TO SHOW PRODUCT_NAME FROM PRODUCT_INFORMATION. 2 - Must have sub total and grand total summary items of the following items: a) Quantity…

Create Tabular Report: SCHEMA : OE. 1 - CREATE A REPORT WITH THE FOLLOWING QUERY : SELECT PRODUCT_NAME,CATEGORY_ID,SUPPLIER_ID, PRODUCT_STATUS,LIST_PRICE,MIN_PRICE FROM PRODUCT_INFORMATION; 2 - ADD A PARAMETER (MODIFY TO PARAMETER BASED REPORT). SELEC…