Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Strange column names
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
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
![]() |
![]() |