LEADER 04847nam 2200649 a 450 001 9910779495903321 005 20200520144314.0 010 $a1-282-11183-3 010 $a9786613804020 010 $a1-84968-675-0 035 $a(CKB)2550000000107850 035 $a(EBL)978121 035 $a(OCoLC)806205260 035 $a(SSID)ssj0000738632 035 $a(PQKBManifestationID)12341214 035 $a(PQKBTitleCode)TC0000738632 035 $a(PQKBWorkID)10790487 035 $a(PQKB)10838626 035 $a(MiAaPQ)EBC978121 035 $a(Au-PeEL)EBL978121 035 $a(CaPaEBR)ebr10580617 035 $a(CaONFJC)MIL380402 035 $a(PPN)228018609 035 $a(EXLCZ)992550000000107850 100 $a20120731d2012 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aOracle Database XE 11gR2 jump start guide$b[electronic resource] $ebuild and manage your Oracle Database 11gXE environment with this fast paced, practical guide /$fAsif Momen 210 $aBirmingham $cPackt Pub.$d2012 215 $a1 online resource (146 p.) 300 $aDescription based upon print version of record. 311 $a1-84968-674-2 320 $aIncludes bibliographical references and index. 327 $aCover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Database Editions and Oracle Database XE; About Oracle; Available database editions; Oracle Database Express Edition (XE); Summary; References; Chapter 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) 327 $aInstalling 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; Chapter 3: Connecting and Configuring Oracle Database 11g XE; Local database connections; Oracle Net Listener; Configuring 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; Chapter 4: Accessing Table Data, DML Statements, and Transactions 327 $aUnlocking sample user accountsInstalling 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; References; Chapter 5: Creating and Managing Schema Objects; Data Definition Language; Creating and managing tables; Creating and managing indexes; Integrity constraints; Creating and managing views; Creating and managing synonyms; Creating and managing sequences; Gathering statistics; Summary 327 $aReferencesChapter 6: Developing Stored Subprograms and Triggers; PL/SQL data types; Stored subprograms; Creating stored subprograms; About packages; Creating packages; Exception handling; Wrapping up the PL/SQL stored programs; PL/SQL triggers; Summary; References; Chapter 7: Building a Sample Application with Oracle Application Express; What 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 327 $aCreating application usersLoading 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; Chapter 8: Managing Database and Database Storage; Memory structure; System Global Area; Process Global Area; Automatic Memory Management; Important background processes; Physical and logical database structures; Creating a tablespace; Adding datafiles to a tablespace; Dropping a tablespace; Viewing the tablespace usage; Managing the Flash Recovery Area; Summary 327 $aChapter 9: Moving Data between Oracle Databases 330 $aBuild and manage your Oracle Database XE environment with this fast paced, practical guide 606 $aDatabase management 606 $aOnline databases 615 0$aDatabase management. 615 0$aOnline databases. 676 $a005.75 676 $a005.75/65 700 $aMomen$b Asif$01533488 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910779495903321 996 $aOracle Database XE 11gR2 jump start guide$93780514 997 $aUNINA