CONTENTS
Table of Contents
1- How to select RIGHT TOOL FOR DATA ................. 14
2 - How to Install Oracle-XE ........................................ 18
3-HOW TO INSTALL APEX 3.2.1 .............................. 21
4. HOW TO USE RESOURCED ORACLE-APEX..... 23
5-HOW TO CREATE USER ACCOUNTS .................. 25
6-HOW TO CREATE WORKSPACE .......................... 28
7- HOW TO LAND IN APEX HOME PAGE .............. 32
9 - HOW TO CREATE TABLE ................................... 43
10-00 HOW TO ALTER TABLE PROPERTIES ......... 55
10.01 How to add another column on the existing table. 55
10.02 How to change the data type? ..................... 56
10.03 How to change the column name ?............. 57
10.04 How to delete the column? ............................. 58
10.05 How to create another table with the same set of column and data? ...................................................... 59
11 - HOW TO RETRIEVE TEXT DATA .................... 63
11.01 How to display one column from a table ........ 64
11.02 How to display one column data with a label I
title ............................................................................ 65
11.03 How to display title I label without conversion
as uppercase and as we entered................................. 65
11.04 How to display all the column values with column name as title ................................................. 66
11.05 How do we make conditional display of column values?....................................................................... 66
11.06 How do we make conditional display with partial given data? ..................................................... 67