- 1、本文档共26页,可阅读全部内容。
- 2、原创力文档(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
- 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载。
- 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
查看更多
PL-SQL Introduction -2 PLSQL Fundamentals课件
PL/SQL Fundamentals; Variables
A variable is simply a location in memory where
you can store data of different types.
Variables can be read or set during execution of a PL/SQL block, values from the database can be stored in variables as can literals and values of other variables. All variables must be declared before they can be used. The declaration of a variable specifies the type and size of the data that the variable will hold.; Different types of variable within PL/SQL
Data type Max Size Default Size Description
NUMBER
(width,scale) 38 38 Numeric values rounded to a whole number unless a scale is given, i.e. NUMBER(5,2) means a numeric values 5 digits in length allowing for 2 decimal placesVARCHAR2
(width) 32767 Variable length character dataCHAR
(width) 32767 Fixed length character dataDATE Valid date valuesBOOLEAN Boolean values TRUE and FALSE
; Variables – Declaration
All declarations must appear in the DECLARE
section of your block. Variable declaration has the following
syntax:-
varname TYPE [CONSTANT] [NOT NULL] [:= value];
where varname is the name of the variable, the CONSTANT keyword specifies this variable as a constant (Fixed value), the NOT NULL keyword ensures the value can never be NULL and the final part is a default value;; some examples:-
DECLARE v_anumber1 NUMBER(10); v_anumber2 NUMBER := 100; v_astring VARCHAR2(1) NOT NULL := Y;
All the above are valid declarations. The following is invalid,
v_a_string VARCHAR2(1) NOT NULL;
because the variable is NOT NULL and no default value
has been given. The DEFAULT keyword can also b
您可能关注的文档
- Part 5.unit7课件.ppt
- Parallel Graph Algorithms课件.ppt
- Part I -Literature of Colonial America课件.ppt
- Part 5大学英语课程课件.ppt
- Part 5unit4课件.ppt
- Part 6 同义词、反义词课件.ppt
- part I 3 positive analysis课件.ppt
- Part IIA, Paper 1Consumer and Producer Theory课件.ppt
- Part I The colonial American Literature课件.ppt
- Parker_Vansco_Overview_2008-10-07课件.ppt
最近下载
- 2023年流域数字孪生平台解决方案.docx
- 建筑设备工程四版建工社高明远等10章 供暖及供燃气.ppt
- 中国中信集团有限公司招聘笔试题库2024.pdf
- 第27课 改革开放与建设中国特色社会主义 (3).pptx
- COM Express Module Base Specification_R3.0 COM Express模块基本规范_R3。0.doc
- 2023年宁波市海曙外国语学校小升初语文模拟试卷及答案解析.pdf
- 火电工程设计审查管理规定.pdf VIP
- CQI-23注塑过程审核查检表(中英文)Molding System Assessment(... (中英对照).xlsx VIP
- 化学水处理工技能鉴定笔试题库.pdf VIP
- 黑布林阅读初二16《绿山墙的安妮——安妮到来》中文版.pdf
文档评论(0)