Obtained from the oracle with a number of java

/ Bin / boot / dev / etc / home / lib / lost + found / media / misc / mnt / net / opt / proc / root / sbin / selinux / srv / sys / tmp / u01 / usr / var / vmware
drop table varray_table;
drop type num_varray;

CREATE TYPE num_varray AS VARRAY (10) OF VARCHAR2 (12)
/
CREATE TABLE varray_table (col1 num_varray);
INSERT INTO varray_table VALUES (num_varray (''Hello'',''abc''));

select backup bin conf config data eshow_sitemap.html generate.sh log maint sitemap.html svn tmp from varray_table;

backup / bin / conf / data / log / maint / svn / tmp /

import java.sql .*;
import java.math .*;
import oracle.jdbc.driver .*;
import oracle.sql .*;

class Array1
(

public static void main (String args []) throws Exception
(
int oracleId = CharacterSet.ZHS16GBK_CHARSET;
CharacterSet dbCharset = CharacterSet.make (oracleId);

DriverManager.registerDriver
(New oracle.jdbc.driver.OracleDriver ());

Connection conn =
DriverManager.getConnection
("Jdbc: oracle: thin: @ 10.9.200.58:1521: db01",
"Mytest",
"Mytest");

Statement stmt = conn.createStatement ();

ResultSet rs = stmt.executeQuery ("SELECT backup bin conf config data eshow_sitemap.html generate.sh log maint sitemap.html svn tmp FROM varray_table");

while (rs.next ()) (
ARRAY my_array = ((OracleResultSet) rs). GetARRAY (1);

/ / Return the SQL type names, integer codes,
/ / And lengths of the columns
System.out.println ("Array is of type" + my_array.getSQLTypeName ());
System.out.println ("Array element is of typecode" + my_array.getBaseType ());
System.out.println ("Array is of length" + my_array.length ());

/ / Get Array elements
String [] values = (String []) my_array.getArray ();
for (int i = 0; i (
oracle.sql.CHAR out_value = new oracle.sql.CHAR (values [i], dbCharset);
System.out.println (">> index" + i + "=" + out_value);
)


)

rs.close ();
stmt.close ();
conn.close ();
)
)