Showing posts from October, 2022
Step-1 : Create new Bank Page Create New Region Type : PL/SQL Dynamic Content (copy paste bellow code) declare V_COMPANY_NAME VARCHAR2(100):='Goldean Dairy Farm'; cursor c_sell is select INVOICE_NO,INVOICE_DATE, CUSTOMER_ID , DISCOUNT_PCT…
If you want to set all page footer then following this steps... step-1 : Go to Global Page . --> Create a new region --> Region position footer --> Set templete : blank with attribute Step-2 : Footer text : <div style="position: …
Step-1 : Go to "Edit Application Definition" Step-2 : Click the "Globalization" Step-3 : Application Date Format - DD-MON-RR
If you want to do this design on all pages then you go to all edit page and copy to paste this code. Inline : .t-Header-branding{ background: rgb(200,86,98)!important; background: radial-gradient(circle, rgba(200,86,98,1) 0%, rgba(130,20,32,1) 45%…
Function and Global Variable Declaration :- let myitmval = apex.item( "P21_BILL_NO" ).getValue(); // your own item value get second apex.jQuery(function() { apex.theme42.util.configAPEXMsgs({ autoDismiss: true, duration: 3000*my…
If you Want Confirmation Message. Apply this steps..... Button : Save/Create Dynamic Action : Execute javascript code apex.confirm("Are you sure want to Save?","CREATE");
Shared Components--> Navigation Bar list--> Desktop Navigation Bar--> Create Sequnce : --- (as your like) List Entry Label : Youtube Image/Class : --- (as your like) Target Type : URL URL Target : --- (copy to paste facebook/linkedin/youtu…
Step-1 : Simply you create Interactive Report (My report Animals Sell Based) and Select template type as Standard. Step-2 : Create a new item (as like : P4_NOTIFICATION). Type - Hidden Step-3 : Set the Default value for that item ( P4_NOTIFICATION) a…
Table Structure : CREATE TABLE MATERIALS ( ID NUMBER(10), MATERIALS VARCHAR2(50), UNIT_TYPE NUMBER(4) CONSTRAINT PK_MATERIALS_ID PRIMARY KEY (ID); CREATE TABLE PURCHASE_MATERIALS_M ( BILL_NO NUMBER(30), PURC…
Step-1 : If you want Image uplode In Oracle Apex. you must should be create four column. IMAGE BLOB MIMETYPE VARCHAR2(255) FILENAME VARCHAR2(400) IMAGE_LAST_UPDATE TIMESTAMP(4) WITH LOCAL TIME ZONE IMAGE_CHAR…
If you want this. then flowing the steps Step 1 : Create classic Report (as like) select ROWID, dbms_lob.getlength("IMAGE") CARD_TITLE, ANIMAL_TYPE CARD_TEXT, 'Buy Price : '||to_char(BUYING_price,'99,99,999.99') CAR…
SQL> CONN SYS/SYS@ORCLPDB AS SYSDBA Connected. SQL> ALTER USER HR IDENTIFIED BY HR; User altered. SQL> ALTER USER HR IDENTIFIED BY HR ACCOUNT UNLOCK; User altered. SQL> GRANT DBA TO HR; Grant succeeded. SQL> CONN HR/HR@ORCLPDB Connec…
