Oracle Database 11g & MySQL 5.6 Developer Handbook

Bok av Michael McLaughlin
Master Application Development in a Mixed-Platform Environment Build powerful database applications in a mixed environment using the detailed information in this Oracle Press guide. Oracle Database 11g & MySQL 5.6 Developer Handbook lays out programming strategies and best practices for seamlessly operating between the two platforms. Find out how to migrate databases, port SQL dialects, work with Oracle MySQL databases, and configure effective queries. Security, monitoring, and tuning techniques are also covered in this comprehensive volume. Understand Oracle Database 11g and MySQL 5.6 architectureConvert databases between platforms and ensure transactional integrityCreate tables, sequences, indexes, views, and user accountsBuild and debug PL/SQL, SQL*Plus, SQL/PSM, and MySQL Monitor scriptsExecute complex queries and handle numeric and date mathematicsMerge data from source tables and set up virtual directories