INPUT UPPER CASE IN ORACLE APEX

INPUT UPPER CASE IN WITHOUT CAPS LOCK IN ORACLE APEX BY USING
JavaScript or CSS

JavaScript: Use it in custom attribute : onKeyUp="this.value=this.value.toUpperCase();"

CSS: Use it as CSS :  style="text-transform: uppercase;"

Text Field Auto CSS

.t-Form-inputContainer input[type="text"], .t-Form-inputContainer input.text_field,

.t-Form-inputContainer input.password, .t-Form-inputContainer textarea.textarea,

.t-Form-inputContainer input.datepicker, .t-Form-inputContainer span.display_only,

.t-Form-inputContainer input.popup_lov, .t-Form-inputContainer select,

.u-TF-item--text, .u-TF-item--textarea, .u-TF-item--datepicker, .u-TF-item--select {

    width: 100px;

    box-sizing: border-box;

    border: 5px solid #ccc;

    border-radius: 10px;

    font-size: 16px;

    background-color: white;

    background-position: 10px 10px; 

    background-repeat: no-repeat;

    padding: 12px 20px 12px 40px;

    -webkit-transition: width 0.4s ease-in-out;

    transition: width 0.4s ease-in-out;

}

input[type=text]:focus {

    width: 100%;

}

Date Picker and Interactive Report Manu Over Lapping Problem in Oracle Apex

If any where over all date picker day and interactive report manu then you can try like this.
Go to report  User Interface then  select Display Point: body and Template : Form Region.

Then save and try.

Date Picker Month and Year Navigation in Oracle Apex

In this picture here we see Month and Year Navigation bar. Normally in apex it is not available.  But it can enable.
1. Goto date picker setting then select Navigation list for : month and year
 and set range of year.

How To Create a Scroll Top/Down/Right/Left for a Report in Oracle Apex

How To Create a Scroll Top/Down/Right/Left for a Report in Oracle Apex

1. First goto Report Attribute 
2. Goto Heading and Fixed to: Region
3. Then set a suitable Maximum Report Height. 
4.Then goto pagination and set pagination  type: Row Ranges X to Y Of Z to showing report next button. 

Invalid set of rows requested, the source data of the report has been modified. Reset Pagination

Invalid set of rows requested, the source data of the report has been modified.
Reset Pagination

It's a very common problem. But still many of us have not any more idea about this. Actually it's happen for data page structure. Some times when we see more(next page) values from a report and then load another page like the same report then it might by seen this problem. After clicking "Reset Pagination" you may get the value. To solve this problem you can try this.

1. Create a  Page Processing Branch  and set Branch Point After Processing. 

2. Go Action and set Target type : Page in this Application.  And finally click radio button      reset pagination for this page 

3. Now save the process and load the page this time you will not face the problem..

Fixed a Static Value to Get data In Oracle Apex 5

Now I am going to describe about a Fixed static value by which we can retrieve data from database by Select List, Popup Lov.
Here I show an example too.
1. First Create a item with  Select List /Popup Lov and set a static value in Default option Default value.
2. Then make a query like this

    select 'ALL' ret ,'ALL' dis   from dual 
   union all
   select column_name ret , column_name dis  from TABLE  ;
Now you can get data respecting this query and by showing Static Value.

MongoDB Tutorial PDF (Know about MongoDB)

MongoDB is a NoSQL and open source document database. MongoDB is developed by 10gen in 2007 and release in 2009. Using MongoDB create and deploy high scale able and performance-oriented database.
Here I provide you an excellent PDF tutorial to learn MONGODB easily. I am studying this PDF and get a lot of idea and learn many things from this PDF.   DOWNLOAD PDF

Changing Oracle HTTP port

set your new port in the parameter place

Upload an Excel file into an Apex Collection Using Plugins

First download the Plugins and install to your APEX environment. Link is here  DOWNLOAD  (insert "demo" as username and password).

 1.  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. 

2.  Create a another Region for showing uploaded excel report as CLASSIC REPORT. The SQL will be like :     Select * from apex_collections ;

3.  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 . 

4.   Now just upload a excel file then it will show in Classic Report from apex_collections table.

if you want to insert the excel data into database. Then make a database table  according to all column of the excel.

Then use query like this :  

BEGIN
   INSERT INTO DATABASE_TABLE_NAME  
(NAME OF ALL COLUMN  )

      (SELECT C001,
              C002,
              C003,
              C004
    ALL COLLECTION TABLE'S COLUMN NAME WHAT EVER YOU WANT TO INSERT
              
         FROM apex_collections
        WHERE COLLECTION_NAME = 'use the collection name what you provide at the time of calling Plugin' 
AND SEQ_ID > 1(more then 1 because row number 1 will be the column name));
END;