;모든 테이블 select * from tab;특정 테이블의 컬럼 정보select * from all_tab_columns where owner = '계정명' and table_name = '테이블'
where regdate between adddate(curdate(), 1-dayofmonth(curdate())) and last_day(curdate());
where regdate between adddate(curdate(), -weekday(curdate())) and adddate(curdate(), 6-weekday(curdate()));
where regdate >= @@@ and regdate <= now();
; ~ 30일where regdate between subdate(now(), interval 30 DAY) and now();