Cargando…
Oracle Database XE 11gR2 Jump Start Guide.
Build and manage your Oracle Database XE environment with this fast paced, practical guide.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing,
2012.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Oracle Database XE 11gR2 Jump Start Guide; Oracle Database XE 11gR2 Jump Start Guide; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Support files, eBooks, discount offers and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions; 1. Database Editions and Oracle Database XE; About Oracle; Available database editions.
- Oracle Database Express Edition (XE)Summary; References; 2. Installing and Uninstalling Oracle Database XE; Downloading Oracle Database 11g XE; Installing Oracle Database 11g XE on Windows XP (32-bit); Starting and stopping Oracle Database XE in Windows; Uninstalling Oracle Database 11g XE on Windows XP (32-bit); Installing Oracle Database 11g XE on Oracle Enterprise Linux (64-bit); Starting and stopping Oracle Database XE in Linux; Uninstalling Oracle Database 11g XE on Oracle Enterprise Linux (64-bit); Summary; 3. Connecting and Configuring Oracle Database 11g XE; Local database connections.
- Oracle Net ListenerConfiguring Oracle Net Listener; Viewing the status of Oracle Net Listener; Starting and stopping the listener; Configuring the tnsnames.ora file; Remote database connections; Changing SGA and PGA sizes; Summary; 4. Accessing Table Data, DML Statements, and Transactions; Unlocking sample user accounts; Installing SQL Developer; Connecting SQL Developer to Oracle Database 11g XE; About TAB and DUAL; Writing simple queries; Selecting data from multiple tables; Exploring common functions; What are Transaction Control Statements?; Understanding DML statements; Summary.
- 7. Building a Sample Application with Oracle Application ExpressWhat is Oracle Application Express (APEX)?; Getting started with Oracle Application Express; Application Express components; Prerequisites for a sample application; Creating a sample application; Adding a page to the existing application; Creating application users; Loading and unloading data to a text file; Unloading the EMP table to a text file; Loading text file to the EMP_LOAD table; Application Express Dashboard; Summary; References; 8. Managing Database and Database Storage; Memory structure; System Global Area.