51
Dev开发社区
首页
文章
问答
工具
搜索
登录
注册
#GRE
PostgreSQL获取年月日
1.获取当前日期的年份selectto_char(t.detect_date,'YYYY')selectextract(yearfromnow())为doubleprecision格式类型selectto_char((SELECTnow()::timestamp),'yyyy')2.获取...
开发笔记
·
2024-09-06
PostgreSQL
获取
年月日
Linux grep指令的10个使用技巧
grep(globalregularexpressionprint)是Linux或其他类Unix操作系统中的一个功能强大的命令行搜索工具。它可以从文件或标准输入中搜索文本或字符串,并显示匹配的行或统计信息。grep命令有大量的选项和用法,本文将介绍一些常见的示例。grep命令可用于在一个或多个文件中搜索字符串或正则表达...
开发笔记
·
2023-12-30
Linux
grep
指令
10个
使用技巧
ORA-41697: attribute prefix missing in aggregate specification: string
文档解释ORA-41697:attributeprefixmissinginaggregatespecification:stringCause:Anattemptwasmadetospecifyanaggregatepredicateacrossmultipleprimitiveeventtypeswithnoatt...
IT技术学习
·
2023-07-28
ORA-41697
attribute
prefix
missing
in
ORA-24909: call in progress. Current operation cancelled
文档解释ORA-24909:callinprogress.CurrentoperationcancelledCause:TheOCIcallwasinvokedwhenanothercallontheconnectionwasinprogress.Action:CheckiftheOCIcallissupportedw...
IT技术学习
·
2023-07-28
ORA-24909
call
in
progress.
Current
ORA-39206: A parallel degree of string is invalid.
文档解释ORA-39206:Aparalleldegreeofstringisinvalid.Cause:AbadnumericwassuppliedforspecifyingtheparallelismtobeusedwithinaDataPumpjob.Thedegreeofparallelismmustbeani...
IT技术学习
·
2023-07-27
ORA-39206
parallel
degree
of
string
ORA-13619: The procedure argument string is greater than the maximum allowable length of string characters.
文档解释ORA-13619:Theprocedureargumentstringisgreaterthanthemaximumallowablelengthofstringcharacters.Cause:Theuserattemptedtopassacharacterargumentthatistoolong.Act...
IT技术学习
·
2023-07-27
string
ORA-13619
The
procedure
argument
ORA-40382: More than one linear regression equation in the model
文档解释ORA-40382:MorethanonelinearregressionequationinthemodelCause:Morethanonelinearregressionequationwasinthemodel.Action:Makesurethereisonlyonelinearregressione...
IT技术学习
·
2023-07-26
ORA-40382
More
than
one
linear
ORA-48226: No Fetch in Progress
文档解释ORA-48226:NoFetchinProgressCause:Anattempttoperformupdateordeletehasoccurredwithoutafetch.Action:Youmustfirstperformafetch.ORA-48226是Oracle数据库的一个错误码。它表明在执行一...
IT技术学习
·
2023-07-26
ORA-48226
No
Fetch
in
Progress
ORA-19733: COMPATIBLE parameter needs to be string or greater
文档解释ORA-19733:COMPATIBLEparameterneedstobestringorgreaterCause:TheCOMPATIBLEinitializationparameterisnothighenoughtoallowtheoperation.Allowingthecommandwouldmak...
IT技术学习
·
2023-07-26
ORA-19733
COMPATIBLE
parameter
needs
to
ORA-56902: expect aggregate function inside pivot operation
文档解释ORA-56902:expectaggregatefunctioninsidepivotoperationCause:Attemptedtousenon-aggregateexpressioninsidepivotoperation.Action:Useaggregatefunction.等。ORA-56902...
IT技术学习
·
2023-07-26
ORA-56902
expect
aggregate
function
inside
ORA-46101: Circular definition for aggregate privilege string in security class string
文档解释ORA-46101:CirculardefinitionforaggregateprivilegestringinsecurityclassstringCause:Definitionofanaggregateprivilegecontaineditself.Action:Fixtheaggregatepriv...
IT技术学习
·
2023-07-26
string
ORA-46101
Circular
definition
for
ORA-31690: Process name buffer size must be specified and must be greater than 0.
文档解释ORA-31690:Processnamebuffersizemustbespecifiedandmustbegreaterthan0.Cause:CalledgetworkerexceptionandeitherspecifiedNULLor0forthebuffersizeargument.Action:B...
IT技术学习
·
2023-07-26
must
be
ORA-31690
Process
name
ORA-16284: timed out waiting for an in-progress operation to complete
文档解释ORA-16284:timedoutwaitingforanin-progressoperationtocompleteCause:Anoperationtimedoutwaitingforanotheroperationtocomplete.Action:Retrytheoperationwhenthein-...
IT技术学习
·
2023-07-26
ORA-16284
timed
out
waiting
for
ORA-10997: another startup/shutdown operation of this instance inprogress
文档解释ORA-10997:anotherstartup/shutdownoperationofthisinstanceinprogressCause:AnOracleInstancestartuporshutdownoperationfailedtoprocuretheserializationprimitive.A...
IT技术学习
·
2023-07-26
ORA-10997
another
startup
shutdown
operation
ORA-12477: greatest lower bound resulted in an invalid OS label
文档解释ORA-12477:greatestlowerboundresultedinaninvalidOSlabelCause:Youtriedtodoanoperationthatgeneratedagreatestlowerbound(GLB)labelwhichisnotavalidlabelonyouroper...
IT技术学习
·
2023-07-26
ORA-12477
greatest
lower
bound
resulted
首页
上一页
1
2
3
4
5
...
下一页
尾页
按字母分类:
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
其他