select * from tab;
create table table_name (id varchar2(2) primary key, name varchar(10) not null, sex varchar2(1) default '0')
drop table table_name
select * from table_name where ... group by ... having ... order by ... limit ...
delete from table_name where ....
insert into table_name values (...., ....)
insert into table_name (..., ...) values (..., ...)
update table_name set ... = ... where ...
alter table table_name add (....)
alter table table_name drop column column_name
alter table table_name modify ... ...
nvl(column_name, 'default')
decode(column_name, '', '_', 'nomal')
to_char(column_name, 'yyyy-mm-dd')
to_date(sysdate, 'yyyy-mm-dd hh:mi')
union all, union和 left join, right join