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 -> Strange column names

Strange column names

From: Ford Desperado <ford_desperado_at_yahoo.com>
Date: 6 May 2005 15:54:29 -0700
Message-ID: <1115420069.802482.294160@g14g2000cwa.googlegroups.com>


Oracle 9IR2
I have created a table, and if I explore it via Toad, it looks good.

However, I'm getting strange results from all_tab_columns:

SELECT COLUMN_NAME FROM ALL_TAB_COLS
WHERE TABLE_NAME ='SOME_TABLE'
AND OWNER = 'SOME_OWNER'
AND COLUMN_NAME LIKE '%:%'
ORDER BY COLUMN_ID
COLUMN_NAME



SYS_C00002_05050610:14:15$
SYS_C00010_05050610:14:15$
2 rows selected

these 2 columns are not in my script, and I do not see them if I run

select * from some_owner.some_table

nor I can see them via Toad
What's that?

TIA Received on Fri May 06 2005 - 17:54:29 CDT

Original text of this message

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