Create an Oracle Table to Store Java Types (Using Statement Objects) : Oracle « Database « Java Tutorial

Java Tutorial
1. Language
2. Data Type
3. Operators
4. Statement Control
5. Class Definition
6. Development
7. Reflection
8. Regular Expressions
9. Collections
10. Thread
11. File
12. Generics
13. I18N
14. Swing
15. Swing Event
16. 2D Graphics
17. SWT
18. SWT 2D Graphics
19. Network
20. Database
21. Hibernate
22. JPA
23. JSP
24. JSTL
25. Servlet
26. Web Services SOA
27. EJB3
28. Spring
29. PDF
30. Email
31. J2ME
32. J2EE Application
33. XML
34. Design Pattern
35. Log
36. Security
37. Apache Common
38. Ant
39. JUnit
Java
Java Source Code / Java Documentation
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
Photoshop Tutorials
Maya Tutorials
Flash Tutorials
3ds-Max Tutorials
Illustrator Tutorials
GIMP Tutorials
C# / C Sharp
C# / CSharp Tutorial
C# / CSharp Open Source
ASP.Net
ASP.NET Tutorial
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Ruby
PHP
Python
Python Tutorial
Python Open Source
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
Flash / Flex / ActionScript
VBA / Excel / Access / Word
XML
XML Tutorial
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
Java Tutorial » Database » Oracle 
20. 35. 2. Create an Oracle Table to Store Java Types (Using Statement Objects)
// Create a VARRAY type
    stmt.execute("CREATE TYPE char_varray AS VARRAY(10) OF VARCHAR(20)");

    // Create an OBJECT type
    stmt.execute ("CREATE TYPE oracle_object AS OBJECT(column_string VARCHAR(128), column_integer INTEGER)");

    StringBuffer sql = new StringBuffer("CREATE TABLE oracle_all_types(");
    //                    Column Name          Oracle Type          Java Type
    sql.append("column_short         SMALLINT, ");          // short
    sql.append("column_int           INTEGER, ");           // int
    sql.append("column_float         REAL, ");              // float
    sql.append("column_double        DOUBLE PRECISION,");   // double
    sql.append("column_bigdecimal    DECIMAL(13,2), ");     // BigDecimal
    sql.append("column_string        VARCHAR2(254), ");     // String
    sql.append("column_charStream    LONG, ");          // CharacterStream
    sql.append("column_bytes         RAW(3000), ");     // byte[]

    sql.append("column_binarystream  RAW(2000), ");     // BinaryStream
    sql.append("column_timestamp     DATE, ");          // Timestamp
    sql.append("column_clob          CLOB, ");          // Clob
    sql.append("column_blob          BLOB, ");          // Blob
    sql.append("column_bfile         BFILE, ");         // oracle.sql.BFILE
    sql.append("column_array         char_varray, ");   // oracle.sql.ARRAY
    sql.append("column_object        oracle_object)")// oracle.sql.OBJECT

    stmt.executeUpdate(sql.toString());

//From Book: JDBC Recipes A Problem-Solution Approach

20. 35. Oracle
20. 35. 1. Connect with Oracle's JDBC Thin Driver
20. 35. 2. Create an Oracle Table to Store Java Types (Using Statement Objects)
20. 35. 3. Execute Method
20. 35. 4. Rollback a transaction
20. 35. 5. Creating an Oracle Table to Store Java Types
20. 35. 6. Creating a Stored Procedure or Function in an Oracle Database
20. 35. 7. Create procedure myprocin with an IN parameter named x.
20. 35. 8. Create procedure myprocout with an OUT parameter named x
20. 35. 9. Create procedure myprocinout with an IN/OUT parameter named x; x is an IN parameter and an OUT parameter
20. 35. 10. Create a function named myfunc which returns a VARCHAR value; the function has no parameter
20. 35. 11. Create a function named myfuncin which returns a VARCHAR value; the function has an IN parameter named x
20. 35. 12. Create a function named myfuncout which returns a VARCHAR value;
20. 35. 13. Create a function named myfuncinout that returns a VARCHAR value
20. 35. 14. Creating an OBJECT Type in an Oracle Database
20. 35. 15. Inserting an OBJECT Value into an Oracle Table
20. 35. 16. Get list of stored procedure names
20. 35. 17. Store and retrieve an object from a table
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.