Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL / SQL programs, and more. This book contains everything you need to master SQL. Explore SQL Plus and SQL DeveloperUse SQL SELECT, INSERT, UPDATE, and DELETE statementsWrite PL / SQL programsCreate tables, sequences, indexes, views, and triggersWrite advanced query that contains a database of complex objects and collections of analytical functionsCreate to handle large abstract objects dataUse to handle multimedia files containing music and moviesWrite Java programs to access Oracle Database using SQL statements JDBCTune you to make them implement the XML capabilities of Oracle fasterExplore DatabaseMaster very latest Oracle Database 11g features, such as PIVOT and UNPIVOT, flashback archives, and more