Topic
1 reply Latest Post - ‏2012-10-09T07:47:56Z by SystemAdmin
sqwnb
sqwnb
11 Posts
ACCEPTED ANSWER

Pinned topic Column Name with "

‏2012-10-08T09:13:52Z |
HI,

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" (
"PRJ_ID" VARCHAR(20),
"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.

please help.
Updated on 2012-10-09T07:47:56Z at 2012-10-09T07:47:56Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    203 Posts
    ACCEPTED ANSWER

    Re: Column Name with "

    ‏2012-10-09T07:47:56Z  in response to sqwnb
    Hi,

    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.

    Thanks,
    Wei.