Full Track to be Oracle APEX Developer [ English subtitles]

Create Worksapce From Administration

How to Asian different Schema to our worksapce

Create User for worksapce

Overview in Oracle apex environment
like
App builder
sql workshop
Team development
App Calgary

Add Column
Modify Column
Rename Column
Drop Column
Rename Table
Drop Table
Copy Table
Truncate Table

How to create a lookup table

Browse Data
Modify existing record [update & delete]
Create Query
count Raw
insert data

Index
Model
Constraints
grants
Statistics
Triggers
Dependencies
SQL
REST

User Interface Defaults are used by the App Builder to populate initial values for region and item properties providing consistency across multiple pages in an application or multiple applications.

How to Create Table is SQL workshop Using Wizard and add constraints

How to discover views and create a new One

Index On table & Sequence

Overview for the other object
Type,Trigger,package ,procedure ,function ,database link,materialized View ,Synonym

Different between when  Create region on blank Page and Create page with a region Dynamic

Create Static Content  Region and use property Title ,Source  and sequence

use property Sub Region and Start New raw
with Region Static Content

Understand Region Position Property For Region

Use column and Column spam Property with Static Region

get focus on template concept like [Template] for page , region,item and button

Create Classic region and focus on source property
from table/view
or sql query

Focus on column property  like Heading ,sequence , alignment and Format Mask

Classic Report [ Column Property ] Part 2
Highlight Words
Sorting
Export / Printing
Comments

Some of Classic Report Attributes
Number of Rows Type

Number of Rows
Template Type

Theme

Template Options
Show Null Values as
Pagination
Break Formatting

Report Sum Label

Break Columns

how to Create Interactive Report
using sql query

Default Search in Interactive Report
search in all columns and in a specific column

Interactive report Action Menu [ select column]
hide Column

Order Column

Interactive report Action Menu [filter ] by column
how to filter data on report by using only one column

Interactive report Action Menu [filter ] by Raw Expression using more than  one column

understand and how to use

• Sort

• Compute

• Aggregate

• flashback

how to use

Control Break

Highlight

row per Page

How to Create Chart view for your report

How to Create New view for your report using Group by concept

How to Create New view for your report using PIVOT  [Cross Table] concept

How to Save Public Report

How to Save Private Report
How to download report in some format like pdf,html,csv
How to use interactive report help Document

Interactive report column attribute
like
Single Row View
HTML Expression

Enable Users To (sort ,hide,...)
Group

Interactive report Attributes

Like
Link
Single Row View
Pagination
Control of Search Bar
Control of Actions Menu
Region Alias
Report ID Item
Description
and more ....

how to download CSV and PDF
and customize your PDF output 
by change header and heading and data and footer

work on Interactive Grid Properties as End User

check different between Interactive Grid and Interactive Report
check new chart in Interactive Grid

Interactive Grid column Property like
Type
Heading

Group
Stretch
Value Placeholder

Width
Column Filter
Enable Users To

Edit
Enabled

Performance

Lazy Loading

Appearance

Show Null Values as

Select First Row

Pagination

Type [ Page Scroll]

Show Total Row Count

Messages

When No Data Found

Toolbar

Controls

Search Column Selection

Search Field

Actions Menu

Reset Button

Save Button

Enable Users To

Download

Heading

Icon View

Detail View

Advanced

Oracle Text Index Column

JavaScript Initialization Code

Help

Help Text

How to Create List View Report and use standard property like

1. Text Column

2. Supplemental Information Column

3. Counter Column

4. Link Target

List View Advanced Property

1. Advanced Formatting

2. Show Image

3. Show List Divider

4. Has Split Button

5. Enable Search

6. Is Nested List View

7. Inset List
   

How to Create Column Toggle Report Region and what the best case to use
and column property like Show and Priority
and Region Property like
Layout Options Stripes/Stroke
Heading Type

How to Create Reflow Report Region and what the best case to use
and column property and Region Property

Create List Region
create list from Shared Component
assign you list to Region
Change list template
change template property

Create Help Text Region
understand help text and inline help text for Item

Create URL Region and Understand Settings

1. URL

2. Inclusion Mode

3. IFrame Attributes

How to Create Breadcrumb Region
understand Breadcrumb Bar Position
Create Breadcrumb entries are associated to pages and identify a parent page.

Display date based entries on a calendar views.
understand Settings like
Display Column

Start Date 

End Date Column

Primary Key Column

Show Time

Supplemental Information
Multiple Line Events

Show Tooltip

Calendar Views and Navigation

Drag and Drop

Create Link

View / Edit Link

CSS Class

Export

Google Calendar ID

JavaScript Initialization Code

Create Chart Region and chose a lot of  Chart Type and add Series to Chart

check different between  Create Tree Page and Create Tree Region
and check some setting like

• Node Label Column

• Node Value Column

• Node ID 

• Parent Key 

• Start Tree With

• Order Siblings By

• Tooltip

• Activate Node Link with

How to Create PL/SQL Dynamic Region
use htp.p procedure to print

      Create Region Selector [Region] and understand Settings

1. ModeView Single Region
                         Scroll Window

2. Include 'Show All'

3. Remember Last Selection

   
   

   and understated legacy Regions

How to Create Report with form
and understand create mode and edit mode

How to link to form from Button
How to link to form from Report

understand how is automatic form is working

understand Initialize form [Process]

understand Form - Automatic Row Processing (DML) [Process]
understand server side condition on button 

Create Form Region
Create Classic  Report Region and create virtual column as link to form
Create button and link it to form Page
change some items type from number to select list in form

change some Column type from number to Plain Text (based on List of Values) in report

understand Editable Interactive Grid as End User

how to use Add raw /save/Edit buttons

understand raw Action

1. Single Row View

2. Duplicate Row

3. Delete Row

4. Refresh Row

5. Revert Changes

work on interactive grid attributes related to Edit

Edit

Enabled

Allowed Operations

1. Add Row

2. Update Row

3. Delete Row

Allowed Row Operations Column

Lost Update Type

Add Row If Empty

Authorization

Add

Update

Delete

Process Settings

1. Target Type [Region SourceTable / ViewPL/SQL Code]

2. Prevent Lost Updates

3. Lock Row

4. Return Primary Key(s) after Insert

Execution Options

1. Sequence

2. Point

Success Message

Error Message

work with interactive Grid Column as Items
change column Type and use select list /radio group / Popup LOV

Create Lists of Values in Shared Components and Assign it to Item in Grid

How to Create List View Report With Form

How to Create Form on Procedure
understand branches and redirect to Page

Understand Dashboard Concept
and create Dashboard Page

Understand Wizard Page { place Order }  on Packaged App  [ Sample Database Application ]
Create Wizard Page
Create Example to add Department and Employee

Create Global Page [ Page 0 ]
Add Region in Global Page to Appear in all Page
and make Condition to Restrict appear in a specific Page using server side Condition
Add Dynamic Action to Show Alert in Page Load in Page 0 to Fire in every Page

1. Show Legacy Pages

2. Show Legacy Region

3. Show Legacy Items

use the Data Loading page wizard to create four pages in your application that enable the end-user to load data into the Emp table.

How User will Use Data Loading Wizard to Load Data Into Emp Table

Focus on Every Page on Data Load Wizard
and understand Each Used Process And Regions Per Page

Stacked -
A single page master-detail utilizing editable Interactive Grids.

Side by Side -
A single page master-detail utilizing side by side layout and report regions with modal edit windows.

Drill Down -
Consists of a report page that drills down to a page where the selected master is standard form items, and the detail tables use editable Interactive Grids.

Create Form and Report on DEMO_CUSTOMERS
understand DEMO_CUSTOMERS Structure
understand  DEMO_CUSTOMERS_BIU trigger and how primary key value populated

understand Item Type Hidden and some property  like

1. Value Protected

2. Form Region

3. Column

4. Data Type

5. Query Only

6. Primary Key
   

Working with Text Field Type
understand Property like

1. Name

2. Label

3. Subtype

4. Trim

5. Submit when Enter pressed

6. Disabled

7. Send On Page Submit

8. Default [static Value]

Working with Text Field Type
understand Layout Property like

• Sequence

• Region

• Start New

• Column

• New Column

• Column Span

Working with Text Field Type
understand Appearance Property like

• template

• Template Options

• Icon

• Format Mask

• Width

• Value Placeholder

Working with Text Field Type
understand Validation Property like

• Value Required

• Maximum Length

Working with Text Field Type
understand Advanced Property like

• CSS Classes

• Custom Attributes

• Pre Text

• Post Text

• Warn on Unsaved Changes

Select a default value type for this item.

Available options include:

Static
Set to the value entered in Static value.

Item
Set to the value returned from the session state for the Item selected.
SQL Query
Set to the value returned from the SQL Query entered.
SQL Query returning Colon Delimited List

Set to the colon delimited list of values returned from the SQL Query entered.

Note - colon delimited lists are required when the column is displayed as a checkbox, radio group, or shuttle.

PL/SQL Expression
Set to the value returned from the PL/SQL Expression entered.
PL/SQL Function Body
Set to the value returned from the PL/SQL Function Body entered.
Sequence
Set to the value returned from the Sequence entered.

Working with Text Field Type
understand Property like

• Quick Picks

• Server-side Condition

• Read Only

Working with Text Field Type
understand Property like

• Inline Help Text

• Help Text

• Comments

Working with Number Field Type
understand Property

• Minimum Value

• Maximum Value

• Number Alignment

Working with Checkbox Field Type
understand Property

• Number of Columns

• List of Values and use  [ Static Values ] example

Color Picker

• Displays a text field with a color picker icon. End users can either enter a HTML color code directly, or click the icon to display a color palette popup.

• The end user can click a color from the palette which returns the corresponding HTML color code for the selected color.

Working with Date Picker Field Type
understand Property

• Highlighted Date

• Minimum Date

• Maximum Date

• Show On

• how other Months

• Navigation List for

• Year Range

• Format Mask
  
  

understand Based On Property

and Check Available options include:

• Image URL stored in Page Item Value

• BLOB Column specified in Item Source

• BLOB Column returned by SQL statement

understand File browse with  Storage Type
BLOB column specified in Item Source attribute

Stores the uploaded file in the table used by the
Automatic Row Processing (DML)
process and the column specified in the item source attribute.
The column has to be of data type BLOB.
If the file gets downloaded, the table name of the Automatic Row Fetch process is used.

Displays a non-enterable text item.
Understand Settings like

Send On Page Submit

Based On

• Page Item Value

• Display Value of List of Values

• Output of PL/SQL Code

Show Line Breaks

List of Values

List Manager

Displays a text item with a popup list of values icon, Add and Remove buttons, and a list of selected values.

You can type in the value or pick from the list of available items.
You can then utilize the buttons to manage the values selected.
The selected values are stored in a single colon-delimited string.

Settings

Fetch

Preserve Case

List of Values

Type Shared Component static LOV and Dynamic LOV

Password

Displays an HTML password form element.

As the end user enters text a black dot is displayed for that character, instead of the actual character entered.

Percent Graph

Displays the value as a percentage graph.
The value retrieved must be between 0 and 100.

Settings

1. Show Value

2. Background Color

3. Foreground Color

4. Text Color

5. Bar Width

Popup LOV

Displays a text item with a popup list of values icon.
When the end user clicks the icon, a popup window appears with a search field, and a list of supported values.

Popup LOV is best suited for large lists since end users can enter search criteria to reduce the available values displayed.
For relatively small lists Select List is often better suited.
Settings

Input Field

Fetch

List of Values

SQL Query

Rich Text Editor

Displays a text area with comprehensive text formatting options.

End users can enhance the content displayed in a similar fashion to using a word processor, such as Microsoft Word.

End users can also cut and paste documents, that are in rich text format (RTF) file format, into this item.

Settings

1. Toolbar

2. Toolbar Expanded

3. Skin

4. Toolbar Position
   Appearance

1. Height

Radio Group

Displays multiple values as radio group options, enabling the end user to select a single value.
Settings

• Number of Columns

• Page Action on Selection
  

Select List

Displays an item with a built-in list of values selector.
When the end user clicks the item, the list of supported values displays directly inline with the current item.

Select List is best suited for relatively small, discrete lists.
End-Users can very quickly select a value from the list without needing to change focus to a popup dialog.
For large lists Popup LOV is often better suited.
Settings

• Action on Selection

• Cascading LOV Parent Item(s)

• Items to Submit

• Optimize Refresh
  

Settings

• Allow Multi Selection

  
  

  understand
  Redirect to Page

  The browser is redirected to the page contained in the selected value.
  The return values in the list must include valid page numbers or page aliases.

  Redirect to URL

  The browser is redirected to the URL contained in the selected value.
  The return values in the list must include val

Shuttle

• Displays as a multiple select list that includes two boxes containing lists.

• The left list displays the source list of values that have not been selected and the right list shows the currently selected values.

• End users can select one or more values in a list then use the shuttle controls to move the selected values or all values.

• The current values are stored in a single colon-delimited string.

  
  

  Settings

• Show Controls

Switch

Displays as a flip toggle switch.

Settings

      Settings on Custom

• On Value

• On Label

• Off Value

• Off Label

  
  

  Settings on Component Settings

• update switch component Settings

Textarea

Displays a multiple-row text area.

Settings

• Re-sizable

• Auto-Height

• Character Counter

• Trim Spaces

Text Field with autocomplete

Displays a text field that displays a list of possible values, based on the text already entered by the end user, inline with the text item. The list is further refined as the end user types in more text.

Settings

Search

• Contains & Case Sensitive

• Exact & Case Sensitive

• Contains & Ignore Case

• Exact & Ignore Case

Lazy Loading

Maximum Values in List

Minimum Search

Legacy and unsupported Items

working with items in interactive grid

• Button Template

• Hot

• Template Options

• Use Template

• CSS Classes

• Icon

Available options include:

Submit Page

Submit the current page with a REQUEST value equal to the Button Name.

Redirect to Page in this Application

Redirect to a page in the current application, with optional additional attributes for resetting pagination, setting the request value, clearing cache and setting item values, on the target page.

Redirect to Page in a different Application

Redirect to a page in a different application, with optional additional attributes for resetting pagination, setting the request value, clearing cache and setting item values, on the target page.

Note: Redirecting to a page in different application relies on deep linking being enabled in the target application. To enable deep linking, go to the application's Security attributes and enable Deep Linking.

Redirect to URL

Redirect to the target URL you specify.

Defined by Dynamic Action
Does not submit the page or redirect to another page. Instead the button's behavior is defined by a Dynamic Action.

Understand Page Property

Like

Identification

• Name

• Page Alias

• Title

• Page Group

Appearance

• User Interface

• Page Mode

• Page Template

• Theme

• Template Options

• CSS Classes

• Media Type

Understand Page Property

Like

Navigation Menu

User Interface Level

• List

• List Position

• List Template

• Template Options

Navigation

• Cursor Focus

• Warn on Unsaved Change

  
  

understand Page Property

JavaScript

• File URLs

• Function and Global Variable Declaration

• Execute when Page Loads

understand Page Property

CSS

• File URLs

• Inline

  
  

Understand Page Processing types

• Process,

• Dynamic Action

• computation

• Validation

• server side Condition

• client side Condition

Different between  client side Condition and Server Side Condition

what is event
what is action

how to create Dynamic action
event : change on item
action : alert, confirm ,execute java script

1- how to use false action
2- event /change item
3- action disable item,enable item
4- client side condition

event change item
action show/hide opposite action
fire on initialization

event :click & double click on button
action :clear item, set focus , set value [static]

event : get focus
action: set value

event
Key-down, Key-press , Key-Release
action : alert

event:
mouse button press
mouse button Release
mouse enter
mouse leave
mouse move
action : alert

event :page Load
page unload
action :
disable button
alert
java script position in page

Oracle Apex 19.1 : Dynamic Action
event : resize resource load select
action : alert
selection type : JavaScript expression

event :Before Refresh , After Refresh , change Item
Action : Refresh Region, Alert

Event: Before Page Submit , Page load , change Item
action : enable Item ,Disable Item

event: Dialog Close
Action : Refresh Region

calendar event
date changed
event changed
view changed
action : alert

event: selected change
action :expand Tree ,collapse tree

event :Interactive Grid Mode change
Action:alert

event :Interactive Grid Page change
Action:alert

event :Interactive Grid Report change
Action:alert

event :Interactive Grid Raw Initialization
Action:alert

event :Interactive Grid save
Action:alert

event :Interactive Grid View change
Action:alert

event :Interactive Grid selection change
Action:alert ,
execute JavaScript code to get column value to item,
set value with JavaScript expression to get column value to item
---code for execute JavaScript
if (apex.region("EMP_REGION"))
{
var grid = apex.region("EMP_REGION").widget().interactiveGrid("getViews", "grid"); var model = grid.model; var record = grid.getSelectedRecords()[0];
if (record) { $s("P6_EMPNO", model.getValue(record, "ENAME"));
}
}
----- ---
code for set Value using JavaScript expression
(this.data && this.data.selectedRecords && this.data.selectedRecords.length == 1) ? this.data.model.getValue( this.data.selectedRecords[0], "COMM") : ""
---

event :Custom event
Action : Alert

Action : Open Region
              Close Region

Action : Clear
               disable,enable

               show,hide

               Refresh

               Set Focus

Action : set value
Set Type: Static Assignment

JavaScript Expression,

SQL Statement,

PL/SQL Expression,

PL/SQL Function Body

Event: Dialog Closed
Action : set value
Set Type: Dialog Return Item

event : Button Click
Action : Execute JavaScript Code

event : Button Click
Action : Execute Pl/SQL Code Submit

event : Button Click
Action :Cancel Event

event : Button Click
Action : Close Dialog , Cancel Dialog

event : Button Click
Action : Add Class (apex class & custom class)

event : Button Click
Action :remove class , set style

Selection Type
Item(s)
Button
Region
Column(s)
jQuery Selector
JavaScript Expression

Delete a Row From Classic Report with a Dynamic Action

event : click on button
action :Redirect [Plugin]

How to install and use Sample Dynamic Actions Sample Application

Dynamic Action on interactive grid column