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.