apex login page wallpaper

1. upload wallpaper & logo
2. Page level inline css paste

span.t-Login-logo {
background-image: url(#APP_IMAGES#color3.jpg);
backgroung-size: cover;
width: 100px;
height: 80px;
}

.t-Body {
background-image:url(#APP_IMAGES#color2.jpg);
background-repeat: no-repeat;
background-size : 100%;
background-position: 25%;
}




//////////////

---Transper login page----

span.t-Login-logo {
background-image: url(#APP_IMAGES#color3.jpg);
backgroung-size: cover;
width: 100px;
height: 80px;
}


body{font-family: 'Droid Arabic Kufi', sans-serif; font-size:1.3rem;}
.t-PageBody--login .t-Body {
background-image: url(#APP_IMAGES#color2.jpg);
background-position: center center;
   background-repeat:  no-repeat;
   background-attachment: fixed;
   background-size:  cover;
background-color: #45484d;
background-color: -moz-linear-gradient(top, #45484d 0%, #000000 100%);
background-color: -webkit-linear-gradient(top, #45484d 0%,#000000 100%);
background-color: linear-gradient(to bottom, #45484d 0%,#000000 100%);
}
body .t-Login-title , .t-Login-region {
    background-color: rgba(128, 152, 180, 0.51);
color: #F8F8F8
}
.t-Login-body {
    text-align: right;
}
.popup
{
  z-index: 10;
margin:100px auto;
display:block;
text-align:center;

-moz-box-shadow: 0 0 10px rgba(0,0,0,.18); /* drop shadow */
-webkit-box-shadow: 0 0 10px rgba(0,0,0,.18); /* drop shadow */
-o-box-shadow: 0 0 10px rgba(0,0,0,.18); /* drop shadow */
box-shadow: 0 0 10px rgba(0,0,0,.18); /* drop shadow */
-webkit-transform-origin:top center;
-moz-transform-origin:top center;
-o-transform-origin:top center;
transform-origin:top center;
-webkit-animation: iconosani 1.2s forwards;
animation: iconosani 1.2s forwards;
-moz-animation: iconosani 1.2s forwards;
-o-animation: iconosani 1.2s forwards;
}
.apex-icons-fontawesome .t-Login-logo{
        font-size: 50px;
        color: #fff; 
}
#P9999_PASSWORD , #P9999_USERNAME  {
background-color: #0e0d0d00;
color: #292929;
font-size: 1.5em;
border-bottom-color: #0464a9;
border-width: 0 0 3px 0;
}





//////



span.t-Login-logo {

background-image: url(#APP_IMAGES#color4.jpg);

backgroung-size: cover;

width: 100px;

height: 80px;

}

body {
  webkit-background-size: cover;
    -moz-background-size: cover;
    -o-background-size: cover;
    background-size: cover;
    background-image:url('#APP_IMAGES#color2.jpg');
  }
  .ui-content.ui-body-a{
    background: rgba(0, 0, 0, 0.1);
  }
  .ui-responsive-panel.ui-page.ui-page-theme-a.ui-page-active{
    background: rgba(0, 0, 0, 0.1);
  }



///////


. Logo span.t-Login-logo { background-image: url(#APP_IMAGES#color4.jpg); background-size: cover; width: 120px; height:120px; } Background Image .t-PageBody--login .t-Body{ background: url(#APP_IMAGES#color2.jpg); background-repeat: no-repeat; background-size: cover; } Transparent login Page .t-Login-region { position: relative; width: 410px; margin: 0 auto; background: rgba(130,130,130,.3); padding: 20px 22px; border: 1px solid; border-top-color: rgba(255,255,255,.4); border-left-color: rgba(255,255,255,.4); border-bottom-color: rgba(60,60,60,.4); border-right-color: rgba(60,60,60,.4); }

item position

/*
 * Dick Dral - Detora @ 2016
 */

/*  Removes the class col-1, col-2 etc. from the div.
 *  This removes the fixed width from the div which gets its
 *  it's width from the content then
 */
function remove_col_x_class( div )
{
  for ( i = 1; i <= 12 ; i++ )
  { $(div).removeClass('col-'+i); }
  return div;
}


/* This function returns the label or input container of an Apex item.
 * These divs can be used to put content on one line.
 */
function get_container_div ( colname, type )
{
  type = ( type.toLowerCase() == 'label' ) ? 'label' : 'input';
  var div = $('#'+colname.toUpperCase()+'_CONTAINER .t-Form-'+type+'Container');
  return div;
}

function position_after ( itemName1, itemName2 )
{
  input1 = remove_col_x_class( get_container_div(itemName1,'input') );
  label2 = remove_col_x_class( get_container_div(itemName2,'label') );
  input2 = remove_col_x_class( get_container_div(itemName2,'input') );
  $(label2).insertAfter( $(input1) );
  $(input2).insertAfter( $(label2) );
}






/////



position_after('P5_BD_QTY','P5_BD_UOM');
position_after('P5_BD_SIZE_QTY','P5_BD_SIZE_UOM');
position_after('P5_PKS_100ML','P5_PKS_100ML_UOM');
position_after('P5_NO_PKS_100ML','P5_NO_PKS_100ML_UOM');
position_after('P5_CON_SIZE','P5_CON_UOM');


position_after('P5_VALID_FRM','P5_REV_NO');



/////


#P5_BD_UOM_LABEL,#P5_BD_SIZE_UOM_LABEL,#P5_PKS_100ML_UOM_LABEL,#P5_NO_PKS_100ML_UOM_LABEL,#P5_CON_UOM_LABEL,#P5_REV_NO_LABEL {
   margin-left: 10px;
   margin-right: 10px;
}

how to click menu bar then expand & collapse in oracle apex

$("#t_TreeNav").on("treeviewactivatenode", function(e, ui) {
var n$ = $(e.originalEvent.target).closest(".a-TreeView-content");
if (ui.nodes.length > 0 && ui.nodes[0].link === "") {
if (n$.parent().hasClass("is-expandable")) {
$(this).treeView("expand", n$)
} else if (n$.parent().hasClass("is-collapsible")) {
$(this).treeView("collapse", n$)
}
}
});

How to configure in Bangla Fonts in Oracle Reports & Apex write bangla fonts and english fonts

1. Database language must be AL32UTF8

2. regedit
   Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\
      All Language change -- NLS_LANG
                             AMERICAN_AMERICA.WE8MSWIN1252
                         to
                             AMERICAN_AMERICA.AL32UTF8

3. Oracle Databse and OracleHome & Oracle Middleware fonts SolaimanLipi.ttf Paste -- in fonts folder
4. registry

default.fontMap.defaultFontname=Dialog

To change

default.fontMap.defaultFontname=Courier New,Courier,courier,System,Terminal,Fixed,Fixedsys,Times,Times New Roman,MS Sans Serif,Arial,Vrinda,SolaimanLipi
default.fontMap.javaFontnames=MonoSpaced,MonoSpaced,MonoSpaced,Dialog,MonoSpaced,Dialog,Dialog,Serif,Serif,Dialog,SansSerif,SolaimanLipi

4. Restart




//
bijoy52
Avro

Both are used in oracle apex  (unicode) for Bangla  and for English Set English

ords on weblogic in oracle apex

1. Install ords 

2 configure ords on weblogic

How to load images into Apex 18.2

There is a problem with your environment because the Application Express files have not been loaded. Please verify that you have copied the images directory to your application server as instructed in the Installation Guide. In addition, please verify that your image prefix path is correct. Your current path is /i/ (it should contain both starting and ending forward slashes, such as the default /i/). Use the SQL script reset_image_prefix.sql if you need to change it.

Reset Image Prefix in Oracle APEx.

Incase u wanna change the Image Prefix being used in your application express then

Run command >cmd


Change the current directory to apex41\apex\utilities.

C:\apex41\apex\utilities > sqlplus
 username : sys as sydba
Password :*****

sqlplus > @reset_image_prefix.sql
It will prompt for entering the new prefix ..

Enter in the form of [/i/]   , so current should be /j/.

Make sure your Application express instance is down else run it in resticted mdoe.


Now you Images will be refered in workspace using the /j/ instead of /i/ and these changes are updated by Oracle apex automticatically for the exisiting references .

Oracle Report - Oracle Report Trigger (Using in Text)

if :sal>='100'
then
 srw.set_text_color('red');
 srw.set_font_face('Arial');
 srw.set_font_size(10);
 srw.set_font_weight(srw.bold_weight);
 srw.set_font_style(srw.plain_style);
 END if;

https://docs.oracle.com/cd/E28280_01/bi.1111/b32122/orbr_condhigh004.htm#RSBDR1536

How to Migrate Oracle Forms 122C to Apex Apex 192

1.

Microsoft Windows [Version 10.0.18362.476]
(c) 2019 Microsoft Corporation. All rights reserved.

C:\WINDOWS\system32>frmf2xml F:\ALL_PROGRMMING\STR\SCL12C\Test12c\MKTG\Forms\MKT_CUSTOMER.fmb
'frmf2xml' is not recognized as an internal or external command,
operable program or batch file.

Error
Then

C:\WINDOWS\system32>cd.

C:\WINDOWS\system32>
C:\WINDOWS\system32>Cd..

C:\Windows>cd..

C:\>D:

D:\>cd D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\components\FORMS\instances\forms1\bin\

D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\components\FORMS\instances\forms1\bin>frmf2xml F:\ALL_PROGRMMING\STR\SCL12C\Test12c\MKTG\Forms\MKT_CUSTOMER.fmb
Oracle Forms 12.2.1 Forms to XML Tool
Copyright(c) 2001, 2017, Oracle and/or its affiliates.  All rights reserved.

Processing module F:\ALL_PROGRMMING\STR\SCL12C\Test12c\MKTG\Forms\MKT_CUSTOMER.fmb
XML Module saved as F:\ALL_PROGRMMING\STR\SCL12C\Test12c\MKTG\Forms\MKT_CUSTOMER_fmb.xml

D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\components\FORMS\instances\forms1\bin>

2. Login & Migrate in Oracle Apex
3.View effect

Collapsed Navigation Menu Entries in oracle apex

---only parents---

.js-navCollapsed .t-TreeNav .a-TreeView-node--topLevel>.a-TreeView-content.is-hover .a-TreeView-label {
visibility: visible;
left: 48px;
padding: 0 16px;
width: auto;
background-color: #0459a1; /* This would be your primary color */
}

.apex-side-nav.js-navCollapsed .t-Body-nav
, .apex-side-nav.js-navCollapsed .t-Body-nav .t-TreeNav {
    z-index: 999; /* Make it appear on top of the page content */
}

////////


---with child ---

.js-navCollapsed .t-TreeNav .a-TreeView-node--topLevel:hover ul {
display: block !important;
position: fixed;
left: 48px;
width: 220px;
padding: 0 0 0 12px;
}

.js-navCollapsed .t-TreeNav .a-TreeView-node--topLevel:hover > ul > .a-TreeView-node {
padding-left: 0px;
}

.js-navCollapsed .t-TreeNav .a-TreeView-node--topLevel:hover .a-TreeView-content .a-TreeView-label {
visibility: visible;
left: 48px;
padding: 0 8px;
width: 220px;
background-color: #0459a1;
}

.apex-side-nav.js-navCollapsed .t-Body-nav,
.apex-side-nav.js-navCollapsed .t-Body-nav .t-TreeNav {
z-index: 999; /* Make it appear on top of the page content */
}

How to Save NodeManaer PASS in Oracle 12C?

Start the standalone reports server and save the NodeManager Password:

cd /u01/app/oracle/user_projects/domains/forms_domain/bin

./startComponent.sh my_repsrv storeUserConfig

You will be prompted to try the nodemanager user password:

Please enter Node Manager password: xxx

Add Comments in Oracle Sql

Comment on column Test_Table.Column_name is     'Materials code';

Comment on column Test.code is     'Materials code';

Oracle user password expired

Modify the default user profile to set the password policies to 'UNLIMITED':

ALTER PROFILE DEFAULT LIMIT COMPOSITE_LIMIT UNLIMITED

  PASSWORD_LIFE_TIME UNLIMITED

  PASSWORD_REUSE_TIME UNLIMITED

  PASSWORD_REUSE_MAX UNLIMITED

  PASSWORD_VERIFY_FUNCTION NULL

  PASSWORD_LOCK_TIME UNLIMITED

  PASSWORD_GRACE_TIME UNLIMITED

  FAILED_LOGIN_ATTEMPTS UNLIMITED;

Create DBLINK

CREATE DATABASE LINK fremoteorcl
   CONNECT TO jnp_inv_rmpm_b IDENTIFIED BY jnp_inv_rmpm_b
   USING 'orcl122';

drop database link FREMOTE10G

----created 

CREATE PUBLIC DATABASE LINK "FREMOTE10G"
   CONNECT TO "JPLDBA" IDENTIFIED BY VALUES 'j'
   USING 'orcl10g';

   desc jnp_inv_rmpm_b.company@fremoteorcl
 
   desc COMPANY_INFO
   select * from tab;
   select * from jnp_inv_rmpm_b.company@fremoteorcl
 

ORA-01031: insufficient privileges when Toad 11.6 connect to an Oracle 12c database

Solution

Access to SYS.USER$ has been restricted in Oracle 12c (for oracle 12c  security , role, privilege, references doc  https://docs.oracle.com/database/121/DBSEG/E48135-19.pdf)

The issue can be resolved by granting access to the SYS.USER$ table to the related user /schemas:

GRANT SELECT ON SYS.USER$ TO <user>;

For grant the privilege login as sys dba

Sqlplus sys/sys_password@orcl  as sysdba

SQL> GRANT SELECT ON SYS.USER$ TO <user_name>;

Grant succeeded.

Reference Oracle Doc ID 1958777.1)

how to connect cmd to directory in window 10

Microsoft Windows [Version 10.0.18362.418]
(c) 2019 Microsoft Corporation. All rights reserved.

C:\WINDOWS\system32>cd c
The system cannot find the path specified.

C:\WINDOWS\system32>cd C:\

C:\>cd D:\

C:\>cd D:
D:\

C:\>D:\
'D:\' is not recognized as an internal or external command,
operable program or batch file.

C:\>cd D:\

C:\>Cd
C:\

C:\>cd D
The system cannot find the path specified.

C:\>cd D:\

C:\>D:

D:\>Oracle

D:\>
D:\>
D:\>

Menu Expand & Collapse in Oracle Apex

---19 or above

Function and Global Variable Declaration

(function(ut, $) {

var TREE_NAV_WIDGET_KEY = 'nav';

$(window).on('theme42ready', function() {
    /* Make sure that the navigation menu is collapsed on page load */
    if (ut.toggleWidgets.isExpanded(TREE_NAV_WIDGET_KEY)){
        ut.toggleWidgets.collapseWidget(TREE_NAV_WIDGET_KEY);
    }

    /* Expand on mouse over, collapse on mouse out */
    $('.apex-side-nav.js-navCollapsed .t-Body-nav').hover(
        function(){
            ut.toggleWidgets.expandWidget(TREE_NAV_WIDGET_KEY);
        },
        function() {
            ut.toggleWidgets.collapseWidget(TREE_NAV_WIDGET_KEY);
        }
    );
});

})(apex.theme42, apex.jQuery);


---19 or above

Function and Global Variable Declaration

$(window).on("theme42ready", function() {
if ($("body").hasClass("js-navExpanded")) {
$("#t_Button_navControl").click();
}

$(".apex-side-nav.js-navCollapsed .t-Body-nav").hover(
function(){
$("#t_Button_navControl").click();
},
function(){
$("#t_Button_navControl").click();
}
);

});

select 1st and 15th of every month

select to_char(days, 'fmMon ddth'||' - '||'fmmm/dd/yyyy') days
    from
       (select sysdate + level as days
       from dual
        connect by level <= to_date ('09/30/2008', 'mm/dd/yyyy') - sysdate)
   where extract(day from days) in (1, 15)
   /

DAYS
---------------------
Jun 15th - 06/15/2008
Jul 1st - 07/01/2008
Jul 15th - 07/15/2008
Aug 1st - 08/01/2008
Aug 15th - 08/15/2008
Sep 1st - 09/01/2008
Sep 15th - 09/15/2008

SQL> SELECT TO_CHAR(TO_DATE('1900-01-01', 'YYYY-MM-dd'), 'dth')
  2    FROM DUAL
  3  /

TO_
---
2nd

SQL> select ADD_MONTHS(trunc(sysdate,'YEAR'),12)-1 from dual
  2  /

ADD_MONTH
---------
31-DEC-19

SQL> select trunc(to_date('18-sep-2006','dd-mon-yyyy'),'year') from dual;

TRUNC(TO_
---------
01-JAN-06

SQL> SELECT round(sysdate,'YYYY'),add_months(trunc(sysdate,'YYYY')-1,12) from dual
  2  /

ROUND(SYS ADD_MONTH
--------- ---------
01-JAN-20 31-DEC-19


There's an in-built SQL function to do this.

Function Name: TRUNC

SQL> SELECT TRUNC(TO_DATE('17-DEC-2001'),'YEAR') "First Day" FROM Dual;

First Day
---------
01-JAN-01

SQL> SELECT TRUNC(SysDate,'YEAR') "First Day" FROM Dual;

First Day
---------
01-JAN-02

https://www.viralpatel.net/useful-oracle-queries/

alter all in oracle sql database

RENAME old_table TO new_table;

RENAME iv_mssql_applicant_inf TO MSSQL_COLLECTIONS

cgicmd.bat report run

file location E:\wapp\config\domains\base_domain\config\fmwconfig\servers\WLS_REPORTS\applications\reports_12.2.1\configuration

;pdfenhancements:    userid=oe report=utf8test.rdf destype=cache desformat=pdf

quiumdba: server=rep_wls_reports_ipihr userid=hr/i@orcl destype=cache desformat=pdf paramform=no %*
quiumdbaexl: server=rep_wls_reports_ipihr userid=hr/i@orcl destype=cache desformat=spreadsheet paramform=no %*




///
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;                                                 ;
; OracleAS Reports Services                       ;
; CGICMD.DAT                                      ;
;                                                 ;
; Example CGICMD.DAT Mapping file                 ;
;                                                 ;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;
; Syntax: 
;      KEY : VALUE
; Where:
; KEY - the first argument of the rwservlet URL request (case sensitive).
; VALUE - command line parameters and/or special parameters.
;
; Keys can be referenced in the following ways:
;
;    1. Parameter on command line to the reports servlet
;          e.g. http://machine/servlet/rwservlet?KEY
;
;    2. Parameter on command line to a reports jsp
;          e.g. http://machine/mydir/myreport.jsp?KEY
;
;    3. Within a reports jsp - in the rw:report custom tag
;          e.g. <rw:report parameters="KEY">
;
; In addition to the Reports Server command line parameters, VALUE can include special parameters
; represented as "%X", where X identifies the parameter. Currently recognized special
; parameters:
;
;  %0 - %9 - 0..9 arguments from original rwservlet URL request. Note that %0 refers to the key itself.
;  %* - entire contents (all arguments) of original rwservlet URL request.
;  %D - request users to input database userid everytime they run the report.
;  %P - request for report parameter form in HTML format. It generates the PARAMFORM=HTML
;       construction on the first submission of the URL and PARAMFORM=NO upon parameter form submission.
; CGICMD.DAT Usage Notes
;   1. Multiple keys in this file MUST be separated by an EXTRA empty line.
;   2. Extra spaces are ignored. Multi-line entries allowed.
;   3. Lines starting with ";" character are treated as a comments.
;   4. Comments within a key or key value are NOT allowed.
;   5. NLS language support is provided and can be used (encoding should match the one
;      used in HTML request - no language conversion of any kind is attempted.
;   6. For %P special parameter, HTML format is by default mapped to the HTMLTABLE format in this release.
;      The HTML format in the future may be mapped to the HTMLCSS format.
;
;;;;;;;;;;;; Example Key Entries
;  Example 1:  Run a simple breakb report and output to HTML
orqa: report=breakb.rdf destype=cache desformat=html server=repserver

; Example 2: prompt for userid the first time, then use database userid stored in the cookie subsequently.
report_defaultid: report=breakb.rdf destype=cache desformat=html server=repserver

; Example 3: use %D to require user authentication every time
report_secure: report=breakb.rdf destype=cache desformat=html server=repserver %D

; Example 4:  Take all arguments from URL and send it to the reports server
run: %*

; Example 5:  Run breakb report with HTML parameter form.
breakbparam : report=breakb.rdf destype=cache desformat=html server=repserver userid=scott/tiger@mydb %P

; Example 6: take all URL arguments, and also generate a HTML parameter form 
runp: %* %P

; Example 7: Run an Express Report. Replace <MYHOST> with the name of the machine running the Express server. The
; builder on-line help explains the rest of the parameters (the /sl, st etc. etc.)
express: report=my_expr_rep express_server="server=ncacn_ip_tcp:<MYHOST>/sl=1/st=1/ct=0/sv=1/" desformat=htmlcss userid=scott/tiger@mydb destype=cache server=repserver

;;;;;;;;;;;; Keys for Reports Demos
; Using default/in-process server.
; JSPs
;charthyperlink_ias: userid="scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=%DBHOSTNAME%)(PORT=%DBPORT%))(CONNECT_DATA=(SID=%DBSID%)))" %*

;charthyperlink_ids: userid=scott/tiger@ %*

;barcodeweb:         userid=oe

;parmformjsp:        userid=oe

;tutorial:           userid=oe

; Paper Reports
;xmldata:            userid=oe report=inventory_report.rdf destype=cache p_filelocation="http://%HOSTNAME%:%OC4JPORT%/reports/examples/xml_pds/scripts/" desformat=pdf

;barcodepaper:       userid=oe report=shippingmanifest.rdf destype=cache desformat=pdf

;distributionpaper:  userid=oe report=inventory_report_dist.rdf distribute=yes destination=exampledistribution.xml

;pdfenhancements:    userid=oe report=utf8test.rdf destype=cache desformat=pdf

quiumdba: server=rep_wls_reports_ipihr userid=jpldba/j@ipihr destype=cache desformat=pdf paramform=no %*
quiumdbaexl: server=rep_wls_reports_ipihr userid=ipihr/i@ipihr destype=cache desformat=spreadsheet paramform=no %*

;;;;;;;;;;;;


///

asaduzzaman

asaduzzaman

How to Run oracle report in oracle apex

javascript:var x=window.open('http://172.16.1.93:9002/reports/rwservlet?userid=ipihr/i@ipihr&desformat=PDF&p_unit='+  document.getElementById('P36_UNIT').value +'&p_INTERVIEW_DATE='+  document.getElementById('P36_INTERVIEW_DATE').value +'&p_DEPARTMENT='+  document.getElementById('P36_DEPARTMENT').value +'&p_DESIGNATION='+  document.getElementById('P36_DESIGNATION').value +  '&destype=cache&report=e:/global/Stepshr/hr/report/interview_list','_blank');


javascript:var x=window.open('http://172.16.1.93:9002/reports/rwservlet?userid=ipihr/i@ipihr&desformat=spreadsheet&P_MODULE_ID='+ document.getElementById('P1_MODULE_ID').value 
 +

 '&destype=cache&report=E:/IT_FORMS/IT _Module_wise_feedback_list_1.jsp','_blank');


javascript:var x=window.open('http://172.16.1.93:9002/reports/rwservlet?userid=ipihr/i@ipihr&desformat=PDF&P_SLNO=#SLNO#'  +''+  '&destype=cache&report=e:/jayson/hr/reports/az_old_interview_inv.jsp','_blank');

How to Configure ORDS in Apache Tomcat with oracle Apex

1. All folder Create in same directory 
2. Version : apache-tomcat-8.5.11.exe 
                    jre-8u221-windows-x64.exe
                    ords-18.3.0.270.1456.zip

or check apache-tomcat what do want it..

3. All Java/ Apache - Tomcat File Clear from your PC Regedit/  C Drive etc and 

4. Restart PC

Start Now 

 Conn Sys as sysdba

alter user apex_public_user acount unlock;

alter user apex_public_user identified by Databsae#1;

alter user ORDS_PUBLIC_USER identified by Databsae#1;

Open CMD  
Microsoft Windows [Version 10.0.17134.1006]
(c) 2018 Microsoft Corporation. All rights reserved.

C:\Users\AbdulQuium>cd..

C:\Users>cd..

C:\>cd C:\Oracle\Apex_listener     ---Ords Location 

C:\Oracle\Apex_listener>java -jar ords.war
This Oracle REST Data Services instance has not yet been configured.
Please complete the following prompts

Enter the location to store configuration data:C:\Oracle\Apex_listener
Enter the name of the database server [localhost]:
Enter the database listen port [1521]:
Enter 1 to specify the database service name, or 2 to specify the database SID [1]:2
Enter the database SID [xe]:orcl
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:

Retrieving information.
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:
Enter the database password for APEX_PUBLIC_USER:
Confirm password:
Enter 1 to specify passwords for Application Express RESTful Services database users (APEX_LISTENER, APEX_REST_PUBLIC_USER) or 2 to skip this step [1]:2
Sep 27, 2019 3:16:10 AM
INFO: reloaded pools: []
Sep 27, 2019 3:16:10 AM oracle.dbtools.rt.config.setup.SchemaSetup install
INFO: Oracle REST Data Services schema version 18.3.0.r2701456 is installed.
Enter 1 if you wish to start in standalone mode or 2 to exit [1]:2

C:\Oracle\Apex_listener>


///
Open CMD 

Microsoft Windows [Version 10.0.17134.1006]
(c) 2018 Microsoft Corporation. All rights reserved.

C:\Users\AbdulQuium>cd..

C:\Users>cd..

C:\>cd C:\Oracle\apex_19.1\apex

C:\Oracle\apex_19.1\apex>sqlplus sys as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Sep 27 04:32:26 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> @apex_rest_config.sql

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Enter a password for the APEX_LISTENER user              []
Enter a password for the APEX_REST_PUBLIC_USER user              []
...set_appun.sql
...create APEX_LISTENER and APEX_REST_PUBLIC_USER users

PL/SQL procedure successfully completed.
........
............

////

OPEN CMD

C:\Oracle\apex_19.1\apex>sqlplus

SQL*Plus: Release 12.2.0.1.0 Production on Fri Sep 27 02:53:39 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Enter user-name: sys as sysdba

Enter password:

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> start apxconf.sql

      PORT

----------

      8383

Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.

Default values are in brackets [ ].

Press Enter to accept the default value.

...set_appun.sql

================================================================================

This script can be used to change the password of an Application Express

instance administrator. If the user does not yet exist, a user record will be

created.

================================================================================

Enter the administrator's username [ADMIN]

User "ADMIN" exists.

Enter ADMIN's email [quium2@gmail.com]

Enter ADMIN's password []

Changed password of instance administrator ADMIN.

Enter a port for the XDB HTTP listener [      8383] 0

...changing HTTP Port

_____________________

star apxconf.sql scripts

enter admin_name email, & password

XDB HTTP listener [8080] :--0

pw : $Abcd_1234

____________________

////

C:\Oracle\Apache_Tomcat_8.5\Tomcat 8.5\webapps\ Paste ORDS.war File

C:\Oracle\apex_19.1\apex\images  all iamges file paste TO

C:\Oracle\Apache_Tomcat_8.5\Tomcat 8.5\webapps\i 

Change 

C:\Program Files\Apache Software Foundation\Tomcat 8.5\conf\server.xml

     <Host name="localhost"  appBase="webapps"

            unpackWARs="true" autoDeploy="true">

   <!----image pathname -->

      < Context docBase="C:\apex\images" path="/i" />

     <!----< Context docBase="C:\Oracle\apex_19.1\apex\images" path="/i" /> -->

Check :
Apache tomcat  : http://localhost:8080/
Apex                 : http://localhost:8080/ords

Thanks 

https://www.youtube.com/watch?v=I814NV_dzNs

How to show profile picture in top right Conner in oracle apex

1. Table Scripts
 create table emp1
 (
  EMPNO                                              NUMBER(4)
 ,ENAME                                              VARCHAR2(10)
 ,HIREDATE                                           DATE
 ,IMAGE                                              BLOB
 ,IMG_TYP                                            VARCHAR2(100)
 ,IMG_NM                                             VARCHAR2(100)
)


2. Create application item in sharecomponnent
Name          :  FILE_ID
Condition     : Unrestricted

3. Create Application Processes

Name          : GETIMAGE
Process Point : Ajax Callback: Run this application process when requested by a page process.

PL/SQL Anonymous Block Code


begin
    for c1 in (select * from emp1
                where EMPNO = :FILE_ID) loop
        --
        sys.htp.init;
        sys.owa_util.mime_header( c1.img_typ, FALSE );
        sys.htp.p('Content-length: ' || sys.dbms_lob.getlength( c1.IMAGE));
        sys.htp.p('Content-Disposition: attachment; filename="' || c1.img_nm || '"' );
        sys.htp.p('Cache-Control: max-age=3600');  -- tell the browser to cache for one hour, adjust as necessary
        sys.owa_util.http_header_close;
        sys.wpg_docload.download_file( c1.IMAGE );
   
        apex_application.stop_apex_engine;
    end loop;
end;

4.
Shared ComponentsList\ Details\ Create Entry
Template : Nabigation Bar
         : Check Transalator
first row paste
<img style="width:42px;height:42px;border-radius: 50px;" class="t-Icon a-Icon" src="f?p=&APP_ID.:0:&APP_SESSION.:APPLICATION_PROCESS=GETIMAGE:::FILE_ID:&APP_USER.">

Thanks

//or
<img style="width:30px;height:30px;" class="t-Icon a-Icon" src="f?p=&APP_ID.:0:&APP_SESSION.:APPLICATION_PROCESS=GETIMAGE:::FILE_ID:&APP_USER.">



Theme Roller  CSS for remove background box in oracle apex...

.t-Button--navBar .t-Button-badge { border-radius: 16px; background-color: #0076df; }

how to solved Apex Applications manu bar may not show on mobile device

You can solve this problem by doing this Dynamic Action.

1. Create a Dynamic Action in  0 page.

2.Set Event  : Page Load  Execute JavaScript Code

3. Set Action : Execute JavaScript Code Now you can try on mobile device

4. Then copy pest this JavaScript  Code :

$(".t-Header-nav").removeClass("t-Header-nav");

Now you can try on mobile device.

marquee in oracle apex using html

<marquee behavior="scroll" direction="left" scrollamount="10">Fast Scrolling</marquee>

<marquee> This is a marquee </marquee>

<marquee direction="right">Welcome to Star Ceramics Limited in Bangladesh                                                                                            </marquee>

<marquee behavior="alternate">Welcome to Star Ceramics Limited in Bangladesh  </marquee>


<marquee behavior="scroll" direction="left" scrollamount="10">Fast Scrolling</marquee>

<marquee direction="scroll">A scrolling text created with HTML Marquee element and styled with CSS properties.</marquee>

<marquee behavior="alternate">This is alternate behavior of a marquee </marquee>

<marquee scrolldelay="10">This is a marquee with scrolldelay 10</marquee>
<marquee scrolldelay="25">This is a marquee with scrolldelay  25</marquee>
<marquee scrolldelay="50">This is a marquee with scrolldelay  50</marquee>
<marquee scrolldelay="100">This is a marquee with scrolldelay  100</marquee>
<marquee scrolldelay="200">This is a marquee with scrolldelay  200</marquee>
<marquee scrolldelay="300">This is a marquee with scrolldelay  300</marquee>
<marquee scrolldelay="500">This is a marquee with scrolldelay  500</marquee>
<marquee scrolldelay="1000">This is a marquee with scrolldelay  1000</marquee>

<marquee onmouseover="stop()">This marquee will stop on mouseover.</marquee>

<marquee onmouseover="stop()" onmouseout="start()">This marquee will stop on mouseover and restart on mouseout.</marquee>

oracle apex item shape round

item  -->> advance -->> attribute

 style="border:.1em solid #309fdb;width: 50%;border-radius: 20px;"

last row in oracle table in sql

select
  EMP_ID
from
  IT_INV_ISSUE_FORM
where
  rowid =(
    select
       max(rowid)
    from
       IT_INV_ISSUE_FORM)

apex profile pic

$('html')
   .bind(
       'click',
       function(e) {
              if ($('#exitpopup_bg').dialog('isOpen') &&!$(e.target). is('.ui-dialog,a') && !$(e.target).closest('.ui-dialog').length && !$(e.)
                 
                  $('.image_icon').removeClass('et');
                  $('.image_icon').addClass('st');
                 }
            }
      }

);


var imageurl=$('#P1_IMAGE').attr('src');
$('.image_icon').css('background-image','url('+imageurl + ')');


select profile_img from user_control
where user_name='AAA';
&PROFIL.
image_icon st

&PROFIL.








////////////////////////////////

/* Close when click Outside the Dialog*/
$('html')
    .bind(
        'click',
        function(e) {
            if ($('#exitpopup_bg').dialog('isOpen') && !$(e.target).is('.ui-dialog, a') && !$(e.target).closest('.ui-dialog').length && !$(e.target).is('.image_icon')&&!$(e.target).is('.ui-dialog-titlebar-close')) {
                $('#exitpopup_bg').dialog('close');


                $('.image_icon').removeClass('et');
                $('.image_icon').addClass('st');
            }
        }
    );



var imageurl=$('#P1_IMAGE').attr('src');
$('.image_icon').css('background-image','url('+imageurl + ')');


select IMAGE from EMP1
where EMPNO=210
&PROFIL.
image_icon st

&PROFIL.

refresh using htlm in apge

page html header --


<meta http-equiv="refresh" content="10">

how to update table using cursor with number of total update rows display in sql command

set serveroutput on

DECLARE 
   total_rows number(2); 
BEGIN 
   UPDATE  STUDENT 
   SET CITY = 'Dhaka'
   where stid in ('1','2'); 
   IF sql%notfound THEN 
      dbms_output.put_line('no customers updated'); 
   ELSIF sql%found THEN 
      total_rows := sql%rowcount; 
      dbms_output.put_line( total_rows || ' customers updated '); 
   END IF; 
END; 
/

Connect Sql Developer to MySql Database

Upload an Excel file into an Apex Collection Using Plugins

1. Download Excel2Collection plugins sql file
2. Create a page and a Region for uploading Excel file with a FILE BROWSE item
   and a button for UPLOAD. Choose SQL insert action as Database Action.
3. Create a another Region for showing uploaded excel report as CLASSIC REPORT.
   The SQL will be like :     Select * from apex_collections ;
 
4. Now create a PROCESS for the taking the PLUGIN as type Excel2Collection(Plugin).
   Then provide file browse item name in  BROWSE FILE give a name for COLLECTION NAME .
 
5. Now just upload a excel file then it will show in Classic Report from apex_collections table.
 
 

BEGIN
   INSERT INTO excle_1

 SELECT C001,
              C002,
              C003   
         FROM apex_collections
        WHERE COLLECTION_NAME ='ATTN_DATA' ;
       
END;
IF APEX_COLLECTION.COLLECTION_EXISTS (p_collection_name => 'ATTN_DATA') THEN

--IF APEX_COLLECTION.COLLECTION_EXISTS (p_collection_name => 'ATTN_DATA') THEN
           --APEX_COLLECTION.DELETE_COLLECTION (p_collection_name => 'ATTN_DATA');
            apex_collection.truncate_collection (p_collection_name=>'ATTN_DATA');

 else null; end if;

Force Upper Case in Text Field

Advance --->>Custom Attributes  -->>

style="text-transform: uppercase;" onKeyUp="this.value=this.value.toUpperCase();"

report & column width fixed in oracle apex

Advanced --> Custom Attributes
forms column -- 
style="display:block;width:250px"

report item ---
<span style="display:block; width:200px">#COLUMN_NAME_OF_REPORT#</span>

#P75_DIVISION1,#P75_DISTRICT1{
   width: 40% !important;    
}

#P75_REGION_LIST{
   width: 15.5% !important;    

}

Position items next to each other in oracle apex

1. Function and Global Variable Declaration

/*
 * Dick Dral - Detora @ 2016
 */

/*  Removes the class col-1, col-2 etc. from the div.
 *  This removes the fixed width from the div which gets its
 *  it's width from the content then
 */
function remove_col_x_class( div )
{
  for ( i = 1; i <= 12 ; i++ )
  { $(div).removeClass('col-'+i); }
  return div;
}


/* This function returns the label or input container of an Apex item.
 * These divs can be used to put content on one line.
 */
function get_container_div ( colname, type )
{
  type = ( type.toLowerCase() == 'label' ) ? 'label' : 'input';
  var div = $('#'+colname.toUpperCase()+'_CONTAINER .t-Form-'+type+'Container');
  return div;
}

function position_after ( itemName1, itemName2 )
{
  input1 = remove_col_x_class( get_container_div(itemName1,'input') );
  label2 = remove_col_x_class( get_container_div(itemName2,'label') );
  input2 = remove_col_x_class( get_container_div(itemName2,'input') );
  $(label2).insertAfter( $(input1) );
  $(input2).insertAfter( $(label2) );

}

.2. Execute when Page Loads

position_after('P87_NEW_2','P87_NEW_3');

New Feature in Oracle Apex 19.1

1) New Page Region Type: Form Region

i) Source = Table, SQL based, or PL/SQL returning SQL Query

ii) Page Item Source references Form Region (not Table synchronizes Page Items with Form Query

3) Write data using REST Enabled SQL

4) REST Enabling Database Objects

5) Improve Data Loading

6) APEX_DATA_PARSER

7) Oracle JET 6.1.0

8) Status Meter Gauge (Replaces Dial Gauges)

9) Enhancement in Interactive Grids like Flashback etc.

10) Dynamic Actions – Addition of actions to open/close regions

11) App Builder Authentication – Can now use Social Login

12) Improved Translation Editing

Read only or disable a Datepicker field but Enable Date Icon in Oracle apex

Date item Properties 

Advanced

Custom Attributes  :   readonly="readonly"  or disabled="disabled"  or  just disabled

 Layout

or Custom Attributes:  onkeydown="return false"

Prevent a duplicate page submit in oracle apex

1. Prevent duplicate page  using java-scripts
2. Prevent duplicate page using button disabled
3. Prevent duplicate page using page setting no

• Before Page Submit
• Execute java scripts code

$("body").append('<div class="ui-widget-overlay ui-front"/>');
apex.widget.waitPopup();
////

$("body").append('<div class="ui-widget-overlay ui-front"/>'); apex.widget.waitPopup();

Multiple Oracle APEX sessions in a browser

1. Open hosts  file
C:\Windows\System32\drivers\etc
2.
10.10.17.21      apexdev01       
10.10.17.21      apexdev02     
10.10.17.21      apexdev03     

http://apexdev01:8181/apex/f?p=4000:1
http://apexdev02:8181/apex/f?p=4000:2
http://apexdev03:8181/apex/f?p=4000:3

How multiple parameter pass using IN operator in oracle report

There's a hero that comes to rescue, and his name is lexical parameter.

You said that your query looks like this:

select * 
from CEP_TABLE 
where Table_ID in (:P_IDLIST) 

Report already contains parameter named p_idlist. Now create another one, manually; let's call it lex_idlist. Its datatype should be character, its length somewhat larger than p_idlistparameter's (for example, if p_idlist is character(50), make lex_idlist character(70)).

Then rewrite query as follows:

select *
from cep_table
&lex_idlist

Go to After Parameter Form trigger which should look like this:

function AfterPForm return boolean is
begin
  :lex_idlist := 'where table_id in (' || :p_idlist || ')';
  return (TRUE);
end;

select * from 
tab 
&lex_idlist

1. create param1, param2, param3 
2. create lexical parameter param1
3. After Parameter Form trigger  fuction