第一范文网 - 专业文章范例文档资料分享平台

Oracle9i笔记1(6)

来源:用户分享 时间:2021-06-02 本文由旧人不归 分享 下载这篇文档 手机版
说明:文章内容仅供预览,部分内容可能不全,需要完整文档或者需要复制内容,请下载word后使用。下载word有问题请添加微信号:xxxxxx或QQ:xxxxxx 处理(尽可能给您提供完整文档),感谢您的支持与谅解。

TIMESTAMP WITH TIME ZONE

TIMESTAMP WITH LOCAL TIME ZONE : This data type differs from TIMESTAMP WITH TIME

ZONE in that when you insert a value into a database column, the values is normalized to the database time zone, and the time-zone displacements is not stored in the column. When you retrieve the value, Oracle returns the value in your local session time zone. INTERVAL YEAR TO MONTH : INTERVAL YEAR[(precision1)] TO MONTH

INTERVAL DAY TO SECOND : INTERVAL DAY[(precision1)] TO SECOND[(precesion2)]. Where

precision1 and precision2 specify the number of digits in the days field and seconds field, respectively. In both cases, you cannot use a symbolic constant or variable to specify the precision; you must use an integer literal in the range 0..9. the defaults are 2 and 6, respectively.

Scalar Variable Declarations

The type %Attribute.

For example: v_v0 table_name%rowtype; v_v1 table_name.colname%type; V_balance number(7,2);

V_min_balance v_balance%type :=10;

A NOT NULL database column constraint does not apply to variables that are declared using %type. Therefore, if you declare a variable using the %TYPE attribute that uses a database column defined as NOT NULL, you can assign the NULL value to the variable.

Declaring Boolean variables

Composite Data Types

Composite data types(also known as collections) are of TABLE,RECORD,NESTED TABLE, and VARRAY types. Use the RECORD data type to treat related but dissimilar data as a logical unit. Use the TABLE data type to reference and manipulate collections of data as whole object. Both RECORD and TABLE data types are covered in detail in a subsequent lesson. NESTED TABLE and VARRAY data types are covered in the Advanced PL/SQL course. 復合數據類型,也被稱作集合。主要包括:表,記錄,嵌入表和數組。 記錄用來處理不同但組合到一起的數據。

表 用來把一個數據集合作為一個整體引用和操作。

記錄和表類型,下面的章節將詳細介紹。嵌入表和數組要看更深一步的 PL/SQL 課程。 For more information, see PL/SQL User’s Gride and reference,”Collections and records.”

LOB Data Type variables Book (CLOB) Photo (BLOB) Movie (BFILE) NCLOB

搜索“diyifanwen.net”或“第一范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读,第一范文网,提供最新人文社科Oracle9i笔记1(6)全文阅读和word下载服务。

Oracle9i笔记1(6).doc 将本文的Word文档下载到电脑,方便复制、编辑、收藏和打印
本文链接:https://www.diyifanwen.net/wenku/1197545.html(转载请注明文章来源)
热门推荐
Copyright © 2018-2022 第一范文网 版权所有 免责声明 | 联系我们
声明 :本网站尊重并保护知识产权,根据《信息网络传播权保护条例》,如果我们转载的作品侵犯了您的权利,请在一个月内通知我们,我们会及时删除。
客服QQ:xxxxxx 邮箱:xxxxxx@qq.com
渝ICP备2023013149号
Top