Whenever i create a table by using "Create suitable Table", i get the table created with the column names in double quotes.
CREATE TABLE "TEST"."IC_RFR_TEST_PHASE41" (
"REVENUE" DECIMAL(31 , 3))
So when i try to select columns using select query,
SELECT PRJ_ID FROM TEST.IC_RFR_TEST_PHASE41
It doesnt work. i have to give like
SELECT "PRJ_ID" FROM TEST.IC_RFR_TEST_PHASE41.
Is there any way to avoid this????
While the columns are renamed, i dont get this problem.
This topic has been locked.
1 reply Latest Post - 2012-10-09T07:47:56Z by SystemAdmin
Pinned topic Column Name with "
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-10-09T07:47:56Z at 2012-10-09T07:47:56Z by SystemAdmin
SystemAdmin 110000D4XK203 PostsACCEPTED ANSWER
Re: Column Name with "2012-10-09T07:47:56Z in response to sqwnbHi,
I guess it's because the output column names were somehow surrounded by "". Then when you perform <create suitable table>, the "" will be kept and thought as part of the column name.
If you want to avoid this situation, please check the output column names of the operator where you performed <create suitable table> action.