My Oracle Support Banner

HOWTO Convert Oracle RDBMS SCOTT.EMP Demo Table to BDB using the db_sql_codegen Utility (Doc ID 1471888.1)

Last updated on APRIL 13, 2020

Applies to:

Berkeley DB - Version 5.3.21 and later
Information in this document applies to any platform.


The purpose of this article it is to help the new BDB user having a SQL background
to learn BDB C API equivalent statements with the help of the db_sql_codegen command line utility

NOTE: The data used below are not actual PRODUCTION or Customer Data, they are Oracle supplied sample tables/data.  They are being used ONLY to demonstrate the problem discussed in this note.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Create the db_sql_codegen Utility if not already installed in your BDB Home
 Create the Sql Script to create the EMP table
 Generate the BDB C files for the SCOTT.EMP table
 Generate The Test_Emp Program
 Test_Emp Output

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.