Oracle implementation tips lack of expression-CodePudding

The select to_char (BLRQ, 'yyyy - MM - dd HH24: mi: ss'),
*
The from FJXX
Where tablename='foster_service_info'
And FJLB='4'
And fjid='8081 c764039f183c'
The order by FJMC
To perform prompt lack of expression

CodePudding user response:

The select to_char (BLRQ, 'yyyy - MM - dd HH24: mi: ss'),
T. *
The from FJXX t
Where tablename='foster_service_info'
And FJLB='4'
And fjid='8081 c764039f183c'
The order by FJMC

CodePudding user response:

Table with the alias,

CodePudding user response:

 
The select to_char (BLRQ, 'yyyy - MM - dd HH24: mi: ss'), a. * 
The from FJXX a 
Where tablename='foster_service_info' 
And FJLB='4' 
And fjid='8081 c764039f183c' 
The order by FJMC

CodePudding user response:

refer to the second floor liuzhijian2008x response:

table with alias,

good thank you