做一个有趣的妞儿

原编码设置为acill，改为utf8编码。

oracle like 语句通配符%使用注意

一个表的一个id有多个记录，查询id的最新记录

https://blog.csdn.net/m0_37253968/article/details/120326922select * from ekp_map_BGYPaddORdel_dt1 where （fd_caozuo='add' or fd_caozuo='upd'） and fd_wenDangZhuangTaiMa='30' --删除多列ALTER TABLE ekp_map_BGYPaddORdel_dt1 DROP(FD_3ABECFB9138756_TEXT,FD_WUPINXI

--清空表空间alter table ekp_map_bgypaddordel_dt1 drop column fd_wupinbianhao ;

------PLSQL 创建字段自增--1.新建一个seqcreate sequence fd_wupinbianhao minvalue 1 maxvalue 999999999start with 1 increment by 1 cache 20 nocycle;--2.修改seqALTER sequence fd_wupinbianhao increment by 1maxvalue 10000000nocyclenocache--3.删除seqdrop sequ

select to_char(sysdate,'YYYYMMDD W HH24:MI:SS') from dual; TO_CHAR(SYSDATE,‘YY’)select to_char(sysdate,'W') from dual; select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') as nowTime from dual; //日期转化为字符串 select to_char(sysdate,'yyyy') as nowYear fr.

查询最新一条数据：select * from (select * from 表名 where fd_yard='123' order times ) where ROWNUM = 1查询数据数量count： select count(*) from 表名