因为新公司用的是Oracle,之前几年所在的公司用的都是mysql,所以为了方便记录一下Oracle笔记
这几篇博客操作比较全,直接拿过来借鉴了:
https://blog.csdn.net/hza419763578/article/details/89853586
https://www.jianshu.com/p/b2d2ca6ae273
1、查看当前用户有哪些表:
select table_name from user_tables;
2、oracle的基本增删改查操作:基本操作跟mysql没什么区别
增:insert into person(id, name) values (1, ‘张三‘) 删(删除表数据):delete from person 改:update person set name = ‘李四‘ where id = 1; 查:select * from person;
3、几个列字段合并字符串,用:||
select name || ‘ ‘ || age AS nameAge from person
...