![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
文章平均质量分 75
yu--chen
这个作者很懒,什么都没留下…
展开
-
oracle
--8.27 sqlplus system/sias alter user hr account unlock; alter user hr identified by hrpwd; conn hr/hrpwd /*create table sal_history as select employee_id,hire_date,salary原创 2013-04-07 14:55:18 · 673 阅读 · 0 评论 -
oracle 包的创建
创建一个包,定义一个存储过程,得到编号为7900的员工的信息。sqlplus system/passwordalter user scott account unlockalter user scott identified by tigerconn scott/tiger 包的头部CREATE OR REPLACE PACKAGE wage_packageyuch原创 2013-05-03 15:49:18 · 453 阅读 · 0 评论 -
oracle实验课作业
1,创建一个学生用户,并为之授予权限。sqlplus system/siasdrop user stu01 cascade;create user stu01 identified bystu01default tablespce userstemporary tablesapce temp; create role r_stu;grant create sessio原创 2013-05-17 15:30:40 · 592 阅读 · 0 评论 -
数据库原理
1.select sno,sname from student where sage>25 and ssex='女'2.select sname from student,sc,coursewhere student.sno=sc.sno and sc.cno=course.cno and cname='数据库'3.select count(*) from sc where cno原创 2013-06-08 23:41:55 · 790 阅读 · 0 评论 -
数据库2
1、查询成绩大于90分的课程名和成绩select cname,grade from course,sc where course.cno=sc.cno and grade>902、查询年龄大于20岁且选修了数据库课程的学生的成绩和姓名,按成绩降序排序。select sname,grade from sc, student,course where course.cno = sc.cno原创 2013-06-08 23:42:35 · 566 阅读 · 0 评论