Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Oracle APEXデモンストレーション手順

Oracle APEXデモンストレーション手順

12/17のOracle Developer Days向けにデモ手順をPPTに記載した。
全部行うと30分程度の時間を要すると思う。

Free Tier上のAPEX 20.2で手順を確認している。

oracle4engineer
PRO

December 02, 2020
Tweet

More Decks by oracle4engineer

Other Decks in Programming

Transcript

  1. Oracle APEXデモンストレーション手順
    Oracle APEX 20.2
    Name
    Presenter’s Title
    Organization, Division or Business Unit
    Month 00, 2020

    View Slide

  2. アプリケーションの元となるCSVファイル
    Copyright © 2020, Oracle and/or its affiliates
    2

    View Slide

  3. アプリケーション・ビルダーから新規アプリケーションを作成
    Copyright © 2020, Oracle and/or its affiliates
    3
    2
    3
    1

    View Slide

  4. CSVファイルの指定
    Copyright © 2020, Oracle and/or its affiliates
    4
    1

    View Slide

  5. データのロードに関する設定
    Copyright © 2020, Oracle and/or its affiliates
    5
    1
    2
    3
    4
    5
    6

    View Slide

  6. 構成の表示
    Copyright © 2020, Oracle and/or its affiliates
    6
    2
    3
    4
    1

    View Slide

  7. データのロードを実行
    Copyright © 2020, Oracle and/or its affiliates
    7
    1
    2
    3

    View Slide

  8. アプリケーションの作成
    Copyright © 2020, Oracle and/or its affiliates
    8
    1
    2
    3
    4
    5

    View Slide

  9. 作成されたアプリケーションとアプリケーションの実行
    Copyright © 2020, Oracle and/or its affiliates
    9
    1
    2

    View Slide

  10. アプリケーションの実行
    Copyright © 2020, Oracle and/or its affiliates
    10
    1
    3
    4
    2

    View Slide

  11. Oracle APEXのユーザー認証スキーム
    Copyright © 2020, Oracle and/or its affiliates
    11
    1
    2
    3
    4
    5 6
    7

    View Slide

  12. ダッシュボードを開く
    Copyright © 2020, Oracle and/or its affiliates
    12
    1

    View Slide

  13. ダッシュボード
    Copyright © 2020, Oracle and/or its affiliates
    13
    https://apex.oracle.com/charts
    https://apex.oracle.com/pls/apex/f?p=18290:1
    1 2
    3 4
    5
    6
    7
    8

    View Slide

  14. Costチャートの改良
    Copyright © 2020, Oracle and/or its affiliates
    14
    select COST, count(*) value
    from TASKS
    group by COST
    order by 2 desc
    select PROJECT, sum(cost) value
    from TASKS
    group by PROJECT
    order by 2 desc
    1
    2
    3
    4

    View Slide

  15. 変更の確認
    Copyright © 2020, Oracle and/or its affiliates
    15
    1
    2
    3

    View Slide

  16. Tasks検索ページを開く
    Copyright © 2020, Oracle and/or its affiliates
    16
    1

    View Slide

  17. Tasks検索ページ
    Copyright © 2020, Oracle and/or its affiliates
    17
    1
    2
    3
    4
    4
    5 6
    7

    View Slide

  18. Budget >= 2000をリスト
    Copyright © 2020, Oracle and/or its affiliates
    18
    1
    2

    View Slide

  19. ファセットのカスタマイズ
    Copyright © 2020, Oracle and/or its affiliates
    19
    >=1,000
    1,000 – 2,000
    >= 2,000
    1
    2
    3
    4

    View Slide

  20. 範囲の更新
    Copyright © 2020, Oracle and/or its affiliates
    20
    1#G#000 - 2#G#000
    >=2#G#000 2000|
    1000|2000
    表示値 戻り値
    1
    2
    3
    4
    5

    View Slide

  21. 更新されたファセットの確認
    Copyright © 2020, Oracle and/or its affiliates
    21
    2
    1
    3

    View Slide

  22. Tasksレポートのページを開く
    Copyright © 2020, Oracle and/or its affiliates
    22
    1

    View Slide

  23. バジェットの更新
    Copyright © 2020, Oracle and/or its affiliates
    23
    1
    2
    3
    4

    View Slide

  24. 対話モード・レポートによるソート
    Copyright © 2020, Oracle and/or its affiliates
    24
    1
    2
    3
    5
    4
    6

    View Slide

  25. ハイライトの設定
    Copyright © 2020, Oracle and/or its affiliates
    25
    1
    2
    3
    4
    5
    6
    7

    View Slide

  26. プロジェクトごとの表示
    Copyright © 2020, Oracle and/or its affiliates
    26
    1
    2
    3
    4
    5

    View Slide

  27. プロジェクトごとのコストとバジェットの合計
    Copyright © 2020, Oracle and/or its affiliates
    27
    1
    2 3
    4
    5
    6 7
    8
    9

    View Slide

  28. Excel形式でのレポートのダウンロード
    Copyright © 2020, Oracle and/or its affiliates
    28
    1
    2
    3
    4
    5
    6
    1

    View Slide

  29. レポートの保存と呼び出し
    Copyright © 2020, Oracle and/or its affiliates
    29
    1
    2
    3
    4
    5
    6 7 8
    9

    View Slide

  30. ステータスを選択リストへ変更
    Copyright © 2020, Oracle and/or its affiliates
    30
    Open
    Closed
    Pending
    On-Hold
    1
    3
    4
    2

    View Slide

  31. 選択リストの設定
    Copyright © 2020, Oracle and/or its affiliates
    31
    1
    2
    3

    View Slide

  32. 共有コンポーネントのLOV作成
    Copyright © 2020, Oracle and/or its affiliates
    32
    select status d, status r
    from tasks
    group by status
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11

    View Slide

  33. STATUS_LOVの作成を確認してページ・デザイナに戻る
    Copyright © 2020, Oracle and/or its affiliates
    33
    1
    2

    View Slide

  34. 選択リストの設定と確認
    Copyright © 2020, Oracle and/or its affiliates
    34
    1
    2
    3
    4
    5
    6

    View Slide

  35. カレンダのページを開く
    Copyright © 2020, Oracle and/or its affiliates
    35
    1
    2
    3

    View Slide

  36. フォームを開くように拡張
    Copyright © 2020, Oracle and/or its affiliates
    36
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10

    View Slide

  37. フォームの確認
    Copyright © 2020, Oracle and/or its affiliates
    37
    1
    2

    View Slide

  38. 対話グリッドの作成
    Copyright © 2020, Oracle and/or its affiliates
    38
    1
    2 3
    4
    5
    6
    7
    8
    9
    10

    View Slide

  39. 対話グリッドの操作
    Copyright © 2020, Oracle and/or its affiliates
    39
    1
    2
    3

    View Slide

  40. 選択リストの設定と確認
    Copyright © 2020, Oracle and/or its affiliates
    40
    1
    2
    3
    4
    5

    View Slide

  41. 管理機能の確認
    Copyright © 2020, Oracle and/or its affiliates
    41
    2
    1

    View Slide

  42. フィードバックの確認
    Copyright © 2020, Oracle and/or its affiliates
    42
    要ブラウザのリロード
    1
    2
    3
    4
    4
    5
    6
    7
    8
    9
    10

    View Slide

  43. テーマ・スタイルの選択
    Copyright © 2020, Oracle and/or its affiliates
    43
    1
    2
    3
    4

    View Slide

  44. アクティビティ・レポート
    Copyright © 2020, Oracle and/or its affiliates
    44
    1
    2
    3
    4
    5

    View Slide

  45. 組み込みのアクセス制御
    Copyright © 2020, Oracle and/or its affiliates
    45
    1
    2
    3
    4
    5
    6
    7
    8
    9

    View Slide

  46. 既存表からのアプリケーション作成
    Copyright © 2020, Oracle and/or its affiliates
    46
    1
    2
    3
    4
    5 7
    6

    View Slide

  47. アプリケーションの実行
    Copyright © 2020, Oracle and/or its affiliates
    47
    1

    View Slide

  48. クイックSQLによるアプリケーション作成
    Copyright © 2020, Oracle and/or its affiliates
    48
    qs_tasks /insert 73
    project
    task_name
    assigned_to
    start_date
    end_date
    status
    cost number
    budget number
    1
    2
    3
    4 5
    6
    7
    8

    View Slide

  49. アプリケーションの作成
    Copyright © 2020, Oracle and/or its affiliates
    49
    1
    2
    3
    4
    6
    5

    View Slide

  50. iPhoneでの見栄えを確認
    Copyright © 2020, Oracle and/or its affiliates
    50
    1
    2
    3
    4
    5

    View Slide

  51. View Slide