O'Reilly logo

Oracle Database 10g: A Beginner's Guide by Michael Corey, Michael Abbey, Ian Abramson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CRITICAL SKILL 7.7

Use SQLJ

SQLJ allows programmers to embed SQL statements directly into Java programs. Experienced Oracle programmers have worked with other embedded SQL environments like Pro*C, Pro*Fortran, and Pro*Cobol. Embedded SQL in Java is named SQLJ, not Pro*Java, because SQLJ is an industry standard and not an Oracle-specific product.

SQLJ Translator

Embedding SQL statements directly into a programming language reduces maintenance and makes it much easier to write Java database programs. A SQLJ translator (precompiler) is used to convert a .sqlj file containing embedded SQL statements into a .java file containing JDBC statements. The translated .java file is then compiled. SQLJ statements can contain queries, DML, transaction control, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required