本文对比了HGDB和Oracle数据库中的dual对象。在Oracle中，dual是一个系统表，可以用于插入和查询。而在HGDB中，dual表现为一个视图，不允许插入操作，因为它是非物化的，不源自单表或单视图。
Oracle dual对象是表：
SQL> select owner,OBJECT_TYPE from dba_objects where OBJECT_NAME = 'DUAL';
OWNER OBJECT_TYPE
------------------------------ -------------------
SYS TABLE
PUBLIC SYNONYM
SQL> insert into dual values ('a');
1 row created.
SQL> /
1 row created.
SQL> /
1 row created.
SQL> /
1 row created.
SQL> /
1 row created.
SQL> commit;
Commit complete.
SQL> select * from dual;
D
-
X
==============================================&
SQL> select owner,OBJECT_TYPE from dba_objects where OBJECT_NAME = 'DUAL';
OWNER OBJECT_TYPE
------------------------------ -------------------
SYS TABLE
PUBLIC SYNONYM
SQL> insert into dual values ('a');
1 row created.
SQL> /
1 row created.
SQL> /
1 row created.
SQL> /
1 row created.
SQL> /
1 row created.
SQL> commit;
Commit complete.
SQL> select * from dual;
D
-
X
==============================================&
最低0.47元/天 解锁文章
扫一扫
6591
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
