24 Results for:DDL

  • Sort by: 

Build a Hibernate SessionFactory by example

By Cameron McKenzie 02 Aug 2020

Hibernate SessionFactory tutorial If a developer uses the Hibernate core framework, they will need to build a SessionFactory before they can do any data persistence. As the name implies, the ... Read More

Calling stored procedures inside user-defined functions in Oracle Database

By Brian Peasland 03 Aug 2012

In this expert answer, Brian Peasland explains how to call a stored procedure inside user-defined functions in Oracle Database. Read More

Oracle’s MySQL 5.6 spans to NoSQL to offer more agility

By Brian McKenna 06 Feb 2013

Oracle has released version 5.6 of MySQL, which will hit the “sweet spot of the web market” according to Tomas Ulin, vice-president of engineering Read More

Easy way to import public synonyms?

By Brian Peasland 09 Jan 2006

Using export/import to update a development database, I normally do a schema (user) import. Is there an easy way to import public synonyms? Read More

Exporting selected procedures and functions in Oracle

By Brian Peasland 28 Aug 2006

How can we export selected procedures/functions/packages in Oracle? Read More

When to use double quotes in Oracle column to avoid invalid identifier

By Dan Clamage 01 Feb 2010

Are you seeing an invalid identifier? Learn when to use double quotes in Oracle column names to avoid this in this tip from PL/SQL expert Dan Clamage. Read More

Unit-Testing Hibernate With HSQLDB

01 Apr 2005

Unit-testing should have as few barriers as possible. For relational databases those barriers range from external dependencies to speed to keeping the relational schema synchronized with your object model. For ... Read More

Using Hibernate 3.5 as a JPA 2.0 Persistence Implementation

21 Jun 2010

Are you interested in JPA 2.0, and you want to use Hibernate as your implementation? This tutorial shows you how easy it is to take your JPA annotated components and use the Hibernate 3.5 as your implementation. Read More

Using parallel SQL with Oracle parallel hint to improve database performance

10 Nov 2010

Enhance customers' Oracle database performance by using parallel SQL with an Oracle parallel hint, enabling a SQL statement to be simultaneously processed by multiple threads or processes. Read More