So even though we did not have XML in the database, we used SQL to create an XML view to the relational data for our application.
所以,即使数据库中没有XML,仍然可以用SQL创建关系数据的 XML视图。
When you create an SQL script through a connection in the data Source Explorer view, the script is connected to the associated database.
当您在DataSourceExplorer视图中通过连接创建一个sql脚本时,这个脚本是与相应数据库连接的。
When you create a new view in a DB2-enabled database, a new selection condition is present, called By SQL Query.
当在启用了DB2的数据库中创建一个新视图时,将出现一个新的选择条件,称作BySQL Query。
For this example, we create a Query view called New SQL view.
在本示例中,创建了一个称作newSQL view的查询视图。
Create a view based on SQL capabilities on Domino data.
基于SQL功能在Domino数据上创建视图。
We may use SQL to create queries to specify only a selected set of records and fields to view.
我们可以使用SQL来创建查询语句,让它仅对具有指定属性的记录和字段进行查找。
SQL> create materialized view log on t;
实体化视图日志已创建。
SQL> create materialized view log on fact with rowid, sequence (aid, num);
实体化视图日志已创建。
SQL> create materialized view log on dim_a with row id;
实体化视图日志已创建。
SQL> create materialized view log on dim_a with row id;
实体化视图日志已创建。
应用推荐