摘要:
oracle第三天总结<orcle的若干的对象>(1)视图 a>普通视图 创建视图:create or replace view myview_view as select * from myemp3; 删除视图:drop view myview; 理解:一般视图不推荐做插入、修改操作,推荐做wit 阅读全文
摘要:
oracle第二天总结(1)单表查询(完整语句:select from where group by having order by ) <除了第5点,其他都要求掌握> 1.select 查询语句 去重:select distinct deptno,mgr 作用于多列 别名:select ename 阅读全文
摘要:
oracle第一天: (1)oracle安装 a>oracle下常用命令 sqlplus scott/tiger@192.168.56.101:1521/orcl conn sys/raobing@192.168.56.101:1521/orcl as sysdba show user; set l 阅读全文