Page 1
Program Studi Teknik Informatika
Fakultas Ilmu Komputer
Universitas Mercu Buana
MATA KULIAH PRAKTIKUM PERANCANGAN BASIS DATA
Modul 7 – Pemrograman PL/SQL: Input Menggunakan Select List (Combo Box)
Oleh: Anis Cherid, M.T.I.
Modul ini merupakan kelanjutan dari modul sebelumnya. Dalam modul ini, secara khusus akan dibahas teknik menggunakan item berjenis select list (combo box) untuk menerima input dari
pemakai aplikasi. Dalam contoh yang disajikan, kode-kode program untuk melakukan interaksi dengan item select list digabungkan dalam sebuah tempat pemrosesan yang sama dengan
kode-kode program untuk melakukan interaksi dengan item text box (yang sebelumnya sudah diketikkan pada modul sebelumnya). Dalam modul ini juga disajikan sebuah contoh kemungkinan
kesalahan (error) yang muncul ketika aplikasi dieksekusi dan bagaimana cara memperbaikinya. Setelah menyelesaikan modul ini, anda akan semakin mengenal berbagai teknik berinteraksi
dan melakukan pemrograman menggunakan PL/SQL. Selamat mencoba.
Left click on "Edit Page 1 (editable text)" in "Page 1 - Windows Internet Explorer"
No screenshots were saved for this problem step.
Previous Next
Left click on "Create (graphic)" in "Page Definition (Page 1) - Windows Internet Explorer"
No screenshots were saved for this problem step.
Previous Next
Left click on "Next > (push button)" in "Create Region - Windows Internet Explorer"
No screenshots were saved for this problem step.
Page 2
Previous Next
Keyboard input in "Create Region - Windows Internet Explorer" [... Backspace ... Backspace Backspace ... Shift ...]
Page 3
Previous Next
Left click on "Column (text)" in "Create Region - Windows Internet Explorer"
Page 4
Previous Next
Left click on "2 (list item)"
Page 5
Previous Next
Left click on "Next > (push button)" in "Create Region - Windows Internet Explorer"
Page 6
Previous Next
Left click on "Create Region (push button)" in "Create Region - Windows Internet Explorer"
Page 7
Previous Next
Left click on "Create (graphic)" in "Page Definition (Page 1) - Windows Internet Explorer"
Page 8
Previous Next
Left click on "Select List (radio button)" in "Create Item - Windows Internet Explorer"
Page 9
Previous Next
Left click on "Next > (push button)" in "Create Item - Windows Internet Explorer"
Page 10
Previous Next
Left click on "Select List with Submit (radio button)" in "Create Item - Windows Internet Explorer"
Page 11
Previous Next
Left click on "Next > (push button)" in "Create Item - Windows Internet Explorer"
Page 12
Previous Next
Left click on "Item Name (editable text)" in "Create Item - Windows Internet Explorer"
Page 13
Previous Next
Keyboard input in "Create Item - Windows Internet Explorer" [Backspace ...]
Page 14
Previous Next
Left click on "Open (push button)" in "Create Item - Windows Internet Explorer"
Page 15
Previous Next
Left click on "Input Select List - Output Text Box (2) 21 (list item)"
Page 16
Previous Next
Left click on "Next > (push button)" in "Create Item - Windows Internet Explorer"
Page 17
Previous Next
Left click on "List of Values Query (editable text)" in "Item List of Values (step 1b of 4) - Windows Internet Explorer"
Page 18
Previous Next
Keyboard input in "Item List of Values (step 1b of 4) - Windows Internet Explorer" [... Backspace Backspace ...]
Page 19
Previous Next
Comment: "Ketikkan warna-warna pelangi. Gunakan huruf besar untuk STATIC."
Page 20
Previous Next
Left click on "Next > (push button)" in "Item List of Values (step 1b of 4) - Windows Internet Explorer"
Page 21
Previous Next
Left click on "[Clear] (editable text)" in "Create Item - Windows Internet Explorer"
Page 22
Previous Next
Left click on "Label (editable text)" in "Create Item - Windows Internet Explorer"
Page 23
Previous Next
Keyboard input in "Create Item - Windows Internet Explorer" [...]
Page 24
Previous Next
Left click on "Next > (push button)" in "Create Item - Windows Internet Explorer"
Page 25
Previous Next
Left click on "Create Item (push button)" in "Create Item - Windows Internet Explorer"
Page 26
Previous Next
Left click on "Create (graphic)" in "Page Definition (Page 1) - Windows Internet Explorer"
Page 27
Previous Next
Left click on "Text (radio button)" in "Create Item - Windows Internet Explorer"
Page 28
Previous Next
Left click on "Next > (push button)" in "Create Item - Windows Internet Explorer"
Page 29
Previous Next
Left click on "Text Field (Disabled, does not save state) (radio button)" in "Create Item - Windows Internet Explorer"
Page 30
Previous Next
Left click on "Next > (push button)" in "Create Item - Windows Internet Explorer"
Page 31
Previous Next
Left click on "Item Name (editable text)" in "Create Item - Windows Internet Explorer"
Page 32
Previous Next
Keyboard input in "Create Item - Windows Internet Explorer" [Backspace ...]
Page 33
Previous Next
Left click on "Open (push button)" in "Create Item - Windows Internet Explorer"
Page 34
Previous Next
Left click on "Input Select List - Output Text Box (2) 21 (list item)"
Page 35
Previous Next
Left click on "Next > (push button)" in "Create Item - Windows Internet Explorer"
Page 36
Previous Next
Left click on "[Clear] (editable text)" in "Create Item - Windows Internet Explorer"
Page 37
Previous Next
Keyboard input in "Create Item - Windows Internet Explorer" [... Backspace Backspace ...]
Page 38
Previous Next
Left click on "Next > (push button)" in "Create Item - Windows Internet Explorer"
Page 39
Previous Next
Left click on "Create Item (push button)" in "Create Item - Windows Internet Explorer"
Page 40
Previous Next
Comment: "Kita akan memodifikasi kode PL/SQL sebelumnya agar dapat mengakomodasi pilihan pada LISTINPUT"
Page 41
Previous Next
Left click on "Create (graphic)" in "Page Definition (Page 1) - Windows Internet Explorer"
Page 42
Previous Next
Left click on "Next > (push button)" in "Create Page Process - Windows Internet Explorer"
Page 43
Previous Next
Comment: "Kita akan memodifikasi kode yang ada di dalam proses PL/SQL, tolong klik CANCEL."
Page 44
Previous Next
Left click on "Cancel (push button)" in "Create Page Process - Windows Internet Explorer"
Page 45
Previous Next
Left click on "Tulis Ouput (editable text)" in "Page Definition (Page 1) - Windows Internet Explorer"
Page 46
Previous Next
Left click on "Process [Download Source] (editable text)" in "Edit Page Process - Windows Internet Explorer"
Page 47
Previous Next
Keyboard input in "Edit Page Process - Windows Internet Explorer" [Enter ... Backspace ...]
Page 48
Previous Next
Comment: "Baris kode yang baru kita tambahkan"
Page 49
Previous Next
Left click on "Apply Changes (push button)" in "Edit Page Process - Windows Internet Explorer"
Page 50
Previous Next
Comment: "Kita juga harus menambah sebuah BRANCHES baru, karena BRANCHES sebelumnya adalah milik dari BUTTON:SUBMIT."
Page 51
Previous Next
Left click on "Create (graphic)" in "Page Definition (Page 1) - Windows Internet Explorer"
Page 52
Previous Next
Comment: "Pilih 'Branch to Page or URL'"
Page 53
Previous Next
Left click on "Next > (push button)" in "Create Branch - Windows Internet Explorer"
Page 54
Previous Next
Left click on "Page (editable text)" in "Create Branch - Windows Internet Explorer"
Page 55
Previous Next
Keyboard input in "Create Branch - Windows Internet Explorer" [...]
Page 56
Previous Next
Left click on "Next > (push button)" in "Create Branch - Windows Internet Explorer"
Page 57
Previous Next
Left click on "Create Branch (push button)" in "Create Branch - Windows Internet Explorer"
Page 58
Previous Next
Left click on "Run Page 1 (graphic)" in "Page Definition (Page 1) - Windows Internet Explorer"
Page 59
Previous Next
Left click on "Open (push button)" in "Page 1 - Windows Internet Explorer"
Previous Next
Page 60
Left click on "Biru (list item)"
Previous Next
Page 61
Comment: "Pesan kesalahan ini muncul karena kita salah mengetikkan nama item yang terdapat pada halaman ke dalam kode PL/SQL."
Previous Next
Page 62
Left click on "Edit Page 1 (editable text)" in "Page 1 - Windows Internet Explorer"
Previous Next
Page 63
Left click on "Tulis Ouput (editable text)" in "Page Definition (Page 1) - Windows Internet Explorer"
Previous Next
Page 64
Left click on "Process [Download Source] (editable text)" in "Edit Page Process - Windows Internet Explorer"
Previous Next
Page 65
Left click on "Find Items (editable text)" in "Edit Page Process - Windows Internet Explorer"
Previous Next
Page 66
Mouse drag start on "P1_TEXTOUPUTFORLIST (editable text)" in "Item Finder - Windows Internet Explorer"
Previous Next
Page 67
Mouse drag end on "Item Finder (pane)" in "Item Finder - Windows Internet Explorer"
Previous Next
Page 68
Keyboard input in "Item Finder - Windows Internet Explorer" [... Ctrl-C]
Previous Next
Page 69
Left click on "Close (push button)" in "Item Finder - Windows Internet Explorer"
Previous Next
Page 70
Mouse drag start on "Process [Download Source] (editable text)" in "Edit Page Process - Windows Internet Explorer"
Previous Next
Page 71
Mouse drag end on "Process [Download Source] (editable text)" in "Edit Page Process - Windows Internet Explorer"
Previous Next
Page 72
Keyboard input in "Edit Page Process - Windows Internet Explorer" [... Ctrl-V]
Previous Next
Page 73
Comment: "Sebelumnya tertulis :P1_TEXTOUTPUTFORLIST, seharusnya :P1_TEXTOUPUTFORLIST (OUPUT bukan OUTPUT)."
Previous Next
Page 74
Left click on "Apply Changes (push button)" in "Edit Page Process - Windows Internet Explorer"
Previous Next
Page 75
Left click on "Run Page 1 (graphic)" in "Page Definition (Page 1) - Windows Internet Explorer"
Previous Next
Page 76
Left click on "Open (push button)" in "Page 1 - Windows Internet Explorer"
Previous Next
Page 77
Left click on "Hijau (list item)"
Previous Next
Page 78
Left click on "Open (push button)" in "Page 1 - Windows Internet Explorer"
Previous Next
Page 79
Left click on "Ungu (list item)"
Previous Next
Page 80
Left click on "Open (push button)" in "Page 1 - Windows Internet Explorer"
Previous Next
Page 81
Left click on "% (list item)"
Previous Next
Page 82
Comment: "Tanda % merepresentasikan nilai NULL. Agar tidak muncul..."
Previous Next
Page 83
Left click on "Edit Page 1 (editable text)" in "Page 1 - Windows Internet Explorer"
Previous Next
Page 84
Left click on ": P1_LISTINPUT (editable text)" in "Page Definition (Page 1) - Windows Internet Explorer"
Previous Next
Page 85
Mouse drag start on "Edit Page Item (pane)" in "Edit Page Item - Windows Internet Explorer"
Previous Next
Page 86
Mouse drag end on "Edit Page Item (pane)" in "Edit Page Item - Windows Internet Explorer"
Previous Next
Page 87
Comment: "Ganti 'Display Null': Yes dengan No."
Previous Next
Page 88
Left click on "Open (push button)" in "Edit Page Item - Windows Internet Explorer"
Previous Next
Page 89
Left click on "No (list item)"
Previous Next
Page 90
Mouse drag start on "Edit Page Item (pane)" in "Edit Page Item - Windows Internet Explorer"
Previous Next
Page 91
Mouse drag end on "Edit Page Item (pane)" in "Edit Page Item - Windows Internet Explorer"
Previous Next
Page 92
Left click on "Apply Changes (push button)" in "Edit Page Item - Windows Internet Explorer"
Previous Next
Page 93
Left click on "Run Page 1 (graphic)" in "Page Definition (Page 1) - Windows Internet Explorer"
Previous Next
Page 94
Left click on "Open (push button)" in "Page 1 - Windows Internet Explorer"
Previous Next
Page 95
Left click on "Hijau (list item)"
Previous Next
Page 96
Left click on "Open (push button)" in "Page 1 - Windows Internet Explorer"
Previous Next
Page 97
Left click on "Merah (list item)"
Previous Next
Page 98
Left click on "Open (push button)" in "Page 1 - Windows Internet Explorer"
Previous Next
Page 99
Comment: "Supaya susunan tidak berubah, lakukan..."
Previous Next
Page 100
Left click on "Edit Page 1 (editable text)" in "Page 1 - Windows Internet Explorer"
Previous Next
Page 101
Left click on ": P1_LISTINPUT (editable text)" in "Page Definition (Page 1) - Windows Internet Explorer"
Previous Next
Page 102
Mouse drag start on "Edit Page Item (pane)" in "Edit Page Item - Windows Internet Explorer"
Previous Next
Page 103
Mouse drag end on "Edit Page Item (pane)" in "Edit Page Item - Windows Internet Explorer"
Previous Next
Page 104
Comment: "Ganti STATIC dengan STATIC2"
Previous Next
Page 105
Left click on "List of values definition (editable text)" in "Edit Page Item - Windows Internet Explorer"
Previous Next
Page 106
Keyboard input in "Edit Page Item - Windows Internet Explorer" [...]
Previous Next
Page 107
Mouse drag start on "Edit Page Item (pane)" in "Edit Page Item - Windows Internet Explorer"
Previous Next
Page 108
Mouse drag end on "Edit Page Item (pane)" in "Edit Page Item - Windows Internet Explorer"
Previous Next
Page 109
Left click on "Apply Changes (push button)" in "Edit Page Item - Windows Internet Explorer"
Previous Next
Page 110
Left click on "Run Page 1 (graphic)" in "Page Definition (Page 1) - Windows Internet Explorer"
Previous Next
Page 111
Left click on "Pilih warna (combo box)" in "Page 1 - Windows Internet Explorer"
Previous Next
Page 112
Left click on "Ungu (list item)"
Previous Next
Page 113
Left click on "Page 1 (pane)" in "Page 1 - Windows Internet Explorer"