StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>BLOB (Binary Large Objects ) and CLOB(Character large objects) are special datatypes and can hold the large chunks of data in form of objects or text. Blob and Clob objects persist the data of the objects into the database as a stream.</p> <p>An example piece of code:</p> <pre><code>public class TestDB { public static void main(String[] args) { try { /** Loading the driver */ Class.forName("com.oracle.jdbc.Driver"); /** Getting Connection */ Connection con = DriverManager.getConnection("Driver URL","test","test"); PreparedStatement pstmt = con.prepareStatement("insert into Emp(id,name,description)values(?,?,?)"); pstmt.setInt(1,5); pstmt.setString(2,"Das"); // Create a big CLOB value...AND inserting as a CLOB StringBuffer sb = new StringBuffer(400000); sb.append("This is the Example of CLOB .."); String clobValue = sb.toString(); pstmt.setString(3, clobValue); int i = pstmt.executeUpdate(); System.out.println("Done Inserted"); pstmt.close(); con.close(); // Retrive CLOB values Connection con = DriverManager.getConnection("Driver URL","test","test"); PreparedStatement pstmt = con.prepareStatement("select * from Emp where id=5"); ResultSet rs = pstmt.executeQuery(); Reader instream = null; int chunkSize; if (rs.next()) { String name = rs.getString("name"); java.sql.Clob clob = result.getClob("description") StringBuffer sb1 = new StringBuffer(); chunkSize = ((oracle.sql.CLOB)clob).getChunkSize(); instream = clob.getCharacterStream(); BufferedReader in = new BufferedReader(instream); String line = null; while ((line = in.readLine()) != null) { sb1.append(line); } if (in != null) { in.close(); } // this is the clob data converted into string String clobdata = sb1.toString(); } } catch (Exception e) { e.printStackTrace(); } } } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload