Homemega/slider Admin Dashboard Using Dynamic Data via HTML CSS in apex jABER IT LTDjABER IT LTD -10:07 PM 0 Create Admin Dashboard Using Dynamic Data via HTML CSS In Oracle Apex Create Admin Dashboard Using Dynamic Data via HTML CSS In Oracle Apex 1. Create a Page, Name- Admin Dashboard in HTML and CSS 2. Create a Region -> 3. Region Type -> PL/SQL Dynamic Content -> Paste the following code HTP.P(''); HTP.P(''); HTP.P(''); HTP.P(''); HTP.P(' Responsiive Admin Dashboard | CodingLab '); HTP.P(''); HTP.P(''); HTP.P(''); HTP.P(''); HTP.P(''); HTP.P(''); FOR u IN (SELECT (SELECT COUNT (s.OID) FROM SALES_DTLS s, PURCHASE_DETALIS P WHERE s.PRODUCT_ID = p.PRODUCT_ID AND s.PROOUCT_SIZE = p.PROOUCT_SIZE) AS Total_Order, (SELECT SUM (s.TOTAL) FROM SALES_DTLS s, PURCHASE_DETALIS P WHERE s.PRODUCT_ID = p.PRODUCT_ID AND s.PROOUCT_SIZE = p.PROOUCT_SIZE) AS Total_sales, ( (SELECT SUM (s.TOTAL) FROM SALES_DTLS s, PURCHASE_DETALIS P WHERE s.PRODUCT_ID = p.PRODUCT_ID AND s.PROOUCT_SIZE = p.PROOUCT_SIZE) - (SELECT SUM (p.TOTAL) v_Total_Profit FROM PURCHASE_DETALIS P, SALES_DTLS s WHERE s.PRODUCT_ID = p.PRODUCT_ID AND s.PROOUCT_SIZE = p.PROOUCT_SIZE)) AS Total_Profit, (SELECT SUM (t.STK_QNTY) FROM STOCK t, SALES_DTLS s WHERE s.PRODUCT_ID = t.PRODUCT_ID AND s.PROOUCT_SIZE = t.PROOUCT_SIZE) Current_stock FROM DUAL) loop htp.p(' Total Order '||u.Total_Order||' Up from yesterday Total Sales $'||u.Total_sales||' Up from yesterday Total Profit $'||u.Total_Profit||' Up from yesterday Total Return '||u.Current_stock||' Down From Today '); END LOOP; HTP.P(''); HTP.P(''); 🔗 Demo Application- URL- Demo Application Username - demo, Pass- demo I hope everyone will like it. Please watch the full video, Comment on any of your problems, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable. Visit my blog site, new technology related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work. Please stay tuned by subscribing to the YouTube channel, and encourages new videos to be uploaded. ================= Visit my site to get more collaborative posts about Oracle Apex and subscribe to my YouTube channel. Thanks. Comment on any of your issues, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable. Visit my blog site, new technology-related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work. ============================== 🙍🏾 Md jABER HOSSEN 📲 Mobile- +8801760688286 📨 Email- jaberit786@gmail.com 🌐 FB- facebook.com/mdjaber.hossen1 Please Subscribe to My Channel Many thanks for visiting the site. Then Enjoy......................... Facebook Twitter Post a Comment Hlo Sir Previous Post Next Post