] [mailto:[EMAIL PROTECTED]
Sent: Monday, July 31, 2006 11:17 AM
To: CF-Talk
Subject: RE: Oracle 8.i and querying for table/field list
It's guaranteed to bring back 0 records, giving you just the query columns.
By the way, if that's your real username and password, you should probably
c
This is one I used awhile back and gives you information on what the columns
are as well.
SELECT TNAME, CNAME, COLTYPE, WIDTH, NULLS, DEFAULTVAL, SCALE FROM COL ORDER
BY TNAME
On 7/31/06, Deanna Schneider <[EMAIL PROTECTED]> wrote:
>
> Um, why not use the data dictionary to get the columns as we
Um, why not use the data dictionary to get the columns as well as the tables:
select o.object_name, c.column_name, c.data_type
from user_objects o, user_tab_columns c
WHERE o.object_name = c.table_name
Order by object_name
On 7/31/06, Terry C. Mergl <[EMAIL PROTECTED]> wrote:
nt: Monday, July 31, 2006 11:08 AM
To: CF-Talk
Subject: RE: Oracle 8.i and querying for table/field list
James, not sure what to say but that did it.
It listed all of the tables and fiellds and fast also.
I appreciate it very very much.
Terry
PS: Why WHERE 0=1 though?
-Original Message-
F
you.
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Monday, July 31, 2006 10:59 AM
To: CF-Talk
Subject: Re: Oracle 8.i and querying for table/field list
Try this
Select * From #i#
WHERE 0=1
Yes, I did type that correctly. The fieldnames
nintended recipient, please delete this information from your computer and
> contact Darien Telephone Co., immediately by replying to this message or by
> sending e-mail to [EMAIL PROTECTED] Thank you.
>
> -Original Message-
> From: Tom Chiverton [mailto:[EMAIL PROTECTED]
> S
t: Re: Oracle 8.i and querying for table/field list
On Monday 31 July 2006 15:31, Terry C. Mergl wrote:
>name="findfields">
> Select * From #i#
>
One of the tables is huge. Try count(*) instead.
--
Tom Chiverton
., immediately by replying to this message or by
sending e-mail to [EMAIL PROTECTED] Thank you.
-Original Message-
From: Mingo Hagen [mailto:[EMAIL PROTECTED]
Sent: Monday, July 31, 2006 10:41 AM
To: CF-Talk
Subject: Re: Oracle 8.i and querying for table/field list
Is it possible you just have too
On Monday 31 July 2006 15:31, Terry C. Mergl wrote:
>name="findfields">
> Select * From #i#
>
One of the tables is huge. Try count(*) instead.
--
Tom Chiverton
This email is sent for and on behalf of Halliwells LLP.
Ha
Is it possible you just have too many tables for CF to query in the
timeout given? If so, you might want to up the timeout using:
where XXX = time in seconds.
Mingo.
Terry C. Mergl wrote:
> Hi James: here is what I have.
OT: the error reporting is a great feature! thanks Michael ;)
~~~
t; review, disclosure, use or distribution is prohibited. If you are an
> unintended recipient, please delete this information from your computer and
> contact Darien Telephone Co., immediately by replying to this message or by
> sending e-mail to [EMAIL PROTECTED] Thank you.
>
> -----O
computer and
contact Darien Telephone Co., immediately by replying to this message or by
sending e-mail to [EMAIL PROTECTED] Thank you.
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Monday, July 31, 2006 10:27 AM
To: CF-Talk
Subject: Re: Oracle 8.i and querying for t
Can you post the SQL you are using to list the fields?
On 7/31/06, Terry C. Mergl <[EMAIL PROTECTED]> wrote:
> Good morning everyone.
> As a novice with CF and newly introduced to one of our Oracle servers, I'm
> having to rely on a cf query to find the tables and fields that way.
> I can successf
Good morning everyone.
As a novice with CF and newly introduced to one of our Oracle servers, I'm
having to rely on a cf query to find the tables and fields that way.
I can successfully run a query and list all of my tables, but when I go one
step further to list the fields, it is either timing ou
14 matches
Mail list logo