Search This Blog

Wednesday, December 30, 2020

One Button Click Two Button Action In Oracle Apex

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

Monday, December 7, 2020

How to Import Existing an Application Into Qliksense Desktop.

It's very simple . Just Copy-Pest the application into this path of your desktop. Then open Qliksense hub.

C:\Users\User\Documents\Qlik\Sense\Apps

Thank You.

Thursday, December 3, 2020

Difference Between Oracle 11g , 12c, 18c, 19c Versions And New Features

 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


Restrict File Upload by File Type in Oracle Apex

If you want to restrict file upload by file type/extension/format you can follow the below steps.  Goto File Browser Item --> Advanced --...