1. Function and Global Variable Declaration
function myfnc(){
apex.submit('exeprc');
$('#OPN').trigger('click');
}
2. Process >> Server side condition >> Type>> Request is contained in value >> exeprc
3. Button Redirect to URL : javascript:myfnc();
4. Second Button ID : OPN
Version 11 g
1. 11g have not PDB (Pluggable Database)
2. 11g (g for Grid Computing)
3. Released in 2008
4. Dose Not have Cloud Support
5. Oracle 11g does not provide in-memory capabilities
6. No JSON support
Version 12c
1. 12c starts PDB
2. 12c (C for Cloud)
3. Released in 2014
4. PDB and multitenant architecture
5. Starts Cloud Service
6. Oracle 11g provide in-memory capabilities
7. Support JSON
8. Better performance in input/output then 11 G
NEW :
1.Online migration of an active data file
2.Online table partition or sub-partition migration
3.Invisible column
4.Multiple indexes on the same column
5.DDL logging
6.Temporary undo in- and- outs
7.New backup user privilege
8.How to execute SQL statement in RMAN
9.Table level recovery in RMAN
10.Restricting PGA size
Version 18c
1. Starts Autonomous Database (self-driving, self-securing,self-reparing)
2. Released in 2018
3.Manage private temporary tables
4.Use the Data Pump Import CONTINUE_LOAD_ON_FORMAT_ERROR option
5.Convert a HASH partitioned table to a RANGE partitioned table, online
6.Convert a LIST partitioned table on two keys to a LIST AUTOMATIC partitioned table on one key, online
7.Convert a LIST AUTOMATIC partitioned table to a LIST AUTOMATIC partitioned table with SUBPARTITIONING, online
8.Merge partitions of partitioned tables online
9.Use batched DDL
Version 19c
1. Released in 2019
2. Query Quarantine
3. JSON Support (Intrudesed new JSON functions)
4. Automatic Indexing
5. Hybrid Patitioned Tables
6. Active Data Guard
7.19c is the final 12.2 release (equivalent to 12.2.0.3)
8.19c can be deployed as a BM, VM or Exadata database, or as Autonomous
9.Deploying currently uses on 19c by default
10.To benefit from Autonomous Database features, it must be specifically selected during DBS creation
1. Create a item like
P1_MOBILENO
2.Copy-Pest the code into function and Global variable Declaration
$( document ).ready(function() {
$("#P1_MOBILENO").click(function(){
var lnk='tel:+88'+this.value;
// alert(lnk);
window.open(lnk, '_self');
});
HTML:
<li class="t-NavigationBar-item #A02#"><input type="search" id="searchid" placeholder="Search You Product..." name="search"> <button id='searchbtid'type="submit"><i class="fa fa-search"></i></button> <a class="t-Button t-Button--icon t-Button--header t-Button--navBar" href="#LINK#"> <span class="t-Icon #ICON_CSS_CLASSES#"></span><span class="t-Button-label">#TEXT_ESC_SC#</span><span class="t-Button-badge">#A01#</span> </a></li>
CSS:
<style>
#searchid{ height: 30px;
width: 500px;
}
#searchbtid{
margin-right: 200px;
height: 30px;
padding-top: 2px;
padding-left: 9px;
}
</style>
Java Script:
$('#searchid').keyup(function() {var searchVal = document.getElementById("searchid").value ;
$s("P0_SEARCH", searchVal);});
1. Make a ID in region Static ID
2. Page CSS Inline
#ID .t-fht-thead{
overflow: auto !important;
}
1. Copy The Below Code to Page Function and Global Variable Declaration. function validateNumber(event) {
var keyCode = event.keyCode;
var excludedKeys = [8, 37, 39, 46];
if (!((keyCode >= 48 && keyCode <= 57) ||
(keyCode >= 96 && keyCode <= 105) ||
(excludedKeys.includes(keyCode)))) {
console.log("alphabets are not allowed");
event.preventDefault();
}
console.log("keycode: " + keyCode);
}2. And Copy the below function Calling on Item Custom Attribute.onkeydown="return validateNumber(event)";
Here are the steps to convert and get the character into a region by Oracle Apex. Step1. Create a page and Copy-Pest the below code into Pa...
