断情漠的博客_Mysql,Oracle,自动化运维,redis,操作系统,服务器&存储,Hadoop,Oracle SQL,Work Others,Oracle Audit

MySQL中函数CONCAT及GROUP_CONCAT(aggregate)

一、CONCAT（）函数CONCAT（）函数用于将多个字符串连接成一个字符串。使用数据表Info作为示例，其中SELECT id,name FROM info LIMIT 1;的返回结果为+----+--------+| id | name |+----+--------+| 1| BioCyc |+----+--------+1、语法及使用特点：CONCAT(

mysql

concat

原创 2017-06-30 12:01:18 5048 阅读

MySQL 常见str函数

MySQL常见的字符串函数整理自官档。1.1 SUBSTR or SUBSTRINGSUBSTR(str,pos), SUBSTR(str FROM pos),SUBSTR(str,pos,len), SUBSTR(str FROMpos FOR len)SUBSTR() is a synonym for SUBSTRING(). SUBS

mysql

substring

原创 2017-06-23 14:07:51 1237 阅读 1点赞 1收藏

Oracle执行计划突变诊断之统计信息收集问题

Oracle执行计划突变诊断之统计信息收集问题1. 情形描述DB version：11.2.0.4WITH SQL1 AS (SELECT LAC, CI,

Oracle

统计

信息锁定

原创 2017-06-23 13:29:53 2442 阅读

Ora - 20005

SQL> begin 2 3 dbms_stats.gather_table_stats(ownname => 'GZ_SAFETY',tabname=>'MB_BSS_USER_LOCATION', partname =>'PART_20170621')

ORA

20005

原创 2017-06-23 13:26:48 1041 阅读

Oracle data type number

Oracle numberNUMBER [ (p [, s]) ]Number having precision p and scale s. Theprecision p can range from 1 to 38. The scale s can range from -84 to 127. Bothprecision and scale are in decimal digits. A N

oracle

number

原创 2017-06-21 13:35:56 842 阅读

MySQLstatus variable Com_stmt_xxx

All of the Com_stmt_xxx variables areincreased even if a prepared statement argument is unknown or an error occurredduring execution. In other words, their values correspond to the number ofrequests i

Mysql

status

variable

原创 2017-06-06 11:26:32 1404 阅读

Oracle local write wait等待事件

Note 1： TypicallyDBWR has to free up some buffers when you want to read something from the disk.During this process there are chances that you will be w

Oracle

write

local

原创 2017-06-02 20:18:02 2379 阅读

Oracle conncect role vs create session

Oracle conncect role vs create sessionThe CONNECT role was introduced with OracleDatabase version 7, which added new and robust support for database roles. TheCONNECT role is used in sample code, appl

Oracle

create

connect

原创 2017-06-01 20:16:14 776 阅读

官方博客	全部文章	热门标签	班级博客
了解我们	网站地图	意见反馈

鸿蒙开发者社区	51CTO学堂
51CTO	软考资讯

51CTO博客

90SirDB

MySQL中函数CONCAT及GROUP_CONCAT(aggregate)

MySQL 常见str函数

Oracle执行计划突变诊断之统计信息收集问题

Ora - 20005

Oracle data type number

MySQLstatus variable Com_stmt_xxx

Oracle local write wait等待事件

Oracle conncect role vs create session