Hi All,
Db_Amount{3}
In a table i have a column called Db_Amount{3} array 3 .It have the value of {100, 200, 300)
I mean the aomunt may be in array{1}, {2} , {3} for the column Db_Amount.
I want to populate this column to target file with addition of the arry values. I mean I need the below output.
Input:Db_Amount{3} array 3 .It have the value of {100, 200, 300)
Out put: Db_Amount=600
This conversation is saved in the Conversations tab in Lync and in the Conversation History folder in Outlook.
How to extract the array of column data to target file ?
Moderators: chulett, rschirm, roy
It may be in an array? Or is?
Also curious what actual database this is and the internal data type. I would imagine that it (the actual database) provides functions for dealing with this 'array' but hard to say without the requested details.
Is "this conversation" actually part of your question / requirements? This is somehow related to the Microsoft Lync enterprise communications software... as in this is your source?
"This conversation is saved in the Conversations tab in Lync and in the Conversation History folder in Outlook."
Also curious what actual database this is and the internal data type. I would imagine that it (the actual database) provides functions for dealing with this 'array' but hard to say without the requested details.
Is "this conversation" actually part of your question / requirements? This is somehow related to the Microsoft Lync enterprise communications software... as in this is your source?
"This conversation is saved in the Conversations tab in Lync and in the Conversation History folder in Outlook."
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Well, one question answered.
What data type is this field in Oracle? A VARRAY? Post the actual column definition, please. If it is, you can't simply 'drag it to the target', you'll need to process it using PL/SQL via (one suggestion) a stored function so you can 'select' the summed value from the field.
(edited to add)
FYI - there are plenty of code examples out there in the wild showing how to work with the various collection methods you'll need that Oracle provides.
What data type is this field in Oracle? A VARRAY? Post the actual column definition, please. If it is, you can't simply 'drag it to the target', you'll need to process it using PL/SQL via (one suggestion) a stored function so you can 'select' the summed value from the field.
(edited to add)
FYI - there are plenty of code examples out there in the wild showing how to work with the various collection methods you'll need that Oracle provides.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
It cannot be a simple NUMBER. Is this actually a TABLE OF / INDEXED BY data type? Regardless, unless it's just numbers stored in a delimited string field you'll have to do the extraction of the components in the database.
And I have to ask - any particular reason you put a "{" on the left side and a ")" on the right?
And I have to ask - any particular reason you put a "{" on the left side and a ")" on the right?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers