- ORACLE数据备份
exp 用户名/密码@服务名 owner=用户 file="导出文件名称路径.bmp" - ORACLE数据库导入
imp 用户名/密码@服务名 full=y file=文件所在路径.dmp - ORACLE函数
DECODE:判断函数
DECODE(cjob.sex,1,'男',2,'女',0,'不限');
to_char:格式转换
to_char(uptime ,'yyyy-MM-dd HH24:MI:ss') - 复合语句查询:
select id ,moduleid,(select nickname from users where users.userid=cjob.userid) userid,(select name from commcode where commcode.type='C_job' and commcode.val=cjob.job) job,describe,count,DECODE(cjob.sex,1,'男',2,'女',0,'不限','adsf') sex,(select name from commcode where commcode.type='C_age' and commcode.val=cjob.age1) age1,(select name from commcode where commcode.type='C_age' and commcode.val=cjob.age2) age2,(select name from commcode where commcode.type='C_education' and commcode.val=cjob.education) education,DECODE(marry,0,'不限',1,'已婚',2,'未婚') marry,(select name from commcode where commcode.type='C_experience' and commcode.val=cjob.experience) experience,require, place,salary,treatment,valid,isvalid,leavedate from companyjob cjob where cjob.id=2 - oracle系统表
查看所有表名:
select * from all_tables;
查看表注释
select * from all_TAB_comments;
查看所有表结构:
select * from all_tab_columns;
查看所有含约束字段及对应约束名:
select * from all_cons_columns;
查看所有字段注释:
select * from all_col_comments;
oracle数据库学习笔记
最新推荐文章于 2024-05-16 21:05:49 发布