01 2015 档案
摘要:#!/bin/bashPATH=/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin#declare -a MD5basedir=/usr/srcdatadir=/da...
阅读全文
摘要:#!/bin/bashPATH=/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bindate=`ansible localhost -m command -a "dat...
阅读全文
摘要:#!/bin/bashPATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/mysql/bin:/root/binDATADI...
阅读全文
摘要:函数Oracle 字符函数; 首字母大写;INITCAP :函数;select ID,NAME,INITCAP(NAME) from alex_t05 ;Oracle查询替换函数 REPLACEselect NAME,REPLACE(NAME,'x','__') FROM alex_05oracle...
阅读全文
摘要:DELIMITER &&create procedure firefox98(IN count_id INT,OUT count_num INT)BEGINSELECT COUNT(id) INTO count_num from userwhere id = count_id;END &&DELIM...
阅读全文
摘要:1、oracle Index2、oracle 创建表空间语法3、oraclee 创建存储过程Oracle 索引结构扫描,获取待返回数据行的ROWID 根据获取的ROWID扫描表,获取对应数据行,并返回ROWID的扫描方式其实就是索引扫描的第二个动作,换而言之,索引扫描的目标就是通过ROWID扫描...
阅读全文