12/17のOracle Developer Days向けにデモ手順をPPTに記載した。 全部行うと30分程度の時間を要すると思う。
Free Tier上のAPEX 20.2で手順を確認している。
Oracle APEXデモンストレーション手順Oracle APEX 20.2NamePresenter’s TitleOrganization, Division or Business UnitMonth 00, 2020
View Slide
アプリケーションの元となるCSVファイルCopyright © 2020, Oracle and/or its affiliates2
アプリケーション・ビルダーから新規アプリケーションを作成Copyright © 2020, Oracle and/or its affiliates3231
CSVファイルの指定Copyright © 2020, Oracle and/or its affiliates41
データのロードに関する設定Copyright © 2020, Oracle and/or its affiliates5123456
構成の表示Copyright © 2020, Oracle and/or its affiliates62341
データのロードを実行Copyright © 2020, Oracle and/or its affiliates7123
アプリケーションの作成Copyright © 2020, Oracle and/or its affiliates812345
作成されたアプリケーションとアプリケーションの実行Copyright © 2020, Oracle and/or its affiliates912
アプリケーションの実行Copyright © 2020, Oracle and/or its affiliates101342
Oracle APEXのユーザー認証スキームCopyright © 2020, Oracle and/or its affiliates1112345 67
ダッシュボードを開くCopyright © 2020, Oracle and/or its affiliates121
ダッシュボードCopyright © 2020, Oracle and/or its affiliates13https://apex.oracle.com/chartshttps://apex.oracle.com/pls/apex/f?p=18290:11 23 45678
Costチャートの改良Copyright © 2020, Oracle and/or its affiliates14select COST, count(*) valuefrom TASKSgroup by COSTorder by 2 descselect PROJECT, sum(cost) valuefrom TASKSgroup by PROJECTorder by 2 desc1234
変更の確認Copyright © 2020, Oracle and/or its affiliates15123
Tasks検索ページを開くCopyright © 2020, Oracle and/or its affiliates161
Tasks検索ページCopyright © 2020, Oracle and/or its affiliates17123445 67
Budget >= 2000をリストCopyright © 2020, Oracle and/or its affiliates1812
ファセットのカスタマイズCopyright © 2020, Oracle and/or its affiliates19>=1,0001,000 – 2,000>= 2,0001234
範囲の更新Copyright © 2020, Oracle and/or its affiliates201#G#000 - 2#G#000>=2#G#000 2000|1000|2000表示値 戻り値12345
更新されたファセットの確認Copyright © 2020, Oracle and/or its affiliates21213
Tasksレポートのページを開くCopyright © 2020, Oracle and/or its affiliates221
バジェットの更新Copyright © 2020, Oracle and/or its affiliates231234
対話モード・レポートによるソートCopyright © 2020, Oracle and/or its affiliates24123546
ハイライトの設定Copyright © 2020, Oracle and/or its affiliates251234567
プロジェクトごとの表示Copyright © 2020, Oracle and/or its affiliates2612345
プロジェクトごとのコストとバジェットの合計Copyright © 2020, Oracle and/or its affiliates2712 3456 789
Excel形式でのレポートのダウンロードCopyright © 2020, Oracle and/or its affiliates281234561
レポートの保存と呼び出しCopyright © 2020, Oracle and/or its affiliates29123456 7 89
ステータスを選択リストへ変更Copyright © 2020, Oracle and/or its affiliates30OpenClosedPendingOn-Hold1342
選択リストの設定Copyright © 2020, Oracle and/or its affiliates31123
共有コンポーネントのLOV作成Copyright © 2020, Oracle and/or its affiliates32select status d, status rfrom tasksgroup by status1234567891011
STATUS_LOVの作成を確認してページ・デザイナに戻るCopyright © 2020, Oracle and/or its affiliates3312
選択リストの設定と確認Copyright © 2020, Oracle and/or its affiliates34123456
カレンダのページを開くCopyright © 2020, Oracle and/or its affiliates35123
フォームを開くように拡張Copyright © 2020, Oracle and/or its affiliates3612345678910
フォームの確認Copyright © 2020, Oracle and/or its affiliates3712
対話グリッドの作成Copyright © 2020, Oracle and/or its affiliates3812 345678910
対話グリッドの操作Copyright © 2020, Oracle and/or its affiliates39123
選択リストの設定と確認Copyright © 2020, Oracle and/or its affiliates4012345
管理機能の確認Copyright © 2020, Oracle and/or its affiliates4121
フィードバックの確認Copyright © 2020, Oracle and/or its affiliates42要ブラウザのリロード123445678910
テーマ・スタイルの選択Copyright © 2020, Oracle and/or its affiliates431234
アクティビティ・レポートCopyright © 2020, Oracle and/or its affiliates4412345
組み込みのアクセス制御Copyright © 2020, Oracle and/or its affiliates45123456789
既存表からのアプリケーション作成Copyright © 2020, Oracle and/or its affiliates4612345 76
アプリケーションの実行Copyright © 2020, Oracle and/or its affiliates471
クイックSQLによるアプリケーション作成Copyright © 2020, Oracle and/or its affiliates48qs_tasks /insert 73projecttask_nameassigned_tostart_dateend_datestatuscost numberbudget number1234 5678
アプリケーションの作成Copyright © 2020, Oracle and/or its affiliates49123465
iPhoneでの見栄えを確認Copyright © 2020, Oracle and/or its affiliates5012345