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

Home -> Community -> Usenet -> c.d.o.misc -> Re: table name

Re: table name

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 2 Aug 2006 10:21:32 -0700
Message-ID: <1154539292.431441.194530@m79g2000cwm.googlegroups.com>


A table name is no different than any other character string value. You should be able to declare the variable as a varchar2(30). You will probably also want to include the schema name as another variable.
If you want more help, please post the Oracle version you intend to use.
For example, your approach using Oracle 10g, could be to use the datapump API procedures.

HTH Received on Wed Aug 02 2006 - 12:21:32 CDT

Original text of this message

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