Full Track to be Oracle APEX Developer [ Arabic ]
4.8 (57 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
140 students enrolled

Full Track to be Oracle APEX Developer [ Arabic ]

الطريق الى أوراكل أبكس
Bestseller
4.8 (57 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
140 students enrolled
Created by Ali Saleh Ali
Last updated 5/2020
Arabic
Price: $199.99
30-Day Money-Back Guarantee
This course includes
  • 45.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Region كل انواع
  • Items كل انواع
  • Process كل انواع
  • Dynamic Actions كل انواع
  • Conditions كل انواع
  • validations كل انواع
  • Shared component
Course content
Expand all 364 lectures 45:16:30
+ overview
4 lectures 11:50

Create Worksapce From Administration

Preview 02:48

How to Asian different Schema to our worksapce

Asian Schema to Workspace
01:13

Create User for worksapce

Create User for our worksapce
02:00

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

Overview in Oracle apex environment
05:49
+ SQL Workshop
11 lectures 01:10:55

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

Browse Table
09:05

How to create a lookup table

Preview 05:38

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

Data Section
07:36

Index
Model

Constraints
grants
Statistics
Triggers
Dependencies
SQL
REST

Table Detials
08:20

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.

User Interface Default On Table
08:03

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

Create Table using Wizard
07:24

How to discover views and create a new One

Views
03:00

Index On table & Sequence

Index & sequence
03:17

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

Overview in Object browser
11:09
SQL Command
05:00
SQL Script
02:23
+ Page Designer
10 lectures 52:47
Create an Application
07:26
Add and Edit Page Content
04:46
Page Designer [Dynamic Action]
03:17
Page Designer [Processing and Page component]
04:49
Page Designer [Layout] - 1
07:23
Page Designer [Layout] - 2
02:50
Page Designer [component view/search/message/help]
05:10
Page Designer [Property Editor]
05:44
Page Designer [Toolbar]
03:47
+ Regions
62 lectures 09:30:35
Create Blank Page
04:54

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

Create region and Create page with a region
05:28

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

Static Content [Region]
05:46

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

[Static Region] sub region and start new raw Property
05:02

Understand Region Position Property For Region

[Static Region] Region position Property
03:45

Use column and Column spam Property with Static Region

[Static Region] column and Column spam Property
11:59

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

[Template] for page , region,item and button
08:07

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

Classic Report [Region]
12:13

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

Classic Report [ Column Property ] Part 1
12:36

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

Classic Report [ Column Property ] Part 2
06:43

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

Classic Report [Attributes]
20:14

how to Create Interactive Report
using sql query

how to Create [Interactive Report]
05:20

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

Default Search in [Interactive Report]
04:49

Interactive report Action Menu [ select column]
hide Column

Order Column

Interactive report Action Menu [ select column]
04:09

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

Interactive report Action Menu [filter ] by column
05:26

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

Interactive report Action Menu [filter ] by Raw
06:38

understand and how to use

  • Sort

  • Compute

  • Aggregate

  • flashback

Interactive report Action Menu [Data]
09:12

how to use


Control Break

Highlight

row per Page

Interactive report Action Menu [Format]
08:10

How to Create Chart view for your report

Interactive report Action Menu [Chart]
04:21

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

Interactive report Action Menu [Group By]
04:39

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

Interactive report Action Menu [Pivot]
04:30

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 Action Menu [Report,Download,Help And column Menu]
09:19

Interactive report column attribute
like
Single Row View
HTML Expression

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


Interactive report [column Attributes ]
14:48

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

Interactive report [ Attributes ]
17:42

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


Interactive report [download and Printing ]
05:48

work on Interactive Grid Properties as End User

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

Interactive Grid Properties as End User and different between Interactive Report
18:42

Interactive Grid column Property like
Type
Heading

Group
Stretch
Value Placeholder

Width
Column Filter
Enable Users To

Interactive Grid column Property
10:45

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


Interactive Grid region property
12:24

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 [Report]
07:45

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

Preview 10:11

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


Column Toggle Report
08:25

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

Reflow Report
03:42

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

List Region
11:27

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

Help Text [ Region ]
05:45

Create URL Region and Understand Settings

  1. URL

  2. Inclusion Mode

  3. IFrame Attributes

URL [Region]
03:43

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

Breadcrumb [Region]
07:54

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


Calendar Region
11:12

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

Chart [ Region ]
11:36

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

Tree [ Region ]
10:13

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


PL/SQL Dynamic [Region]
10:55

      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

Region Selector [Region] and legacy Regions
07:22

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

Create Report With Form [Page]
08:01

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

Link to Form
07:48

understand how is automatic form is working

understand Initialize form [Process]

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

Preview 10:15

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


Create Separate Form Page and link it to Report Page
17:49

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

Editable Interactive Grid [ for User ]
13:21

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

Editable Interactive Grid Attributes [ for Developer]
07:55

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

Interactive Grid - [ Automatic Row Processing (DML) ] Attributes
09:06

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


Editable Interactive Work With Grid Column as Items
10:40

How to Create List View Report With Form

List View with Form
07:37

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

form on Procedure
07:10

Understand Dashboard Concept
and create Dashboard Page

Create Dashboard Page
04:39

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

Wizard Page
20:11

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

Global Page [ Page 0 ]
08:16
  1. Show Legacy Pages

  2. Show Legacy Region

  3. Show Legacy Items

Legacy Pages ,Region and items
02:20

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.

Create [Data Load ] Wizard Pages
06:56

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

How to use [Data Load ] Wizard to load CSV Data
10:49

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

Understand Data Load Wizard Process and Regions
13:02

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

Stacked [ master-detail ]
13:33

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


master-detail [ Side by Side ]
11:01

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.

master-detail [ Drill Down ]
13:45
+ Items
30 lectures 03:55:05

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


Hidden Item
12:43

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]

[ Text Field ] Item Part 1
10:00

Working with Text Field Type
understand Layout Property like

  • Sequence

  • Region

  • Start New

  • Column

  • New Column

  • Column Span

Text Field Item Part 2 [Layout ]
13:06

Working with Text Field Type
understand Appearance Property like

  • template

  • Template Options

  • Icon

  • Format Mask

  • Width

  • Value Placeholder

Text Field Item Part 3 [Appearance]
14:45

Working with Text Field Type
understand Validation Property like

  • Value Required

  • Maximum Length

Text Field Item Part 4 [ Validation ]
08:11

Working with Text Field Type
understand Advanced Property like

  • CSS Classes

  • Custom Attributes

  • Pre Text

  • Post Text

  • Warn on Unsaved Changes

Text Field Item Part 5 [ Advanced ]
12:32

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.

Text Field Item Part 6 [ Default]
18:54

Working with Text Field Type
understand Property like

  • Quick Picks

  • Server-side Condition

  • Read Only

Text Field Item Part 7 [ Quick Picks -Server-side Condition-Read Only]
08:54

Working with Text Field Type
understand Property like

  • Inline Help Text

  • Help Text

  • Comments

Text Field Item Part 8 [ Inline Help Text -Help Text - Comments ]
04:01

Working with Number Field Type
understand Property

  • Minimum Value

  • Maximum Value

  • Number Alignment

Number Field Item
06:29

Working with Checkbox Field Type
understand Property

  • Number of Columns

  • List of Values and use  [ Static Values ] example

Checkbox Field Item
06:30

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.

[ Color Picker ] Field Item
05:18

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

[ Date Picker ] Field Item
14:24

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

[ Display Image ]item Field
07:38

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.

[ File Browse ] item Field
11:33

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

[ Display Only ] item Field
09:05

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

[ List Manager ] item Field
07:14

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.

[ Password ] item Field
02:17

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


Preview 04:32

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

[ Popup LOV ] item Field
05:28

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

[ Rich Text Editor ] item Field
06:03

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

[ Radio Group ] item Field
04:51

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

[ Select List ] item Field and Cascading LOV
10:07

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

[ Select List ] item Field Part 2
02:05

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

[ Shuttle ] item Field
03:23

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

[ Switch ] item Field
04:53

Textarea

Displays a multiple-row text area.

Settings

  • Re-sizable

  • Auto-Height

  • Character Counter

  • Trim Spaces

[ Textarea ] item Field
03:13

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

[ Text Field with autocomplete ] item Field
07:02

Legacy and unsupported Items

Legacy and unsupported Items
01:38

working with items in interactive grid

Items in Interactive Grid
08:16
+ Buttons
2 lectures 16:14
  • Button Template

  • Hot

  • Template Options

  • Use Template

  • CSS Classes

  • Icon

Button Appearance
08:58


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.

Button Behavior
07:16
+ Pages
4 lectures 29:00

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


Page Property Part 1 [Identification & Appearance ]
10:15

Understand Page Property

Like

Navigation Menu

User Interface Level

  • List

  • List Position

  • List Template

  • Template Options

Navigation

  • Cursor Focus

  • Warn on Unsaved Change


Page Property Part 2 [Navigation Menu & Navigation]
09:32

understand Page Property

JavaScript

  • File URLs

  • Function and Global Variable Declaration

  • Execute when Page Loads

Page Property Part 3 [ JavaScript ]
05:49

understand Page Property

CSS

  • File URLs

  • Inline


Page Property Part 4 [ CSS ]
03:24
+ Page Processing
2 lectures 31:28

Understand Page Processing types

  • Process,

  • Dynamic Action

  • computation

  • Validation

  • server side Condition

  • client side Condition

Overview on Page Processing
20:03

Different between  client side Condition and Server Side Condition

Different between client side Condition and Server Side Condition
11:25
+ Dynamic Action
38 lectures 03:06:29

what is event
what is action

Dynamic Action Introduction
05:24

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

[Browser Events] change on item
04:43

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

[Browser Events] false action
05:48

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

[Browser Events] opposite action & fire on initialization
04:19

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

[Browser Events] click & double click on button
04:17

event : get focus
action: set value

[Browser Events] get focus
01:34

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

[Browser Events] Key-down, Key-press , Key-Release
03:25

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

Preview 03:16

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

[Browser Events] page Load / page unload
04:00

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

[Browser Events] resize /resource load / select
04:21

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

[ Framework Events ] Before Refresh , After Refresh
05:13

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

[ Framework Events ] Before Page Submit , Page load
03:55

event: Dialog Close
Action : Refresh Region

[ Framework Events ] Dialog Close
03:53

calendar event
date changed
event changed
view changed
action : alert

[Component Events] ( calendar event )
06:27

event: selected change
action :expand Tree ,collapse tree

[Component Events] (Tree )
05:49

event :Interactive Grid Mode change
Action:alert

[Component Events] Interactive [Grid Mode change]
02:13

event :Interactive Grid Page change
Action:alert

[Component Events] [Interactive Grid Page change]
02:09

event :Interactive Grid Report change
Action:alert

[Component Events] Interactive Grid [Report change]
01:21

event :Interactive Grid Raw Initialization
Action:alert

[Component Events] [Interactive Grid Raw Initialization ]
00:56

event :Interactive Grid save
Action:alert

[Component Events] [Interactive Grid save]
01:04

event :Interactive Grid View change
Action:alert

[Component Events] [Interactive Grid View change]
02:10

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") : ""
---

[Component Events] [Interactive Grid ٍselection change]
05:23

event :Custom event
Action : Alert

Preview 02:46

Action : Open Region
              Close Region

[Actions] Open Region / Close Region
02:17

Action : Clear
               disable,enable

               show,hide

               Refresh

               Set Focus

[Actions] Clear,disable,enable,show,hide,Refresh,Set Focus
07:39

Action : set value
Set Type: Static Assignment

JavaScript Expression,

SQL Statement,

PL/SQL Expression,

PL/SQL Function Body

[Actions] set value
10:59

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

[Actions] set value with Set Type: Dialog Return Item
06:12

event : Button Click
Action : Execute JavaScript Code

[Actions] Execute JavaScript Code
06:20

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

[Actions] Execute Pl/SQL Code, Submit
09:46

event : Button Click
Action :Cancel Event

[Actions] [Cancel Event]
02:29

event : Button Click
Action : Close Dialog , Cancel Dialog

[Actions] [ Close Dialog ,Cancel Dialog ]
04:28

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

[Actions] [Add Class]
11:20

event : Button Click
Action :remove class , set style

[Actions] [remove class , set style]
03:55

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

[Advanced] [Selection Type]
12:46

Delete a Row From Classic Report with a Dynamic Action

[Advanced] [Delete a Row From Classic Report with a Dynamic Action]
05:57

event : click on button
action :Redirect [Plugin]

Preview 06:24

How to install and use Sample Dynamic Actions Sample Application

[Advanced] [Sample Dynamic Actions Application]
04:32

Dynamic Action on interactive grid column

Preview 06:59
Requirements
  • pl/sql
  • oracle apex beginner
Description

الطريق من البدايه ان شاء الله
حتى تصبح
اوراكل ابكس ديفلوبر
الكورس على احدث اصدار 19.1
وان شاء الله مع اى اصدار جديد هنضيف فيديوهات بالحاجات اللى اتضافت
الكورس مستمر معانا ان شاء الله
بمعنى هنفضل نضيف عليه باستمرار
فيديوهات متقدمه
فيديوهات مشاريع
-------------
الكورس لم يعتمد على مصدر واحد فقط
وان شاء الله هتلاقو المصادر موجوده فى فيديو المقدمه
------------
بالتوفيق للجميع

Who this course is for:
  • oracle apex Developer مبتدئ ومتوسط ومحترف