Tutorials to .com

Tutorials to .com » Database » Oracle » Oracle Tutorial

Oracle Tutorial Articles


401: Oracle 9i how to customize the integrated management of the environment
5.1.1 Node 1. HTTP server Oracle 9i database server software is installed, if in accordance with the】 【typical configuration, will be on the same physical computer to install a built-in Apache 1.3 Web server, also known as the HTTP server. 2....

402: Using SQL to update data
Update data using a command】 【update. 4.8.1 Direct Assignment Update 1. Grammar update data table 1 = field names set a new assignment, field names 2 = a new assignment, ... ... where conditions 2. Examples of In order to edit areas】

403: Delete data using SQL
Use 【】 delete command can delete data, use 【】 command truncate the whole table can be deleted while retaining the structure of data. 4.7.1 the deletion of records In order to edit areas】 【enter "delete from scott.test where empno&...

404: Input data with SQL
The use of data entry】 【insert statement. Entry corresponding to different ways】 【insert statement to change the syntax. 4.6.1 single record entry 1. Grammar data insert into table (field names 1, Field Name 2, ... ...) values (the value ...

405: To function with SQL query
Oracle 9i provides a lot of auxiliary functions can be used to query data. Next, we introduce a function of commonly used functions and how to use. 4.5.1】 【ceil function In order to edit areas】 【enter "select mgr, mgr/100, ceil (mgr/1...

406: Using SQL for nested queries
In select query can be embedded in select query is called nested queries. Some books will be referred to as embedded subquery select statement, the result of subquery form has become the parent query. Subquery can be nested multi-level, sub-query o...

407: Multi-table with SQL query
The so-called multi-table query is relative in terms of a single table, multiple data from table to query the data, where we learn from how the two data tables in query data. 4.3.1 unconditional multi-table query Unconditional multi-table query is...

408: Single table with SQL query
Single-table query is relative in terms of multi-table query that data from one table to query the data. 4.2.1 records of all inquiries In order to edit areas】 【implementation of the importation of "select * from scott.emp", and then...

409: SQL Overview
What is the 4.1.1 SQL SQL (Structured Query Language, translated into Structured Query Language) in the relational database on the status of English as if standing in the world. It is the database system of the common language, use it, users can us...

410: Oracle 9i server start-up service
3.6.1 server started six kinds of ways Oracle 9i database server to start the six kinds of ways, such as shown in Table 3.3. Table 3.3 Server launched six kinds of ways Way Features Normal start Boot loader and open the database, users can eng...

411: Oracle 9i server shut down
3.5.1 the server shut down the process of Routine closure of the database system will be completed when the following steps. 1. The first phase of Oracle will re-implementation of the contents of the buffer zone in the re-write the implementation...

412: Oracle 9i the use of management tools
3.4.1】 【Use SQL Plus (1) as shown in Figure 3.12】 【registration interface. (2) after a successful database connection, as shown in Figure 3.13】 【SQL Plus interface. (3) Enter the query "select * from scott.emp;" (under the u...

413: Management of Oracle 9i users
3.3.1】 【system users 1. User Password 【】 User system default password is "manager". 2. User Rights 】 【System users with "SYSDBA" privileges, that is, the database administrator privileges, including. Open the dat...

414: Oracle 9i server configuration 【Management】
【Management】 is the Oracle 9i server installation CD to install a separate component. 3.2.1 Environment configuration Here are the installation of the writer how to configure environment】 【Management Server, configure the following environ...

415: Oracle 9i management mode
3.1.1 Direct management model 】 【Enterprise Manager of the principle of direct management as shown in Figure 3.1, a total of 3-layer structure. 1. The management of client In the management of the client installed】 【Enterprise Manager, En...

416: Oracle 9i database server architecture
2.4.1 Process Structure Oracle 9i network environment there are two major categories of the process. 1. User process User process is running on the client process memory, such as the client running on SQL Plus 【】, 【】, such as Enterprise M...

417: Server and client is how to connect the
2.3.1 server how to connect client (1) appears as shown in Figure 2.34】 【Welcome to the interface. (2) appears as shown in Figure 2.35 【listener configuration, monitoring procedures】 interface. (3) appears as shown in Figure 2.36 【liste...

418: Client Setup Manager
2.2.1 Installation Steps (1) appears as shown in Figure 2.19 can be used 【Products】 interface. (2) appears as shown in Figure 2.20】 【installation type interface. (3) appeared similar with the server installed Abstract interface. (4) In t...

419: Oracle 9i database server installation
Oracle 9i introduced in this chapter two main types of network components - the database management server and client installation and configuration process. The purpose of this chapter is to help readers grasp how to install Oracle 9i and Oracle 9i...

420: Oracle 9i for the two working model
1.5.1 Client / Server mode 1.5.2 Browser / Server mode ...


Page 21 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]