SQL练习题经典|初中高|含存储过程

上传者: sunpx3 | 上传时间: 2021-06-18 14:17:43 | 文件大小: 13.02MB | 文件类型: ZIP
进公司学习时学习的sql文档,比较全。从初级到高级,含存储过程练习。练习请使用oracle ,scott下的emp表与dept表。

文件下载

资源详情

[{"title":"( 71 个子文件 13.02MB ) SQL练习题经典|初中高|含存储过程","children":[{"title":"SQL资料","children":[{"title":"sqlppt","children":[{"title":"Les02-对数据进行限定和排序.pptx <span style='color:#111;'> 164.50KB </span>","children":null,"spread":false},{"title":"Les15-执行PLSQL语句.pptx <span style='color:#111;'> 146.15KB </span>","children":null,"spread":false},{"title":"Les04-处理单行的函数.pptx <span style='color:#111;'> 212.23KB </span>","children":null,"spread":false},{"title":"Les07-使用 SQLPlus创建友好的输出.pptx <span style='color:#111;'> 173.00KB </span>","children":null,"spread":false},{"title":"Les14-声名变量.pptx <span style='color:#111;'> 224.64KB </span>","children":null,"spread":false},{"title":"Les21-异常处理.pptx <span style='color:#111;'> 158.83KB </span>","children":null,"spread":false},{"title":"Les08-操作数据-DML语句.pptx <span style='color:#111;'> 195.37KB </span>","children":null,"spread":false},{"title":"Les05-使用分组函数来对数据进行聚集.pptx <span style='color:#111;'> 174.12KB </span>","children":null,"spread":false},{"title":"Les10-数据库中的约束.pptx <span style='color:#111;'> 170.35KB </span>","children":null,"spread":false},{"title":"Les17-控制结构.pptx <span style='color:#111;'> 178.26KB </span>","children":null,"spread":false},{"title":"Les13-控制用户访问.pptx <span style='color:#111;'> 403.49KB </span>","children":null,"spread":false},{"title":"Les22-包-函数-触发器的管理.pptx <span style='color:#111;'> 173.43KB </span>","children":null,"spread":false},{"title":"Les19-显式游标的使用.pptx <span style='color:#111;'> 157.51KB </span>","children":null,"spread":false},{"title":"Thumbs.db <span style='color:#111;'> 16.00KB </span>","children":null,"spread":false},{"title":"Les18-复合数据类型的使用.pptx <span style='color:#111;'> 142.11KB </span>","children":null,"spread":false},{"title":"Les03-从多个表中获取数据.pptx <span style='color:#111;'> 144.88KB </span>","children":null,"spread":false},{"title":"Les20-高级显式游标.pptx <span style='color:#111;'> 124.86KB </span>","children":null,"spread":false},{"title":"Les11-创建视图.pptx <span style='color:#111;'> 144.96KB </span>","children":null,"spread":false},{"title":"Les12-其它的数据库对象.pptx <span style='color:#111;'> 153.00KB </span>","children":null,"spread":false},{"title":"Les01-基本sql语句.pptx <span style='color:#111;'> 155.19KB </span>","children":null,"spread":false},{"title":"Les09-创建和管理表.pptx <span style='color:#111;'> 161.59KB </span>","children":null,"spread":false},{"title":"Les06-子查询.pptx <span style='color:#111;'> 212.90KB </span>","children":null,"spread":false},{"title":"Les16-与Oracle服务器之间的交互.pptx <span style='color:#111;'> 139.02KB </span>","children":null,"spread":false}],"spread":false},{"title":"sql-ppt","children":[{"title":"PLSQL_PPT-Les07.ppt <span style='color:#111;'> 269.50KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les19.ppt <span style='color:#111;'> 199.00KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les17.ppt <span style='color:#111;'> 312.50KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les16.ppt <span style='color:#111;'> 312.50KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les13.ppt <span style='color:#111;'> 424.00KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les02.ppt <span style='color:#111;'> 412.50KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les03.ppt <span style='color:#111;'> 614.00KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les18.ppt <span style='color:#111;'> 287.50KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les20.ppt <span style='color:#111;'> 295.00KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les14.ppt <span style='color:#111;'> 227.00KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les01.ppt <span style='color:#111;'> 469.50KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les12.ppt <span style='color:#111;'> 216.00KB </span>","children":null,"spread":false},{"title":"Thumbs.db <span style='color:#111;'> 19.00KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les05.ppt <span style='color:#111;'> 287.00KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les11.ppt <span style='color:#111;'> 405.00KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les08.ppt <span style='color:#111;'> 617.50KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les04.ppt <span style='color:#111;'> 485.00KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les06.ppt <span style='color:#111;'> 338.50KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les10.ppt <span style='color:#111;'> 386.00KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les09.ppt <span style='color:#111;'> 375.00KB </span>","children":null,"spread":false},{"title":"PLSQL_PPT-Les15.ppt <span style='color:#111;'> 291.00KB </span>","children":null,"spread":false}],"spread":false},{"title":"oracle常用函数说明.pdf <span style='color:#111;'> 37.13KB </span>","children":null,"spread":false},{"title":"plsql","children":[{"title":"init.sql <span style='color:#111;'> 4.04KB </span>","children":null,"spread":false},{"title":"03高级","children":[{"title":"练习.txt <span style='color:#111;'> 2.08KB </span>","children":null,"spread":false},{"title":"14 存储过程","children":[{"title":"procedure.sql <span style='color:#111;'> 1.53KB </span>","children":null,"spread":false}],"spread":true},{"title":"11 PLSQLl语法","children":[{"title":"plsql.sql <span style='color:#111;'> 5.78KB </span>","children":null,"spread":false}],"spread":true},{"title":"16 触发器","children":[{"title":"trigger.sql <span style='color:#111;'> 1.35KB </span>","children":null,"spread":false}],"spread":true},{"title":"练习答案.txt <span style='color:#111;'> 5.74KB </span>","children":null,"spread":false},{"title":"15 函数","children":[{"title":"function.sql <span style='color:#111;'> 471B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"03PL.txt <span style='color:#111;'> 2.37KB </span>","children":null,"spread":false},{"title":"05PL.txt <span style='color:#111;'> 1.87KB </span>","children":null,"spread":false},{"title":"01初级","children":[{"title":"SQL练习答案.txt <span style='color:#111;'> 2.90KB </span>","children":null,"spread":false},{"title":"02 简单SQL语句","children":[{"title":"simple_sql.sql <span style='color:#111;'> 3.63KB </span>","children":null,"spread":false}],"spread":true},{"title":"03 单行函数","children":[{"title":"single_function.sql <span style='color:#111;'> 7.38KB </span>","children":null,"spread":false}],"spread":true},{"title":"SQL练习.txt <span style='color:#111;'> 1.15KB </span>","children":null,"spread":false}],"spread":true},{"title":"02中级","children":[{"title":"04 复杂查询","children":[{"title":"complex_query.sql <span style='color:#111;'> 5.19KB </span>","children":null,"spread":false}],"spread":true},{"title":"06 表的管理","children":[{"title":"createTable.sql <span style='color:#111;'> 4.15KB </span>","children":null,"spread":false}],"spread":true},{"title":"练习.txt <span style='color:#111;'> 2.49KB </span>","children":null,"spread":false},{"title":"练习(部分答案).TXT <span style='color:#111;'> 4.61KB </span>","children":null,"spread":false},{"title":"08 序列同义词","children":[{"title":"sequence.sql <span style='color:#111;'> 1.91KB </span>","children":null,"spread":false}],"spread":true},{"title":"12 索引","children":[{"title":"index.sql <span style='color:#111;'> 1.20KB </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"02PL.txt <span style='color:#111;'> 1.71KB </span>","children":null,"spread":false},{"title":"07PL.txt <span style='color:#111;'> 2.53KB </span>","children":null,"spread":false},{"title":"table.sql <span style='color:#111;'> 1.50KB </span>","children":null,"spread":false},{"title":"06PL.txt <span style='color:#111;'> 3.34KB </span>","children":null,"spread":false},{"title":"01PL.txt <span style='color:#111;'> 2.20KB </span>","children":null,"spread":false},{"title":"04PL.txt <span style='color:#111;'> 1.99KB </span>","children":null,"spread":false}],"spread":false},{"title":"Database_SQL Language Reference(e41084).pdf <span style='color:#111;'> 11.98MB </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明