, 31-Dec-2002,P0100, 8.80
where the pnumber column is the column name in the table
Is there anyway to get this without using a whole bunch of unions
Cheers
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical Consultant
, p0030, p0100, p0130, p0200,
p0230, p0300, p0330,
I need to do a query that does the following output
CurveId ,CurveDate, PNumber, PReading
206116, 31-Dec-2002, P0030, 26.18
206116, 31-Dec-2002,P0100, 8.80
where the pnumber column is the column name
Hi listers,
Can someone tell me how to get column's name using
cursor.
Thanks in advance,
Kader
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ:
Hi All,
Oracle 8.1.6, WinNT
I have view TIMEVIEW. I can do select * from timeview with no errors. If
I select a individual column I get 904 error.
I am doing everything from the schema owner.
Any hints
SQLWKS desc timeview
Column NameNull?Type
Title: RE: ora-904 invalid column name
Taking a Deep Breath ...
Are any columns in this view user defined functions ??
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here
doing everything from the schema owner.
Any hints
SQLWKS desc timeview
Column NameNull?Type
--
NAS_IP_ADDRESS NOT NULL VARCHAR2(255)
CALLED_STATION_ID VARCHAR2(255)
CALLING_STATION_ID
Title: RE: ora-904 invalid column name
try with quotes
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of [EMAIL PROTECTED]
Sent: Friday, October 04, 2002 4:06 PM
To: Multiple recipients of list ORACLE-L
Subject: ora-904 invalid column name
Hi All,
Oracle
Title: RE: ora-904 invalid column name
Rick,
I ask because in 8161 there is an internal bug that sometimes communicates (with users) by displaying ora-904 error. This happens when you have a user defined function and you are selecting from that user defined function AND you have privileges
Message-
Sent: Wednesday, August 21, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
Hi,
One of our clients has created a table with column name access
since access is reserved word , they use double quotes.
but when i query the table user_tab_columns it is still showing column name
Hi,
One of our clients has created a table with column name access
since access is reserved word , they use double quotes.
but when i query the table user_tab_columns it is still showing column name as access
and not access
how can we know that this table is created with column
-
Sent: Wednesday, August 21, 2002 9:59 PM
To: Multiple recipients of list ORACLE-L
Hi,
One of our clients has created a table with column name access
since access is reserved word , they use double quotes.
but when i query the table user_tab_columns it is still showing column name
never did anyone any good.
Regards,
Mike Hately
Oracle DBA
-Original Message-
Sent: Wednesday, August 21, 2002 9:59 PM
To: Multiple recipients of list ORACLE-L
Hi,
One of our clients has created a table with column name access
since access is reserved word , they use double quotes
how can we know that this table is created with column name
When the column name is a reserved word, or appears with lower
case characters.
Jared
Harvinder Singh [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/21/2002 09:28 AM
Please respond to ORACLE-L
To: Multiple
with column name
When the column name is a reserved word, or appears with lower
case characters.
Jared
Harvinder Singh [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/21/2002 09:28 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED
: double quotes column name
I guess this is not the case.
1. create table t(TABLE Varchar2(10));
2. select table_name,column_name from user_tab_columns where
table_name='T';
TABLE_NAME COLUMN_NAME
-- --
T
: invalid column name
EXP-0: Export terminated unsuccessfully
What the hell is going on? Is there a way to avoid this? If there is no way,
anyway I would like to know what is going on...
Thanks,
Vladimir Barac
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author
enterprise edition
install. Target db is 8.1.7.0 enterprise edition residing on WinNT.
This is what I get at the end of export log
. exporting job queues
EXP-8: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-0: Export terminated unsuccessfully
What the hell is going
Title: RE: ORA-00904 invalid column name and export
Vladimir...
I'd suggest starting the export on the target, the 8.1.7.0 installation.
HTH,
Rich
-Original Message-
From: Vladimir Barac - posao [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 16, 2002 8:08 AM
To: Multiple
Title: RE: ORA-00904 invalid column name and export
1. No enough space for
exports...
2. All exports are on some large drive
(linux box) from where exports go to the tape...
3. No f!$^% decent shell scripting
available on NT...
- Original Message -
From:
Richard Huntley
Title: RE: ORA-00904 invalid column name and export
Have
you tried the earlier suggestion that I missed (that should do it)? That
is to rerun catexp.sql on the source DB.
Also,
if you have access to Metalink check out the following
article:
132904.1 Compatibility Matrix for Export Import
on
the Linux side.
Good luck!
Barb
--
From: Vladimir Barac - posao[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Tuesday, July 16, 2002 6:08 AM
To: Multiple recipients of list ORACLE-L
Subject: ORA-00904 invalid column name and export
Hi
is to write your own
parser.
Ian MacGregor
Stanforfd Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, April 11, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L
This won't work if I alias the column name in the
view definition, would it?
Raj
is to write your own parser.
Ian MacGregor
Stanforfd Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, April 11, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L
This won't work if I alias the column name in the view definition, would it?
Raj
xxx_DEPENDENCIES would probably be a better starting
point.
hth
connor
--- [EMAIL PROTECTED] wrote: Darn E-mail package.
Every once in a while I get a
message as I'm deleting one
or more I don't want one I do want goes as well.
Well, I guess that's
IBM/Lotus for you.
Anyway, someone
Darn E-mail package. Every once in a while I get a message as I'm deleting one
or more I don't want one I do want goes as well. Well, I guess that's
IBM/Lotus for you.
Anyway, someone asked how to find all the views that include a specific column.
Try the following:
select view_name
This won't work if I alias the column name in the view definition, would it?
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
List,
Is there any way to rename a column without changing the position of column?
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may
If you have 8i you can add new column name,populate with old column
data,drop old column.
Rick
-Original Message-
Sent: Tuesday, September 04, 2001 2:38 PM
To: Multiple recipients of list ORACLE-L
List,
Is there any way to rename a column without changing the position of column
the
recreated columns from the new table.
Jay Miller
-Original Message-
Sent: Tuesday, September 04, 2001 3:21 PM
To: Multiple recipients of list ORACLE-L
If you have 8i you can add new column name,populate with old column
data,drop old column.
Rick
-Original Message-
Sent
. They should list the column name and then position doesn't
matter.
ROR mª¿ªm
[EMAIL PROTECTED] 09/04/01 02:38PM
List,
Is there any way to rename a column without changing the position of column?
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
The information contained in this message and any
In the short term:
Rename XXX to YYY
create view XXX as select {all the columns} from YYY;
In the longer term - migrate to Oracle 9
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
In the unsupported short term there are scripts
around on the net for hacking COL$ and associated
dictionary objects...
Note: This is NOT an email advising you to do it.
--- Jonathan Lewis [EMAIL PROTECTED]
wrote:
In the short term:
Rename XXX to YYY
create view XXX as select
Hi,
We have a table in which one of column name and datatype is change from 1
version to next.
like earlier column name is status number, it is changed to tx_status
raw(16)...
when i try to import this table to new version from export dump of earlier
version
i am getting error
Are you saying the table you are importing to has a different column
name/datatype?
If so, I would add the old column to the table, import it, then create the
new column and use an update statement to move the data over. Then drop the
old column.
If the table isn't huge, you can load
what version of db, if on 8i u could do drop column and add it
back.
joe
[EMAIL PROTECTED] 08/08/01 02:30PM
Hi,We have a table in which one of column name and
datatype is change from 1version to next.like earlier column name is
status number, it is changed to tx_statusraw(16
are importing to has a different column
name/datatype?
If so, I would add the old column to the table, import it, then create the
new column and use an update statement to move the data over. Then drop the
old column.
If the table isn't huge, you can load it into a difference schema, then use
ctas syntax
Djaroud Salim wrote:
hi every body,
I'm on oracle 7.3.4 is it possible to mdify a column name ?
very urgent !!!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djaroud Salim
INET: [EMAIL PROTECTED]
No, unless you do morally questionable updates
Can anyone help?
I am attempting to load a table, using SQL*Loader, where the table has a
column named PARTITION. Partition is a SQL*Loader reserved word and the
load failed with: SQL*Loader-350 Expecting column name found partition.
If anyone has a solution or workaround for this gotcha, I'd
column name found partition.
If anyone has a solution or workaround for this gotcha, I'd like to know
what you have done.
Thanks very much.
Michael L. Petrus
GE Auto Warranty Services
7125 W. Jefferson Av. #200
Lakewood, CO 80235
Database Administrator
Phone: (303) 987 4129
Fax: (303) 987
Yes.The manual states that you can use SQLLDR control words as column
names if you enclose them in Double Quotes. If you do this you must
remember to make the column names in UPPER CASE. So, to use a column name
of PARTITION, say PARTITION.
-Original Message-
Sent: Tuesday, June 05
Try placing the column name within quotes. For example:
PARTITION POSITION (1) INTEGER EXTERNAL,
...
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org
Tuesday, June 05, 2001, 1:10:58 PM, you
attempting to load a table, using SQL*Loader, where the table has a
column named PARTITION. Partition is a SQL*Loader reserved word and the
load failed with: SQL*Loader-350 Expecting column name found partition.
If anyone has a solution or workaround for this gotcha, I'd like to know
what you have done
Can I use the same column name in the same database and in the same schema? Could this
cause me lots of trouble?
Roland Sköldblom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538
the same column name for more than one table in a
schema. In fact when using foreign keys it is almost advisable
John
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: 27 April 2001 11:01
To: Multiple
Yes you can use the same column name in a database and
in a schema. The only thing is that you have to
precede the field with the table name when you're
joining 2 tables containing columns with the same
name.
Let's open a can of worm.
There are 2 stands on this :
1. Something should have
the only concern is column ambiguity.
Precede the field with the table name when you're joining
tables.
Sunil Nookala
Dell Corp
Austin, TX
-Original Message-
Sent: Friday, April 27, 2001 5:00 AM
To: Multiple recipients of list ORACLE-L
Can I use the same column name in the same
The only duplication of column names that is not allowed in the same column name in
the same table in the same schema. The column name ename can be in any table you
create.
ROR mª¿ªm
[EMAIL PROTECTED] 04/27/01 06:00AM
Can I use the same column name in the same database and in the same schema
:
Can I use the same column name in the same database and in the
same schema? Could this cause me lots of trouble?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538
wrote:
Yes you can use the same column name in a database and
in a schema. The only thing is that you have to
precede the field with the table name when you're
joining 2 tables containing columns with the same
name.
Let's open a can of worm.
There are 2 stands on this :
1. Something should
49 matches
Mail list logo