Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: indirect SQL execution - kind of 'backquoting'

Re: indirect SQL execution - kind of 'backquoting'

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Thu, 22 Jul 2004 19:46:05 +0200
Message-ID: <c9vvf0pgm0ko3ejm89u2798f1tte96rec8@4ax.com>


On Thu, 22 Jul 2004 17:56:47 +0200, Holger Baer <holger.baer_at_science-computing.de> wrote:

>Sorry Sybrand, but that won't work since when querying DBA_TABLES you're
>most likely *not* 'SOMEONE', so you'll have to preceede the table name
>with the owner. Or set the current schema with alter session

It shouldn't be too difficult for the OP to add that. At least it is a lot easier than grepping through an ascii file.

--
Sybrand Bakker, Senior Oracle DBA
Received on Thu Jul 22 2004 - 12:46:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US