Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

Now we shall try automatic table creation and population directly from the above excel sheet in Oracle Apex environment.

Importing Data's from Excel and creation of table and storing steps are:

Log  into  Oracle   Apex  with  the  given workspace name, schema name and the password ( learner 1 learner 1 learner )

Click UTILITIES

On clicking Utilities, new page will get displayed with following Icons.

=>      DATA LOAD / UNLOAD

=>      GENERATE DDL

=>      OBJECT REPORTS

=>      RECYCLE BIN

=>      DATABASE MONITOR

=>      APEX VIEWS

=>      SCHEMA COMPARISON

=>      ABOUT DATABASE

From the above eight Icons select Data Load 1 Unload