select student.sql

关于使用ORCLE数据库的例子

REM PL/SQL Developer SQL History
select t.*, t.rowid from dept t
/
UPDATE dept 
           SET address='326#'
           WHERE dept_no= '101';

/
select * from dept;
/
select * from student t
where t.dept_no = '102'

/
select * from student t
where t.dept_no = '102'