var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have a collection defined as below-
TYPE C_TYPE AS OBJECT
CREATE OR REPLACE
TYPE c_list As table of C_TYPE ;
And a function in which the above collection is passed as a parameter
FUNCTION f1(cpc_tab c_list) RETURN VARCHAR2 IS
pla pla pla
the question is :
after I fill the table of C_TYPE and send it to the function, IS it necessary for Flash the table or delete the rows inside it (for performance issue) ?
thanx in advance
Well, the table will consume memory until the data is deleted or until the program that created it ends, so if it is big and will contiue to exist for some time after it is no longer useful then deleting the data from it makes sense.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors