Oracle SQL查询中的方括号是什么意思? [英] What means square brackets in Oracle SQL query?

问题描述

我发现带有方括号的select语句.有人可以解释一下这个括号的意思吗?

I find select statement with square brackets in it. Can anybody explain what does this brackets means?

例如

select a,b,[c] from table1;

谢谢.

推荐答案

根据oracle的文档:

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.

这篇关于Oracle SQL查询中的方括号是什么意思?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！