Search This Blog

Sunday, October 8, 2017

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






Tuesday, October 3, 2017

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;

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