默认数据库语法为antdb
,如果想全局使用Oracle语法,则可以在服务器级别设置语法参数。
登录adbmgr,设置所有coordinator的grammar
参数:
antdb=# set coordinator all (grammar=oracle);
SET PARAM
antdb=# show cd1 grammar;
type | status | message
------------------------+--------+----------------------------------
coordinator master cd1 | t | debug_print_grammar = off +
| | grammar = oracle
(1 row)
连接Coordinator节点,登录数据库,查看语法参数,并执行Oracle语法语句:
adb (4.0.0 based on PG 10.7)
Type "help" for help.
antdb=# show grammar ;
grammar
---------
oracle
(1 row)
antdb=# select * from dual;
DUMMY
-------
X
(1 row)