Ishikawa Yoshi Ishikawa Yoshi - 1 year ago 109
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?


select a,b,[c] from table1;


Answer Source

According to oracle's documentation:

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download