存储过程(stored procedure)从根本上讲就是命名PL/SQL程序块,它可以被赋予参数、存储在数据库中,然后由另一个应用或者PL/SQL例程激活(或者调用)。建立最简单的存储过程: SQL>createproceduremy_procas2begin3null;4endmy_proc;5/过程已创建。 注意: 可以注意到,当建立存储过程的时候,用户需要在过程的最后一行放入...
Procedural languages such as C describehowthings should be done. SQL is nonprocedural and describeswhatshould be done. SQL is the ANSI standard language for relational databases. All operations on the data in an Oracle database are performed using SQL statements. For example, you use SQL to cr...
you can define user profile options that affect the way your application runs. For example, you might define a user profile option to determine which subset of the organization's data your end user sees. When you define a new option, you specify criteria to describe valid values for that op...
• Use a time-based or event-based schedule for executing Oracle Scheduler jobs • Describe the use of windows, window groups, job classes, and consumer groups • Use email notification • Use job chains to perform a series of related tasks • Describe Scheduler jobs on remote systems...
The normalization process that we describe briefly in this section results in third normal form (3NF), the most common type of normalization. Explaining the complete concepts that lie behind the different normal forms is beyond the scope of this chapter and book. The concept of normalized table ...
When each shared pool chunk is allocated the code is passed to a function that does the work of allocation and this address is visible to KSMCHCOM column,which describe the purpose of allocation. This chunk is supposed to be larger then the size of the object as it also contains the head...
The following paragraphs describe the supported availability modes. Maximum Availability Mode (Oracle Database 10g Rel 2 and later) In Maximum Availability mode, FSFO guarantees that no transaction that has received a commit acknowledgment will be lost during a failover. The price for this ...
FORMAT MENU: disk - select a disk type - select (define) a disk type partition - select (define) a partition table current - describe the current disk format - format and analyze the disk repair - repair a defective sector label - write label to the disk analyze - surface analysis ...
The two tables that follow describe attributes that are specific to each provider.Table 2. ODP.NET Connection String AttributesExpand table NameDescription Connection Timeout Maximum time in seconds to wait for a connection from the pool. DBA Privilege Specifies administrative privilege—SYSDBA or ...
()A、DELETEemployees;B、DESCRIBEemployees;C、ROLLBACKTOSAVEPOINTC;D、GRANTSELECTONemployeesTOSCOTHE、ALTERTABLEemployeesSETUNUSEDCOLUMNsal;F、SelectMAX(sal)FROMemployeesWHEREdepartment_id20;14.Why should you back up a duplicated tablespace after a TSPITR is complete?() ...