Posts

Showing posts with the label oracle Apex

Oracle Express Edition XE-11gr2 Screen Shorts

Image
Home Page Information Storage Information

About Oracle APEX 4.1

Image
Oracle Apex 4.1 version is now available on otn.oracle.com for download. There are two types of version available for download, Oracle Application Express 4.1 for All Languages download size is 950MB and Oracle Application Express 4.1 for English Language Only download size is 300MB. Documentation and Tutorials are also on both PDF and HTML versions on otn.oracle.com.

Create List of Values (LOVs) in Oracle Apex 4.0

Image
This artical shows how to create List of Values (LOVs) in Oracle Apex 4.0. It is important that the account you log into in APEX has at least Developer level rights, or Workspace Admin rights . Check out the given below steps to create LOV in apex. Here is my 1st Tabular Form. In this form i want to create a LOV on Country colum so it can easly editable. To do that click 'Edit Page 1' option on the bottom bar. On the right hand side under 'Shared Components' you will see a entry i.e. 'List of Values'. Right click on 'List of Values' entry and Click on Create option. This will bring Create List of Values screen. So I want to create List of Values from Scratch, check this option and click on next button. Give it to a name, this will be the name that any part of the application will able to find it as. I am giving it Country as name and this will going to be a Dynamic List because when table will be updated, List updated accordingly. ...

Create Tabular Form in Oracle Apex 4.0

Image
This artical shows how to create a Tabular Form in Oracle Apex 4.0. It is important that the account you log into in APEX has at least Developer level rights, or Workspace Admin rights . Check out the given below steps to create taular form in apex. Login to Oracle Apex Workspace. Click on Application Builder. After Clicking Create icon select Application Type which is 'Database'. Select Form Scratch option. Enter application name, in this case i typed 'Tabular Form'. I used default Application unique ID which is 107. i am creating Tabular Form thorugh 'Form Scratch' and my Schema is Dev. Select Blank option in Page Selection Type and click on Add Page icon. After page added click on create icon. I need One Level of Tabs in my Form thats way i select it. Select No to copy shared components from another application. In the Authentication Schema select Application Express. Theme selection. Verify the selection and the...

Creating an APEX Application from spreadsheet in Apex 4.0

Image
I am new in Oracle Application Express and this is my 1 st application in apex 4.0. Oracle Application Express 4.0 has ability to create an application from the spreadsheet. The beautiful thing is, you don't have to write even a single line of code to do that. It is amazingly smooth and seamless. Check out the given below steps. Login to Oracle Apex Workspace. Click on Application Builder. Click on Create icon. Select Database option from Application Type and click on Next icon. Select From Spreadsheet option and click next. Select Copy and Paste option and click next. Copy the data from Spreadsheet and pasts in the window. Check on First row contains column names option and click next. Oracle Apex 4.0 analyze the pasted data and will come up with table structure. you can edit it, if required. Enter a Singular name and Plural name. Singular name and Plural name will be used in the application. Edit lables if required, these lables will become field labels in forms....