Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Oracle APEXデモンストレーション手順
Search
oracle4engineer
PRO
December 02, 2020
Programming
0
290
Oracle APEXデモンストレーション手順
12/17のOracle Developer Days向けにデモ手順をPPTに記載した。
全部行うと30分程度の時間を要すると思う。
Free Tier上のAPEX 20.2で手順を確認している。
oracle4engineer
PRO
December 02, 2020
Tweet
Share
More Decks by oracle4engineer
See All by oracle4engineer
【Oracle Cloud ウェビナー】知的ワーカーを支援する! AIエンジンの搭載で活用の裾野の拡がる最新データベース事情と構築アプローチ入門
oracle4engineer
PRO
0
22
Oracle Database 23ai 新機能 #2 Oracle True Cache
oracle4engineer
PRO
0
79
Oracle Database 23ai 新機能 #2 Oracle Data Guard per Pluggable Database (DGPDB)
oracle4engineer
PRO
0
25
Oracle Cloud Infrastructure:2024年7月度サービス・アップデート
oracle4engineer
PRO
0
97
【Oracle Cloud ウェビナー】【入門編】はじめてのOracle Analytics Cloud[+最新情報]
oracle4engineer
PRO
1
53
OCI IAM Identity DomainsとAWSとの認証連携設定手順
oracle4engineer
PRO
1
98
Oracle Base Database Service 技術詳細
oracle4engineer
PRO
5
42k
LLMのエコシステム / Ecosystem of LLM
oracle4engineer
PRO
5
450
[自動バックアップのコスト比較]リカバリ・サービス (RCV/ZRCV) とオブジェクト・ストレージ
oracle4engineer
PRO
2
970
Other Decks in Programming
See All in Programming
Rust.Nagoya #1
codemountains
0
170
入社1ヶ月でここまでやった!Findy Toolsインフラ支援の最適化
rvirus0817
6
1.4k
Harnessing Large Language Models for Training-free Video Anomaly Detection
tereka114
1
1.3k
The rollercoaster of releasing an Android, iOS, and macOS app with Kotlin Multiplatform | droidcon Berlin
prof18
0
110
Microservices rules (July 2024) : what good looks like
cer
PRO
0
1.6k
[After Kotlin Fest 2024 LT Night @ Sansan] もっともっとKotlinを好きになる!K2 Compiler Pluginで遊んでみよう!
kitakkun
2
260
Polarsの成長: v0.14からv1.0までの変遷と今後の展望
zerebom
1
350
HMSコンペ 11th Solution (team : kansai-kaggler)
t88
1
680
CSC307 Lecture 12
javiergs
PRO
0
220
Rustのweb開発を助ける 便利なツール紹介
yuki0418
1
190
CSC307 Lecture 06
javiergs
PRO
0
360
Jetpack for KMP
fornewid
1
290
Featured
See All Featured
Principles of Awesome APIs and How to Build Them.
keavy
124
16k
Building Your Own Lightsaber
phodgson
101
5.9k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
78
15k
Designing the Hi-DPI Web
ddemaree
276
34k
The Invisible Customer
myddelton
117
13k
Bash Introduction
62gerente
607
210k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
121
18k
Product Roadmaps are Hard
iamctodd
PRO
48
10k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
36
9.1k
What the flash - Photography Introduction
edds
65
11k
The Art of Programming - Codeland 2020
erikaheidi
48
13k
Fontdeck: Realign not Redesign
paulrobertlloyd
79
5.1k
Transcript
Oracle APEXデモンストレーション手順 Oracle APEX 20.2 Name Presenter’s Title Organization, Division
or Business Unit Month 00, 2020
アプリケーションの元となるCSVファイル Copyright © 2020, Oracle and/or its affiliates 2
アプリケーション・ビルダーから新規アプリケーションを作成 Copyright © 2020, Oracle and/or its affiliates 3 2
3 1
CSVファイルの指定 Copyright © 2020, Oracle and/or its affiliates 4 1
データのロードに関する設定 Copyright © 2020, Oracle and/or its affiliates 5 1
2 3 4 5 6
構成の表示 Copyright © 2020, Oracle and/or its affiliates 6 2
3 4 1
データのロードを実行 Copyright © 2020, Oracle and/or its affiliates 7 1
2 3
アプリケーションの作成 Copyright © 2020, Oracle and/or its affiliates 8 1
2 3 4 5
作成されたアプリケーションとアプリケーションの実行 Copyright © 2020, Oracle and/or its affiliates 9 1
2
アプリケーションの実行 Copyright © 2020, Oracle and/or its affiliates 10 1
3 4 2
Oracle APEXのユーザー認証スキーム Copyright © 2020, Oracle and/or its affiliates 11
1 2 3 4 5 6 7
ダッシュボードを開く Copyright © 2020, Oracle and/or its affiliates 12 1
ダッシュボード 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
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
変更の確認 Copyright © 2020, Oracle and/or its affiliates 15 1
2 3
Tasks検索ページを開く Copyright © 2020, Oracle and/or its affiliates 16 1
Tasks検索ページ Copyright © 2020, Oracle and/or its affiliates 17 1
2 3 4 4 5 6 7
Budget >= 2000をリスト Copyright © 2020, Oracle and/or its affiliates
18 1 2
ファセットのカスタマイズ Copyright © 2020, Oracle and/or its affiliates 19 >=1,000
1,000 – 2,000 >= 2,000 1 2 3 4
範囲の更新 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
更新されたファセットの確認 Copyright © 2020, Oracle and/or its affiliates 21 2
1 3
Tasksレポートのページを開く Copyright © 2020, Oracle and/or its affiliates 22 1
バジェットの更新 Copyright © 2020, Oracle and/or its affiliates 23 1
2 3 4
対話モード・レポートによるソート Copyright © 2020, Oracle and/or its affiliates 24 1
2 3 5 4 6
ハイライトの設定 Copyright © 2020, Oracle and/or its affiliates 25 1
2 3 4 5 6 7
プロジェクトごとの表示 Copyright © 2020, Oracle and/or its affiliates 26 1
2 3 4 5
プロジェクトごとのコストとバジェットの合計 Copyright © 2020, Oracle and/or its affiliates 27 1
2 3 4 5 6 7 8 9
Excel形式でのレポートのダウンロード Copyright © 2020, Oracle and/or its affiliates 28 1
2 3 4 5 6 1
レポートの保存と呼び出し Copyright © 2020, Oracle and/or its affiliates 29 1
2 3 4 5 6 7 8 9
ステータスを選択リストへ変更 Copyright © 2020, Oracle and/or its affiliates 30 Open
Closed Pending On-Hold 1 3 4 2
選択リストの設定 Copyright © 2020, Oracle and/or its affiliates 31 1
2 3
共有コンポーネントの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
STATUS_LOVの作成を確認してページ・デザイナに戻る Copyright © 2020, Oracle and/or its affiliates 33 1
2
選択リストの設定と確認 Copyright © 2020, Oracle and/or its affiliates 34 1
2 3 4 5 6
カレンダのページを開く Copyright © 2020, Oracle and/or its affiliates 35 1
2 3
フォームを開くように拡張 Copyright © 2020, Oracle and/or its affiliates 36 1
2 3 4 5 6 7 8 9 10
フォームの確認 Copyright © 2020, Oracle and/or its affiliates 37 1
2
対話グリッドの作成 Copyright © 2020, Oracle and/or its affiliates 38 1
2 3 4 5 6 7 8 9 10
対話グリッドの操作 Copyright © 2020, Oracle and/or its affiliates 39 1
2 3
選択リストの設定と確認 Copyright © 2020, Oracle and/or its affiliates 40 1
2 3 4 5
管理機能の確認 Copyright © 2020, Oracle and/or its affiliates 41 2
1
フィードバックの確認 Copyright © 2020, Oracle and/or its affiliates 42 要ブラウザのリロード
1 2 3 4 4 5 6 7 8 9 10
テーマ・スタイルの選択 Copyright © 2020, Oracle and/or its affiliates 43 1
2 3 4
アクティビティ・レポート Copyright © 2020, Oracle and/or its affiliates 44 1
2 3 4 5
組み込みのアクセス制御 Copyright © 2020, Oracle and/or its affiliates 45 1
2 3 4 5 6 7 8 9
既存表からのアプリケーション作成 Copyright © 2020, Oracle and/or its affiliates 46 1
2 3 4 5 7 6
アプリケーションの実行 Copyright © 2020, Oracle and/or its affiliates 47 1
クイック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
アプリケーションの作成 Copyright © 2020, Oracle and/or its affiliates 49 1
2 3 4 6 5
iPhoneでの見栄えを確認 Copyright © 2020, Oracle and/or its affiliates 50 1
2 3 4 5
None