这里面包含了一百多个JAVA源文件

源代码在线查看: e304. getting a varray value from an oracle table.txt

软件大小: 551 K
上传用户: maple_78
关键词: JAVA
下载地址: 免注册下载 普通下载 VIP

相关代码

				This example retrieves values contained in an Oracle VARRAY type. The example uses the table and array type created in e301 Creating a VARRAY Type in an Oracle Database. 
				    try {
				        // Create a statement
				        Statement stmt = connection.createStatement();
				    
				        // Select rows from varray_table
				        ResultSet resultSet = stmt.executeQuery("SELECT * FROM varray_table");
				    
				        // Get the VARRAY values from each row
				        while (resultSet.next()) {
				            // Get the VARRAY value in the first column
				            oracle.sql.ARRAY array = ((oracle.jdbc.driver.OracleResultSet)resultSet).getARRAY(1);
				    
				            // Get the VARRAY elements; values.length is the number of values in the VARRAY
				            java.math.BigDecimal[] values = (java.math.BigDecimal[])array.getArray();
				        }
				    } catch (SQLException e) {
				    }
				
							

相关资源