Learn to integrate your SQl developer with open source version with Oracle Sql developer
Use the powerful GUI to browse your database objects, run SQL statements and scripts, and create, edit, debug, and test PL/SQL code in a highly productive environment with new book from Oracle SQl developer 2.1

Loading and Exporting Data
A collection of 27 FAQs on Oracle loading data and exporting data. Clear answers are provided with tutorial exercises on saving data as flat files, loading data from flat, exporting and importing database, schema and tables, creating external tables.

Understanding SQL SELECT Query Statements
A collection of 33 FAQs on Oracle SQL SELECT query statements. Clear answers are provided with tutorial exercises on selecting rows and columns from tables and views, sorting and counting query outputs, grouping outputs and applying group functions, joining tables, using subqueries.

Understanding SQL Transaction Management
A collection of 22 FAQs on Oracle SQL SELECT query statements. Clear answers are provided with tutorial exercises on starting and ending transactions, committing and rolling back transactions, transaction/statement-level read consistency, read committed isolation level, locks and dead locks.

Managing Oracle User Accounts, Schema and Privileges
A collection of 23 FAQs on Oracle user account, schema and privileges. Clear answers are provided with tutorial exercises on creating user accounts, granting privileges for session connections, granting privileges for creating tables and inserting rows.

Understanding SQL DDL Statements
A collection of 12 FAQs on Oracle SQL DDL statements. Clear answers are provided with tutorial exercises on creating, altering and dropping tables, indexes, and views.

Creating Your Own PL/SQL Procedures and Functions
A collection of 26 FAQs on PL/SQL managing our own procedures. It can also be used as learning tutorials on creating procedures and functions, executing and dropping procedures, passing actual parameters to formal parameters, making optional parameters.

Managing Oracle Tablespaces and Data Files
This is a collection of FAQ for Oracle DBA on creating and managing tablespaces and data files. The clear answers and sample scripts provided can be used as learning tutorials or interview preparation guides.

Creating New Database Instance Manually
This is a collection of FAQ for Oracle DBA on creating Oracle database instances manually using CREATE DATABASE statement. Items in this FAQ collection are organized together to form a complete tutorial guide on creating a new database instance manually.

Expert One-on-One: Oracle: Part 1
This manuscript is Chapter 1 "Developing Successful Oracle Applications" from the Wrox Press book Expert One on One: Oracle. This first part covers developing successful Oracle applications and the Black Box approach.

Expert One-on-One: Oracle: Part 2
This manuscript is Chapter 1 "Developing Successful Oracle Applications" from the Wrox Press book Expert One on One: Oracle. The second installment covers understanding Oracle architecture, using bind variables, understanding concurrency control, and multi-versioning.

Expert One-on-One: Oracle: Part 3
This third installment looks at database independence, the impact of standards, features and functions, and solving problems simply. This manuscript is Chapter 1 "Developing Successful Oracle Applications" from the Wrox Press book Expert One on One: Oracle.

Expert One-on-One: Oracle: Part 4
This fourth and final installment looks at making the database run faster and the DBA-developer relationship. This manuscript is Chapter 1 "Developing Successful Oracle Applications" from the Wrox Press book Expert One on One: Oracle.

Global Statistics vs. Histograms with DBMS_STATS Package
Optimisation is the process of choosing the most efficient way to execute a SQL statement. The cost-based optimiser uses statistics to calculate the selectivity of predicates and to estimate the cost of each execution plan.

Analytic Functions in Oracle 8i and 9i
Analytic Functions, which have been available since Oracle 8.1.6, are designed to address such problems as "Calculate a running total", "Find percentages within a group", "Top-N queries", "Compute a moving average" and many more. Most of these problems can be solved using standard PL/SQL, however the performance is often not what it should be. Analytic Functions add extensions to the SQL language that not only make these operations easier to code; they make them faster than could be achieved with pure SQL or PL/SQL.