Tutorials to .com

Tutorials to .com » Database » Oracle » Oracle Tutorial

Oracle Tutorial Articles


501: Graduate Management Information System development process
System Requirements Analysis Personal information management graduate Instructor Information Management Professional information management Modular design features In response to these needs, the design of functional modules as shown in Figure ...

502: VB procedures for how to access the database
【Data】 control through access to the database (1) Start VB. (2) appears as shown in Figure 10.12 of the new project】 【new tab. (3) appears as shown in Figure 10.13 of the VB interface. (4) as shown in Figure 10.14. (5) appears as shown ...

503: VB procedure how to connect database
ODBC data source 1. What is ODBC ODBC (Open Database Connectivity, an open database connectivity), is the common international standards for database access. 2. What is the ODBC Data Source 】 【ODBC data source is ODBC on your computer config...

504: VB + Oracle 9i how to build and run the development environment
How to choose the future of development tools How to Build a development and runtime environment A VB + Oracle 9i database application from the logic point of view there are three components. As shown in Figure 10.1. 1. Construction of the develo...

505: PL / SQL comprehensive examples
This section will be learning in front of the PL / SQL based on the analysis of a more complex example to the church to prepare the reader a complete PL / SQL procedures. Examples of design 1. Functional Design Colleges and universities to develo...

506: PL / SQL Exception Handling
In the design of PL / SQL procedures, are often in one way or another error, exception handling is carried out for the wrong procedure paragraph, Oracle 9i in the exception handling system is divided into pre-defined custom exception handling and ex...

507: PL / SQL sequence
Oracle 9i sequence is provided for in accordance with the rules set by the program automatically generates the data object. In some data structure, there are some fields in need of such properties. For example, a student data sheet for school number...

508: PL / SQL course
To use PL / SQL procedures are completed relatively complete database of tasks, the need for further study some of the content of high-level design elements. In front of the preparation of the implementation of the PL / SQL procedures, there is no c...

509: Oracle 9i cursor
Cursor is a data table from data extracted to form a temporary table stored in memory, in the the cursor in a data pointer, point to the initial state is the first record of the use of fetch statement can move the pointer, which data cursor in a var...

510: Oracle 9i Transaction Processing
Services is Oracle 9i database in the basic unit of operation in PL / SQL procedure, you can use three transaction control commands. commit command was the submission of the order commit. Oracle 9i database in order to ensure consistency of data i...

511: PL / SQL process control
PL / SQL procedures for process control in a number of statements from high-level language to control the thinking process, but has its own characteristics. Conditions of control Conditions through the following examples of the use of control stat...

512: PL / SQL basic syntax elements
Constant 1. The definition of the syntax constants Constant type of identifier constant [not null]: = value; Constants, including the back of the variable name must start with a letter, can not have spaces, not more than 30 characters in length, ...

513: PL / SQL Program Structure
What is PL / SQL procedures Chapter 4 in front of the standardization of learning the language of the SQL databases of various operations, each can only run one statement, statement of the semicolon in English ";" to end the logo, so very...

514: Oracle 9i audit
The role of audit 1. Review of suspicious activity 2. Surveillance and data collection activities on the designated data The type of audit 1. Statement audit (STATEMENT AUDITING) 2. Audit permissions (PRIVILEGE AUDITING) 3. Audit object (OBJEC...

515: Oracle 9i profile management
In】 【Enterprise Manager to create a profile (1) as shown in Figure 8.26. (2) appears as shown in Figure 8.27 to create a summary document】 【General Information tab. (3) as shown in Figure 8.28 to create a summary document】 【Password t...

516: Role in the management of Oracle 9i
Oracle 9i predefined role Table 8.2 Oracle 9i predefined role Role name Description CONNECT The role of the database connection for connecting the database, with the creation of clusters, database links, sequences, synonyms, tables and views, a...

517: The management of Oracle 9i users
Oracle 9i default user Table 8.1 Oracle 9i default the main users of User Name Password Login identification and description sys change_on_install SYSDBA or SYSOPER, but could not log on to NORMAL can be used as the default system administrat...

518: Oracle database system security
Oracle 9i security system 1. Physical layer security Node where the database must be reliable physical protection. 2. User-level security Which users can use the database, what data to use the database object, what kind of authority, such as. 3...

519: Oracle 9i constraints
Constraint is provided by Oracle database system data integrity constraints to the mechanism. Oracle 9i allows the creation of five kinds of constraints. Table 7.8. Create a check constraint (1) management objectives in the 【】 Navigator 7.6, a...

520: Oracle 9i view
What is the view View data sheet as if the windows, administrator-defined these "windows" of the location, the user can only view the data he can see. View is not a data table, it is only a number of SQL query collection is in accordance ...


Page 26 of 37
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]   [33]   [34]   [35]   [36]   [37]