Ishikawa Yoshi Ishikawa Yoshi - 6 months ago 23
SQL Question

What means square brackets in Oracle SQL query?

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.

Answer

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.