6.2、oracle 相关sql1
需积分: 0 129 浏览量
2022-08-08
21:56:19
上传
评论
收藏 14KB DOCX 举报
select user from dual; /*查看当前用户*/
select * from user_tables; /*查看当前用户下，所有的表*/
select 'select * from '||t.table_name||';' from user_tables t where
t.table_name like '%CFG';
select sys_guid() from dual
------- getAppseriono --------
select lpad(appseriono_sequence.nextval, 20, '0') from dual
select 'JF'||lpad(contriapplyno_sequence.nextval, 6, '0') from dual ;
select
'w'||to_char(sysdate,'yyyymmdd')||lpad(Flow_NO_SEQUENCE.Nextval,
7,'0') from dual
select '123'||'fdsf' from dual;
评论0
最新资源