Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

Create Application from Excel Sheet

Posted by Hendry chinnapparaj on July 1, 2010

Create Application from Excel Sheet

——————————————-

Pre-requisite

Save the .XLS file as .CSV file or Tab Limited text in my case.

 

Login as Developer user “Hendry”

Go to Home à Application Builder à Create Application à Database à next à from spreadsheet à next à

Copy and paste à  tab delimited à next à

Rename columns if required

Schema à oracledba

Table name à ORACLE_ENVIRONMENT_TAB

SINGULAR NAME: Oracle Environment Tab

PLURAL  NAME: Oracle Environment Tab

Applcation name : ORACLE ENVIRONMENT

Create mode : readn and write

Report Implementation à interactive

Select Theme à Theme 1

Create

The application has been successfully created.

Run Application or Edit Application

End user Login

http://cpuu026.greatwest.com:8080/apex/f?p=108:1

Developer

http://cpuu026.greatwest.com:8080/apex/apex

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: