本文涵盖了一系列SQL基础知识，包括Char、Varchar与Varchar2的区别；外连接与内连接的应用场景；游标的使用方法；事务开始的时机；外键的作用；TRUNCATE语句的特性；函数与过程的不同；触发器的工作原理；如何列出每个部门的最高薪资以及ROWNUM的使用方法。
1，Char, varchar and varchar2 区别？
2，Outter join & Inner join 区别？
3，什么是Cursor, 如何使用？
4，When/where does a Transaction begin?
5,What is a Foreign key?
6,Can we Rollback changes made by a 'Truncate'?
7,Difference between Function & Procedure?
8,What is a Trigger, Two Trigger, same condition, which one go first?
9,Emp (EMP_ID, SALARAY, DEP_ID)
Write a SQL to list highist salary of each department.
10, What is RowNum? Can we use a clause '......where RowNum = n' to get the NO. n record?
2，Outter join & Inner join 区别？
3，什么是Cursor, 如何使用？
4，When/where does a Transaction begin?
5,What is a Foreign key?
6,Can we Rollback changes made by a 'Truncate'?
7,Difference between Function & Procedure?
8,What is a Trigger, Two Trigger, same condition, which one go first?
9,Emp (EMP_ID, SALARAY, DEP_ID)
Write a SQL to list highist salary of each department.
10, What is RowNum? Can we use a clause '......where RowNum = n' to get the NO. n record?
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
