oracle中dual缩写是什么?
发布网友
发布时间:2022-05-02 00:56
我来回答
共2个回答
热心网友
时间:2022-05-03 03:12
al本身就是一个单词,并非是某个词组的缩写.名词意为对数,形容词为双重的意思.在Oracle中al指al table,一个单行单列的虚拟表.
1: DUAL table-- a special kind of one-row and one-column database table;
2:al is a table which is created by oracle along with the data dictionary. It consists of exactly one column whose name is mmy and one record. The value of that record is X.
3:Note that the outer query references the mmy table called al the al table is used in Oracle when you need to run SQL that does not logically have a table name.
参考资料:http://www.dba-oracle.com/sql/t_al_table.htm
热心网友
时间:2022-05-03 04:30
lfal