Study With Rafiq

Button hover design ============= Inline CSS: ======== # btn_css {     border-color: #001317;     background-color: #00b227;     border-style: solid;     border-width: 0px 0px 3px;     box-shadow: 0 -1px 0 rgb(255 255 255 / 10%) inset;     border-ra…

Step:1 ===== Create a New Region. Type: Cards SQL Query: SELECT  1 SL, 'https://thumbs.dreamstime.com/b/colorful.jpg' ICON, 'Total Sell' TITEL, 'TK.'||TO_CHAR(SUM(PAID),'99,99,99,999')||'/-' TOTAL, APEX_PAGE.G…

Total Sum,Avg,Count Column Wise Step: 3 ===== Create Interactive Grid and SQL Query Change for Automatic Total value  show 0 . SQL Query: select ID,        RETURN_BILL,        PRODUCT_ID,        QTY,        ENTRY_BY,        ENTRY_DATE,        UPDATE…

1) Status Wise row Update & Delete off Step:1 ===== Create Region-->  Intarective Grid SQL Query: select ANIMAL_ID,       SUPPLIER_ID,       ANIMAL_TYPE,       STATUS,           CASE WHEN STATUS ='S' THEN 'X'           ELSE '…

Step:1 ==== /* Column and Button Design */ . pb-com {     background: linear-gradient(#599bb3, #408c99);     box-shadow: 0px 2px 4px -2px #276873;     color: rgb(13, 13, 13);     font-weight: 600;     width: 100% !important;     text-align: left !i…

Step:1 ===== / Button click then loading/removeLoading function loading() {   waiter = waitingPopup(); } function removeLoading() {   if (waiter) {     waiter.remove();   } } function waitingPopup() {   $("body").prepend(     '<div …

AND ( case           when :P22011_TYPE=' ALL '      then 'TRUE'                      when :P22011_TYPE=' PENDING '  then              (CASE WHEN  ( Quantity - Quantity_received ) >  0 THEN  'TRUE'  ELSE  'FALSE…

Step: 1 =====   Create Button. Name: Show_Report  Dynamic Action: Refresh_Report  Action: Execute Javascript code  Code :  apex.region(" GENERAL_REPORT_VIEW ").refresh();   Step: 2 =====   Select Report Region. Static ID:  GENERAL_REPORT…

CREATE TABLE   ZLOGINS_SESSIONS (   ZTIME               DATE                      DEFAULT SYSDATE,   ZUTIME              DATE,   SESSION_ID          VARCHAR2(100 BYTE)        DEFAULT sys_guid(),   USER_ID             VARCHAR2(100 BYTE),   MENU_CODE  …

Note : My PK Column LINE_NO. Step : 1 ===== Create Sequence SEQ_DEPT_2 Step : 2 ===== CREATE OR REPLACE PROCEDURE CREATE_PK_LINE_NO (    p_vrno               OUT    VARCHAR2) IS    v_vrno            NUMBER;  BEGIN     SELECT  SEQ_DEPT_2 .NEXTVAL  …