|
|
此文章由 dotnet 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 dotnet 所有!转贴必须注明作者、出处和本声明,并保持内容完整
Oracle PL/SQL (Express)
15 questions
1. %rownum
2. ROWID
3. %type, %rowtype
4. cursor usage methods(explicit, implicit, dynamic)
5.the stored subprograms' capability to be stored in the database, procedures, functions, and packages offer many advantages: performance
6 A procedure or function consists of four parts
7How do you convert a date to a string?
8 What is an aggregate function? r "grouping", sums or counts, etc.
9 What is an interval? Specifies a period of time.
10 What is a nested subquery? A subquery in a where clause.
11What is the dual table? A single row table provided by oracle for selecting values and expressions.
12 Using an Explicit Cursor
13 improve query performance
by the way
which platform is your employer using? |
|