Table of Contents
- List of Tables
- Title and Copyright Information
- Preface
-
1
Introduction to Tools and Products that Support Migration
-
1.1
Oracle Database Features for Migration Support
- 1.1.1 SQL Translation Framework
- 1.1.2 Support for MySQL Applications
- 1.1.3 Support for Identity Columns
- 1.1.4 Implicit Statement Results
- 1.1.5 Enhanced SQL to PL/SQL Bind Handling
- 1.1.6 Native SQL Support for Query Row Limits and Row Offsets
- 1.1.7 JDBC Driver Support for Application Migration
- 1.1.8 ODBC Driver Support for Application Migration
- 1.2 Other Oracle Products that Enable Migration
- 1.3 Migration Support for Other Database Vendors
-
1.1
Oracle Database Features for Migration Support
- 2 SQL Translation Framework Overview
-
3
SQL Translation Framework Configuration
- 3.1 Installing and Configuring SQL Translation Framework with Oracle SQL Developer
- 3.2 Installing and Configuring SQL Translation Framework from Command Line
- 3.3 Granting Necessary Permissions for Installing the SQL Translator
- 4 SQL Translation of JDBC and ODBC Applications
- 5 Example: Application Migration Using SQL Translation Framework
- 6 MySQL Client Library Driver for Oracle
-
7
API Reference for Oracle MySQL Client Library Driver
-
7.1
Mapping Data Types
- 7.1.1 Mapping Oracle Data Types to MySQL Data Types
-
7.1.2
Data Type Conversions for MySQL Program Variable Data Types
- 7.1.2.1 MYSQL_TYPE_BLOB
- 7.1.2.2 MYSQL_TYPE_DATE
- 7.1.2.3 MYSQL_TYPE_DATETIME
- 7.1.2.4 MYSQL_TYPE_DOUBLE
- 7.1.2.5 MYSQL_TYPE_FLOAT
- 7.1.2.6 MYSQL_TYPE_LONG
- 7.1.2.7 MYSQL_TYPE_LONG_BLOB
- 7.1.2.8 MYSQL_TYPE_LONGLONG
- 7.1.2.9 MYSQL_TYPE_MEDIUM_BLOB
- 7.1.2.10 MYSQL_TYPE_NEWDECIMAL
- 7.1.2.11 MYSQL_TYPE_SHORT
- 7.1.2.12 MYSQL_TYPE_STRING
- 7.1.2.13 MYSQL_TYPE_TIME
- 7.1.2.14 MYSQL_TYPE_TIMESTAMP
- 7.1.2.15 MYSQL_TYPE_TINY
- 7.1.2.16 MYSQL_TYPE_TINY_BLOB
- 7.1.2.17 MYSQL_TYPE_VAR_STRING
- 7.1.3 Data Type Conversions for MySQL External Data Types (LOB Data Type Descriptors)
- 7.1.4 Data Type Conversions for Datetime and Interval Data Types
- 7.2 Error Handling
-
7.3
Available Oracle Support for MySQL APIs
- 7.3.1 my_init()
- 7.3.2 mysql_affected_rows()
- 7.3.3 mysql_autocommit()
- 7.3.4 mysql_change_user()
- 7.3.5 mysql_character_set_name()
- 7.3.6 mysql_close()
- 7.3.7 mysql_commit()
- 7.3.8 mysql_connect()
- 7.3.9 mysql_create_db()
- 7.3.10 mysql_data_seek()
- 7.3.11 mysql_debug()
- 7.3.12 mysql_debug_info()
- 7.3.13 mysql_drop_db()
- 7.3.14 mysql_dump_debug_info()
- 7.3.15 mysql_eof()
- 7.3.16 mysql_errno()
- 7.3.17 mysql_error()
- 7.3.18 mysql_escape_string()
- 7.3.19 mysql_fetch_field()
- 7.3.20 mysql_fetch_field_direct()
- 7.3.21 mysql_fetch_fields()
- 7.3.22 mysql_fetch_lengths()
- 7.3.23 mysql_fetch_row()
- 7.3.24 mysql_field_count()
- 7.3.25 mysql_field_seek()
- 7.3.26 mysql_field_tell()
- 7.3.27 mysql_free_result()
- 7.3.28 mysql_get_character_set_info()
- 7.3.29 mysql_get_client_info()
- 7.3.30 mysql_get_client_version()
- 7.3.31 mysql_get_host_info()
- 7.3.32 mysql_get_proto_info()
- 7.3.33 mysql_get_server_info()
- 7.3.34 mysql_get_server_version()
- 7.3.35 mysql_get_ssl_cipher()
- 7.3.36 mysql_hex_string()
- 7.3.37 mysql_info()
- 7.3.38 mysql_init()
- 7.3.39 mysql_insert_id()
- 7.3.40 mysql_kill()
- 7.3.41 mysql_library_end()
- 7.3.42 mysql_library_init()
- 7.3.43 mysql_list_dbs()
- 7.3.44 mysql_list_fields()
- 7.3.45 mysql_list_processes()
- 7.3.46 mysql_list_tables()
- 7.3.47 mysql_more_results()
- 7.3.48 mysql_next_result()
- 7.3.49 mysql_num_fields()
- 7.3.50 mysql_num_rows()
- 7.3.51 mysql_options()
- 7.3.52 mysql_ping()
- 7.3.53 mysql_query()
- 7.3.54 mysql_read_query_result()
- 7.3.55 mysql_real_connect()
- 7.3.56 mysql_real_escape_string()
- 7.3.57 mysql_real_query()
- 7.3.58 mysql_refresh()
- 7.3.59 mysql_reload()
- 7.3.60 mysql_rollback()
- 7.3.61 mysql_row_seek()
- 7.3.62 mysql_row_tell()
- 7.3.63 mysql_select_db()
- 7.3.64 mysql_send_query()
- 7.3.65 mysql_server_end()
- 7.3.66 mysql_server_init()
- 7.3.67 mysql_set_character_set()
- 7.3.68 mysql_set_local_infile_default()
- 7.3.69 mysql_set_local_infile_handler()
- 7.3.70 mysql_set_server_option()
- 7.3.71 mysql_shutdown()
- 7.3.72 mysql_sqlstate()
- 7.3.73 mysql_ssl_set()
- 7.3.74 mysql_stat()
- 7.3.75 mysql_stmt_affected_rows()
- 7.3.76 mysql_stmt_attr_get()
- 7.3.77 mysql_stmt_attr_set()
- 7.3.78 mysql_stmt_bind_param()
- 7.3.79 mysql_stmt_bind_result()
- 7.3.80 mysql_stmt_close()
- 7.3.81 mysql_stmt_data_seek()
- 7.3.82 mysql_stmt_errno()
- 7.3.83 mysql_stmt_error()
- 7.3.84 mysql_stmt_execute()
- 7.3.85 mysql_stmt_fetch()
- 7.3.86 mysql_stmt_fetch_column()
- 7.3.87 mysql_stmt_field_count()
- 7.3.88 mysql_stmt_free_result()
- 7.3.89 mysql_stmt_init()
- 7.3.90 mysql_stmt_insert_id()
- 7.3.91 mysql_stmt_next_result()
- 7.3.92 mysql_stmt_num_rows()
- 7.3.93 mysql_stmt_param_count()
- 7.3.94 mysql_stmt_param_metadata()
- 7.3.95 mysql_stmt_prepare()
- 7.3.96 mysql_stmt_reset()
- 7.3.97 mysql_stmt_result_metadata()
- 7.3.98 mysql_stmt_row_seek()
- 7.3.99 mysql_stmt_row_tell()
- 7.3.100 mysql_stmt_send_long_data()
- 7.3.101 mysql_stmt_sqlstate()
- 7.3.102 mysql_stmt_store_result()
- 7.3.103 mysql_store_result()
- 7.3.104 mysql_thread_end()
- 7.3.105 mysql_thread_id()
- 7.3.106 mysql_thread_init()
- 7.3.107 mysql_thread_safe()
- 7.3.108 mysql_use_result()
- 7.3.109 mysql_warning_count()
-
7.1
Mapping Data Types
- 8 API Reference for SQL Translation of JDBC Applications
- Glossary
- Index