Selecting attribute with square brackets in name
Posted by:
D B
Date: June 07, 2018 08:30AM
Hello,
I'm trying to do a simple SELECT FROM statement (not so simple for me I guess) but I'm having trouble because the field name I'm trying to call has square brackets in its name. The field is called:
price[1]
My code is:
SELECT STStockDetails_0.price[1]
FROM Forge.STStockDetails STStockDetails_0
Because of the square brackets it is returning a syntax error.
How can I get around this?
Thank you.
Subject
Written By
Posted
Selecting attribute with square brackets in name
June 07, 2018 08:30AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.