How to create list of all file name from your google drive folder !!!

Step 1.  Create a random spreadsheet from your google account. 

Step 2. Click on  spreadsheet Tools >> Script editor  (There will be open a new tab with javascript editor)

Step 3. Clear the editor and Copy Pest the below code and press on save button like below image .

function ListExportFunction() {
  var folderName = 'SEAMAP_GA_Longline'; // Google Drive Just Folder Name
  var folderlisting = 'listing of folder ' + folderName;
  
  var folders = DriveApp.getFoldersByName(folderName)
  var folder = folders.next();
  var contents = folder.getFiles();
  var contents = folder.getFiles();
  
  var ss = SpreadsheetApp.create(folderlisting);
  var sheet = ss.getActiveSheet();
  sheet.appendRow(['name','link']);
  
  var file;
  var name;
  var link;
  var row; 
  while(contents.hasNext()){
    file = contents.next();
    name = file.getName();
    link = file.getUrl();
    sheet.appendRow([name, link]);
  } };

Step 4. Finally Run the code by clicking run button like below image.  ( In this time browser may ask for allow to access your google drive. You have to allow it. Don't worry it's google script editor so it's safe )

Step 5. After successfully execution there will show a completed message like below image. 

That's  All. Now Check Your Drive Home Page With Your Folder Name Including "listing of folder"  File Name. 

Integrating APEX with Oracle E-Business (EBS) Suite hosting in the same hostname.

Follow the steps given below to call the APEX application from EBS

Know About EBS (EBS User's Guide)

Step 1: Create an Oracle Apex Application and go to Shared Components => Application Items, then create the following items,

Application Items 

Scope: Application

Session State Protection: Restricted – May not be set from the browser

Step 2: Compile the apex_global package(apex_global.check_ebs_credentials) in the APPS schema.

Step 3: Navigate to Shared Components => Security => Authorization, and create authorization as below,

Name: Check EBS Credentials

Scheme Type: PL/SQL Function Returning Boolean

PL/SQL Function Body:

BEGIN

      RETURN apps.apex_global.check_ebs_credentials;

   END;

Error message:  “Access not allowed: No valid E-Business Suite session.”

Evaluation point: once per page view

Step 4: Navigate to Shared Components => Security => Authentication and choose No Authentication scheme(This is because we are going to directly launch Oracle Apex Application from EBS. Hence here we are choosing No authentication. However, the Apex application will not allow the user to access the application when there is not a valid EBS session.) and select Authorization Scheme as Check EBS Credentials and click Apply Changes button,

Step 5: Then Log in to Oracle E-Business Suite with the SYSADMIN user.

Step 6: Navigate to the System Administrator responsibility > Profile > System menu option

Step 7: Search for Profile %APEX%, click Find and for profile FND: APEX URL enter Site

:8080/apex” >http://<EBS_Hostname>:8080/apex (replace <EBS_Hostname> with your domain name e.g. http://ebsnew.doyensys.com:8080/apex)

Step 8: Save the profile.

Step 9: Navigate to the System Administrator responsibility > Application > Function menu option.

Step 10: Create a function with the following details:

Description –

Function: APEX_FUN

User Function Name: APEX Extension

Properties –

Type: SSWA jsp function

Web HTML –

HTML Call: GWY.jsp?targetAppType=APEX& p=<APEX Application Id>:

<APEX Page>:<Session>:<Request>:<Debug>:<Clear Cache>:

<Parameter Pairs>

{ For example, to call Oracle Application Express application 104, Page 1

use GWY.jsp?targetAppType=APEX&p=104:1:0::NO:1: , all other parameters are

optional}

Step 11: Add a menu component under the required Menu as shown below-

Menu Name:  [Specify Menu Name here]

User Menu Name : [Specify User Menu Name here]

Menu Type: Standard

Create menu component –

Sequence: 1

Prompt: Launch APEX Page

Function: APEX Extension

Step 12: Save the menu. 

--Collected Source

Oracle User Create .dmp Export -Import

 New User Create: 

SQL> conn / as sysdba

Connected.

SQL> drop user NewUserName cascade ;

User dropped.

SQL> create user NewUserName identified by NewUserPassword ;

User created.

SQL> grant dba to NewUserName ;

Grant succeeded.

.dmp Export: 

$exp OldUserName/OldUserPassword owner=OldUserName

file=C:\locationPath\Name.dmp ;

Import: 

$imp NewUserName/NewUserPassword  file=D:\locationPath\Name.dmp fromuser=OldUserName 

touser=NewUserName ;

Interactive Report Column Width Change

 Interactive Report Column Width Change :

1. Set a static id for the report region. Example, Region Static RGNID 

2. Set a static id for the column you want to change width. Example, Column ID COLID

3. CSS by ID will be like this. Copy pest the code into Page Inline 

#RGNID td[headers=COLID]{min-width:300px}

Remove ORA from process execution error massage

just use this code on  process properties  Error Message

<h7 style="color: #d00;">#SQLERRM_TEXT# </h7>

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

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.

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

Call to Mobile Number In Oracle Apex Iitem

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');       

});

    

Search Option In Navigation Bar by Oracle Apex

 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);});