本文提供了一系列SQL操作示例，包括清空表、数据截断、更新记录等常见操作，并展示了如何进行日期格式化及表数据复制。
truncate table hz03;
select trunc(to_number('123.123'),2) from dual;
select * from hz03 order by in_date desc;
select to_char(in_date, 'yyyy-mm-dd hh24:mi:ss') from hz03 order by in_date desc;
update hz05 set stuname='吴创智' where stuid='170318016';
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') as nowTime from dual;
select * into hz01_old from hz01; -- SQL 语句
select * from hz01_old;
create table hz01_old as select * from hz01;
insert into hz01_old select * from hz01;
select trunc(to_number('123.123'),2) from dual;
select * from hz03 order by in_date desc;
select to_char(in_date, 'yyyy-mm-dd hh24:mi:ss') from hz03 order by in_date desc;
update hz05 set stuname='吴创智' where stuid='170318016';
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') as nowTime from dual;
select * into hz01_old from hz01; -- SQL 语句
select * from hz01_old;
create table hz01_old as select * from hz01;
insert into hz01_old select * from hz01;
扫一扫
1824
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
