What means square brackets in Oracle SQL query?
13,460
Solution 1
According to oracle's documentation: http://docs.oracle.com/cd/B10500_01/text.920/a96518/cqspcl.htm
The bracket characters serve to group terms and operators found between the characters; however, they prevent penetrations for the expansion operators (fuzzy, soundex, stem).
Its a grouping character in the query.
Solution 2
This is not a valid Oracle SQL nor PL/SQL.
Author by
Ishikawa Yoshi
java developer python fanatic C/C++ beginer skype:ishikawa__yoshi
Updated on June 07, 2022Comments
-
Ishikawa Yoshi almost 2 years
I find select statement with square brackets in it. Can anybody explain what does this brackets means?
e.g.
select a,b,[c] from table1;
Thanks.