oracle - plsql
shenghuiping2001
提供Splunk 安装升级技术支持,Splunk 字段截取,dashboard 报表制作。Splunk 接入各种网络设备和Add-on APP.(毕业于南京航空航天大学,在IBM工作过10年,现在专注splunk架构和数据分析。拥有Oracle: OCP认证, AWS: ASP认证, Azure: admin系统管理员认证。)
展开
-
11g 新特性之 plsql
This day I will introduce the 11G plsql:Step1: Let us create one sequence first: create sequence dept_seq start with 101; Now I had viewed the sequence had created in left side: SEQENCE原创 2012-02-18 18:10:32 · 506 阅读 · 0 评论 -
跟我学plsql - 定义变量 (一)
Class 1:This I will intruduce the PLSQL: First, list the useful of plsql: 1: variable,constant, and data types 2: Control structures such as conditional statement and loops 3: Reusable p原创 2012-02-18 22:48:32 · 6385 阅读 · 0 评论 -
跟我学plsql - 定义变量 (二)
This I will continue to intruduce the PLSQL: Guidelines for Declaring and initializing PL/SQL variables 1: Follo naming conventions. 2: Using meaningful identifiers for variables.原创 2012-02-20 10:06:24 · 835 阅读 · 0 评论 -
跟我学plsql - 写可执行的语句 (一)
This I will intruduce the PLSQL:Step1: Using Literals: 1: Character and date literals must be enclosedin quotation marks 2: Number can be simple values or in scientific notation. e原创 2012-02-20 11:17:00 · 872 阅读 · 0 评论 -
跟我学plsql - 写可执行的语句 (二)
This I will intruduce How to write excelent PLSQL:Step1: The scope of variables: 1: The internal variables can be only used in internal declaration. 2: The external variables can be use原创 2012-02-21 11:04:34 · 527 阅读 · 0 评论 -
修改sql 语句 前面 写错的部分 - 在unix 环境下
示例:SQL>; select * from myuser; ID USERNAME PASSWORD SJ---------- ---------- ---------- ------------------- 1 John 1234 2003-05-01 00:00:00 2 Jack原创 2012-11-16 16:29:04 · 873 阅读 · 0 评论