ORA-00904：invalid identifier

这个提示是：你的sql语句有写错的地方如：

select count(1) from (
SELECT         
a.id AS "id",   
a.production_batch AS "productionBatch",   
a.sales_order_number AS "salesOrderNumber",   
a.manufacturer AS "manufacturer",   
a.purchases_units AS "purchasesUnits",   
a.sale_date AS "saleDate",   
a.upload_date AS "uploadDate",   
a.drugs_name AS "drugsName",   
a.product AS "product",   
a.approval_number AS "approvalNumber",   
a.sales_volume AS "salesVolume",   
a.create_by AS "createBy.id",   
a.create_date AS "createDate",   

a.update_by AS "updateBy .id", 
  
a.update_date AS "updateDate",   
a.remarks AS "remarks",   
a.del_flag AS "delFlag",   
a.drug_coding AS "drugCoding",   
a.approval_species AS "approvalSpecies",   
a.type_approval AS "typeApproval",   
a.min_pack_unit AS "minPackUnit",   
a.validity AS "validity"      
FROM sales_data a           
)

这样就是多个空格，就会报错。

其实用二分法就可以找到原因