Re: temporary tables

From: Rob Burton <burton.rob_at_gmail.com>
Date: Mon, 26 Jul 2010 01:50:06 -0700 (PDT)
Message-ID: <1f0229d2-4a8c-4f66-8cf4-3e91588a8d4e_at_u26g2000yqu.googlegroups.com>

On Jul 23, 2:52 pm, Francogrex <fra..._at_grex.org> wrote:
> I have access to a database as read-only (so, I cannot create tables,
> insert or update values etc)... But I need to search a col with type
> LONG and since this is not a possibility to search it in a when
> clause, they suggested I try to convert it to CLOB first. Is there a
> way that I create a "temporary table" (ex would reside only in PC
> memory or a local DB on my PC) that is not in the read-only database
> and do the work on that table (which will not commit anything and will
> disappear upon closing the session)?

Have you tried this approach (dbms_xmlgen.getxml) to let you search a long column

From: http://jes.blogs.shellprompt.net/2010/02/25/views-and-order-by/

"We can get round this in a number of ways (such as creating a copy of the DBA_VIEWS or USER_VIEWS in a local table converting the LONG column to a CLOB etc), or we can use a different approach like this - JES_at_dbtest> select

2.  *
3.  from
4.    user_views
5.  where
6.    dbms_xmlgen.getxml('select text from user_views where view_name

= ''' || view_name || '''') like '%ORDER BY%'

(note unfortunately I can’t remember who to credit with the DBMS_XMLGEN trick above, I saw it a long time ago and it’s been lost in the mists of time)." Received on Mon Jul 26 2010 - 03:50:06 CDT