logs archiveIRC Archive / Freenode / #oracle / 2010 / March / 28 / 1
fitzgerald
hello everyone, i'd just installed oracle in ubuntu following the official guide. is there any GUI to operate? or we could only use browser? thx
mohit123
how to use join condition on multiple columns
only one join is done instead of two in join condion on multiple columns
deebo
can someone explain sys_refcursor?
im supposed to call a stored procedure to get a set of changes, the documentation says 'returns SYS_REFCURSOR' and im clueless :)
RJarett
the connection driver just references a cursor (a query thats been opened and result pointers just sitting around). that way you can do more complex things with the results of the cursor. like jump ahead or back through the results. or page through it
versus getting flooded with all data from the query at once in a nondescript format
thats the idiot definition of it
its also a structure to itself
but a refcursor doesnt even have to be associated w/ a query yet.
solar_sea
What's the best performance-wise way to change the size of a column that contains data ? (in a table with a really large number of rows)
with an appended column in the same table, a temp table, some system magic, etc ?
I add a column using execute immediate 'alter table .. add ..'; and then try to set some values to it in the same pl/sql block. I'm getting an ORA-00904 - invalid identifier. The column name is 'DBTMPCLMN', which I believe is valid. What is the issue here, do I need to somewhat commit the execute immediate changes after them ?
Here is an example - http://pastebin.com/ZNeSRLpX , I'm getting an invalid identifier for DIFFDBTMPCLMN on line 9
RJarett
thats some seriously ugly code
is this a 1 time thing or will you be doing it often?
solar_sea
it's a generated code for a database update
I know it might be a performance hit copying data on large tables, but as far as I get it it's the only way
RJarett
dbms_redefinition
solar_sea
(aside from creating a new table with proper column definitions or using dmbs_redefinition)
         

« prev next »