`
Vasile
  • 浏览: 38563 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

select clause and i_is_deleted

UP 
阅读更多
1.select clause:SELECT [ALL|DISTINCT] columns

The optional ALL and DISTINCT keywords determine whether the SELECT statement returns duplicate rows. ALL returns all rows, including any duplicates. DISTINCT does not return duplicate rows. If neither keyword is included, the default is determined by the server’s default behavior. (The server’s default behavior is determined by the distinct_query_results flag in the server’s server.ini start‑up file.)
The DISTINCT keyword is ignored if the SELECT statement also includes an IN DOCUMENT or IN ASSEMBLY clause. The server issues a warning if the statement includes both the DISTINCT keyword and an IN DOCUMENT or IN ASSEMBLY clause.
The warning is also issued if the server’s default setting is not to return duplicates and the query contains an IN DOCUMENT or IN ASSEMBLY clause.

2.select clause: from type_name [(ALL)|(DELETED)|(LITE)]

The keyword ALL directs the server to search all versions of each object. The keyword DELETED directs the server to search all versions of each object including any versions for which i_is_deleted is set to TRUE. (This property is set to TRUE if you delete the object and it is the root version of a version tree). The keyword LITE directs the server to search only the properties in the lightweight type, otherwise the server also searches the properties in the shareable parent and the supertype(s). If you specify LITE, then you must only specify properties in the lightweight type. You must enclose ALL, DELETED, and LITE in parentheses.
If the FROM clause includes neither ALL nor DELETED, the server searches only the CURRENT version.

3.If the object is the root version of a version tree, deleting the object sets this property to TRUE.
分享到:
评论

相关推荐

    微软内部资料-SQL性能优化3

    Another type of table lock is a schema stability lock (Sch-S) and is compatible with all table locks except the schema modification lock (Sch-M). The schema modification lock (Sch-M) is incompatible ...

    Recover4all Professional

    If You agree to be bound by all the terms of this license agreement, please select "I accept the License Agreement" below and then click the "Start" button. If You do not agree to this license ...

    PLSQL.Developer(X32) v12.0.1.1814主程序+ v11中文包+keygen

    You can use the editor preferences to configure when and how items are added to and deleted from the PL/SQL Clipboard. Debugger Enhancements You can now display compound variable values such as user-...

    plsqldev12.0.6.1832x32主程序+ v12中文包+keygen

    You can use the editor preferences to configure when and how items are added to and deleted from the PL/SQL Clipboard. Debugger Enhancements You can now display compound variable values such as user...

    plsqldev12.0.6.1832x64主程序+ v12中文包+keygen

    You can use the editor preferences to configure when and how items are added to and deleted from the PL/SQL Clipboard. Debugger Enhancements You can now display compound variable values such as user...

    plsqldev12.0.4.1826x32主程序+ v12中文包+keygen

    You can use the editor preferences to configure when and how items are added to and deleted from the PL/SQL Clipboard. Debugger Enhancements You can now display compound variable values such as user...

    PLSQL.Developer(X64) v12.0.1.1814 主程序+ v11中文包+keygen

    You can use the editor preferences to configure when and how items are added to and deleted from the PL/SQL Clipboard. Debugger Enhancements You can now display compound variable values such as user-...

    plsqldev12.0.4.1826x64主程序+ v12中文包+keygen

    You can use the editor preferences to configure when and how items are added to and deleted from the PL/SQL Clipboard. Debugger Enhancements You can now display compound variable values such as user...

    oracle RETURNING 子句使用方法

    如果试图在非DML语句中使用RETURNING子句,如SELECT,会导致错误`ORA-06547: INSERT, UPDATE, or DELETE statement must use RETURNING clause`. 正确的做法是使用INTO子句来存储查询结果。 错误示例: ```sql ...

    Delphi7.1 Update

    not all of the features mentioned in this file are available inall editions of the product.This update resolves the following issues:IDE* Using the up/down arrow keys to navigate and select items from...

Global site tag (gtag.js) - Google Analytics