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
2. アプリケーションの元となるCSVファイル Copyright © 2020, Oracle and/or its affiliates 2
3. アプリケーション・ビルダーから新規アプリケーションを作成 Copyright © 2020, Oracle and/or its affiliates 3 2 3 1
4. CSVファイルの指定 Copyright © 2020, Oracle and/or its affiliates 4 1
5. データのロードに関する設定 Copyright © 2020, Oracle and/or its affiliates 5 1 2 3 4 5 6
6. 構成の表示 Copyright © 2020, Oracle and/or its affiliates 6 2 3 4 1
7. データのロードを実行 Copyright © 2020, Oracle and/or its affiliates 7 1 2 3
8. アプリケーションの作成 Copyright © 2020, Oracle and/or its affiliates 8 1 2 3 4 5
9. 作成されたアプリケーションとアプリケーションの実行 Copyright © 2020, Oracle and/or its affiliates 9 1 2
10. アプリケーションの実行 Copyright © 2020, Oracle and/or its affiliates 10 1 3 4 2
11. Oracle APEXのユーザー認証スキーム Copyright © 2020, Oracle and/or its affiliates 11 1 2 3 4 5 6 7
12. ダッシュボードを開く Copyright © 2020, Oracle and/or its affiliates 12 1
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
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
15. 変更の確認 Copyright © 2020, Oracle and/or its affiliates 15 1 2 3
16. Tasks検索ページを開く Copyright © 2020, Oracle and/or its affiliates 16 1
17. Tasks検索ページ Copyright © 2020, Oracle and/or its affiliates 17 1 2 3 4 4 5 6 7
18. Budget >= 2000をリスト Copyright © 2020, Oracle and/or its affiliates 18 1 2
19. ファセットのカスタマイズ Copyright © 2020, Oracle and/or its affiliates 19 >=1,000 1,000 – 2,000 >= 2,000 1 2 3 4
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
21. 更新されたファセットの確認 Copyright © 2020, Oracle and/or its affiliates 21 2 1 3
22. Tasksレポートのページを開く Copyright © 2020, Oracle and/or its affiliates 22 1
23. バジェットの更新 Copyright © 2020, Oracle and/or its affiliates 23 1 2 3 4
24. 対話モード・レポートによるソート Copyright © 2020, Oracle and/or its affiliates 24 1 2 3 5 4 6
25. ハイライトの設定 Copyright © 2020, Oracle and/or its affiliates 25 1 2 3 4 5 6 7
26. プロジェクトごとの表示 Copyright © 2020, Oracle and/or its affiliates 26 1 2 3 4 5
27. プロジェクトごとのコストとバジェットの合計 Copyright © 2020, Oracle and/or its affiliates 27 1 2 3 4 5 6 7 8 9
28. Excel形式でのレポートのダウンロード Copyright © 2020, Oracle and/or its affiliates 28 1 2 3 4 5 6 1
29. レポートの保存と呼び出し Copyright © 2020, Oracle and/or its affiliates 29 1 2 3 4 5 6 7 8 9
30. ステータスを選択リストへ変更 Copyright © 2020, Oracle and/or its affiliates 30 Open Closed Pending On-Hold 1 3 4 2
31. 選択リストの設定 Copyright © 2020, Oracle and/or its affiliates 31 1 2 3
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
33. STATUS_LOVの作成を確認してページ・デザイナに戻る Copyright © 2020, Oracle and/or its affiliates 33 1 2
34. 選択リストの設定と確認 Copyright © 2020, Oracle and/or its affiliates 34 1 2 3 4 5 6
35. カレンダのページを開く Copyright © 2020, Oracle and/or its affiliates 35 1 2 3
36. フォームを開くように拡張 Copyright © 2020, Oracle and/or its affiliates 36 1 2 3 4 5 6 7 8 9 10
37. フォームの確認 Copyright © 2020, Oracle and/or its affiliates 37 1 2
38. 対話グリッドの作成 Copyright © 2020, Oracle and/or its affiliates 38 1 2 3 4 5 6 7 8 9 10
39. 対話グリッドの操作 Copyright © 2020, Oracle and/or its affiliates 39 1 2 3
40. 選択リストの設定と確認 Copyright © 2020, Oracle and/or its affiliates 40 1 2 3 4 5
41. 管理機能の確認 Copyright © 2020, Oracle and/or its affiliates 41 2 1
42. フィードバックの確認 Copyright © 2020, Oracle and/or its affiliates 42 要ブラウザのリロード 1 2 3 4 4 5 6 7 8 9 10
43. テーマ・スタイルの選択 Copyright © 2020, Oracle and/or its affiliates 43 1 2 3 4
44. アクティビティ・レポート Copyright © 2020, Oracle and/or its affiliates 44 1 2 3 4 5
45. 組み込みのアクセス制御 Copyright © 2020, Oracle and/or its affiliates 45 1 2 3 4 5 6 7 8 9
46. 既存表からのアプリケーション作成 Copyright © 2020, Oracle and/or its affiliates 46 1 2 3 4 5 7 6
47. アプリケーションの実行 Copyright © 2020, Oracle and/or its affiliates 47 1
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
49. アプリケーションの作成 Copyright © 2020, Oracle and/or its affiliates 49 1 2 3 4 6 5
50. iPhoneでの見栄えを確認 Copyright © 2020, Oracle and/or its affiliates 50 1 2 3 4 5