Geek asks and answers

What does square brackets mean in an Oracle SQL query?

I find in it a select statement with square brackets. Can someone explain what these brackets mean?

eg.

select a,b,[c] from table1;

Thank.

+5
source share
4 answers

According to oracle documentation: http://docs.oracle.com/cd/B10500_01/text.920/a96518/cqspcl.htm

The parenthesis characters are used to group terms and operators found between characters; however, they prevent penetration for extension operators (fuzzy, sonic, stem).

Its grouping symbol in the request.

+1
source

This is not valid Oracle SQL and PL / SQL.

+1
source

Oracle SQL MODEL. :

select *
from dual
model
    dimension by (0 the_dimension)
    measures (0 the_measure)
    rules iterate(5)
    (
        the_measure[iteration_number] = iteration_number
    );

THE_DIMENSION   THE_MEASURE
-------------   -----------
0               0
1               1
2               2
3               3
4               4

, Oracle - . Oracle:

select a,b,[c] from table1;

, Oracle. , . JSON, Text, XML - Oracle, , .

0

, ,

select * from [Department Managers]

, [], SQL Server , , , , ,

Select [From],[To] from tbl

.

-2

More articles:


All Articles