摘要:
oracle第三天总结<orcle的若干的对象>(1)视图 a>普通视图 创建视图:create or replace view myview_view as select * from myemp3; 删除视图:drop view myview; 理解:一般视图不推荐做插入、修改操作,推荐做wit 阅读全文
posted @ 2017-06-05 10:44
xiaorong1115
阅读(104)
评论(0)
推荐(0)
摘要:
oracle第二天总结(1)单表查询(完整语句:select from where group by having order by ) <除了第5点,其他都要求掌握> 1.select 查询语句 去重:select distinct deptno,mgr 作用于多列 别名:select ename 阅读全文
posted @ 2017-06-05 10:42
xiaorong1115
阅读(143)
评论(0)
推荐(0)
摘要:
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 阅读全文
posted @ 2017-06-05 10:11
xiaorong1115
阅读(170)
评论(0)
推荐(0)

浙公网安备 33010602011771号