select student.sql

来自「关于使用ORCLE数据库的例子」· SQL 代码 · 共 18 行

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'