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

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

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

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