varray
How to use SQL 'IN' (or 'ANY') operator with VARRAY in PL/SQL
My .NET code is currently using ODP.NET to call a stored procedure many times to operate on various rows in many tables.The .NET code has an array of the rows to change.Only one parameter changes in e[详细]
2023-03-20 10:54 分类:问答Retrieving a 2d varray in Java with JDBC
I have the following types: create or replace TYPE mytimestamp AS VARRAY(300) OF TIMESTAMP(6); create or replace TYPE trade_history_dts_array AS VARRAY(300) OFmytimestamp;[详细]
2023-03-10 01:49 分类:问答Oracle PL/SQL: How to DEREF from a VARRAY of REFs?
I\'m new to Oracle Objects and I have a problem. I don\'t know how to dereference an item from a VARRAY of REFs. Below is some source code that reproduces the problem that I have.[详细]
2023-03-02 13:36 分类:问答How to initialize a varray table of {TABLE}%ROWTYPE?
I have a varray defined like: declare TYPE tnr_l IS VARRAY(30) of lve%ROWTYPE; I want this varray to be initialized with a fetch from the database:[详细]
2023-01-24 03:45 分类:问答How does Oracle VARRAY represent data in Java terms?
Slightly broad question here, but here goes I\'m trying to call an Oracle stored procedure, which returns a VARRAY which is of constructed from a ROWTYPE on one of my tables. For simplicity, lets say[详细]
2023-01-21 03:11 分类:问答How to deal with VARRAYs (Oracle 9i) in JDBC?
I am trying to write a small program which has to store and retrieve values from database. The database is object relational.[详细]
2022-12-13 10:28 分类:问答Can I slice a PL/SQL collection?
I\'ve got a PL/SQL VArray that I\'m filling with a BULK COLLECT query like this: SE开发者_运维技巧LECT id[详细]
2022-12-10 13:03 分类:问答