Tutorials to .com

Tutorials to .com » Database » Oracle » Oracle Tutorial

Oracle Tutorial Articles


521: Oracle 9i indexing
Index is the number of data rows of a list of keywords, query data, through the keyword index to quickly locate a record of where to access the data blocks, thus greatly reducing the read data block I / O number, it can significantly improve perform...

522: Oracle 9i to delete data sheet
Data is relatively simple to remove the table, table after the deletion of the space occupied by the system on the release and recovery, the table can not roll back the deletion of the operation. Could be deleted include. The definition of table da...

523: Oracle 9i data sheet cut-off
Cut-off operation of the following SQL syntax. ------------------------------------- TRUNCATE TABLE Username. Table [DROP | REUSE STORAGE] ------------------------------------- Among them, the use of "DROP STORAGE" clause, explicitly s...

524: Data management of table data
Here's how to operate the data in the data table. Data tables to insert data 1. To the instructor to insert the data table (1) as shown in Figure 7.19, select the shortcut menu editor 【Data】 options, there's the interface shown in Fig...

525: Day-to-day management of Oracle DBA
Author: Thomas B. Cox, with Christine Choi Objective: This document had a very detailed record of one or more of the ORACLE database on a daily, monthly, Running the annual state inspection results and the results of the appendix in the document y...

526: Oracle 9I installation notes
Oracle 9I installation notes author: Tansf date: 2004-11-10 A total of three CD-ROM Oracle 9I 1 Global Database Name: tan.eyesomdb SID: tan --- Need to manually enter C: \ oracle \ oradata Global Database Name: tan.eyesomdb SID: tan Globa...

527: Oracle customers across a firewall problem
The recent work in the Windows XP platform Oracle9i database is installed for testing purposes, all normal. However, when the client always connect to a server timeout, I would first think of a firewall, when I open port 1521 to connect the operatio...

528: Modify the oracle data files
Important: ................................ / / Read data file command 1 3.1 adjustment system tablespace oracle to complete the installation, the administrator should be on the system table storage space to adjust the parameters, the main value...

529: oracle9i study notes
Create database ######### ---- look $ ORACLE_HOME / rdbms / admin / buildall.sql ############# maxlogfiles 10 maxdatafiles 1024 maxinstances 2 logfile GROUP 1 ( '/ u01/oradata/db01/log_01_db01.rdo') SIZE 15M, GROUP 2 ( '/ u01/orada...

530: Transfer of Oracle database and upgrade
Recently to be on the shop floor system, the database needs to be transferred from Dongguan, the following is transferred after ... USERS01.DBF CSFIS01.ORA SFIS01.ORA RSFIS02.ORA HSFIS01.ORACINDX01.ORA RINDX01.ORA RINDX02.ORA HINDX01.ORA UNDOTBS2....

531: Oracle's EXP / IMP version supported the list of
EXP / IMP to the use of general EXPORT version, IMPORT and objectives of the use of the IMP the same database tools 10.1.0 9.2.0 9.0.1 8.1.7 8.1.6 8.1.5 8.0.x 7.3.x 10.1.0 EXP10 EXP920 EXP901 EXP817 EXP816 EXP815 N / A N / A 9.2.0 ...

532: Oracle is already outdated
Is Oracle A Legacy Technology? One of the nice things about working with the Oracle RDBMS, compared to say working with technologies such as AS/400, COBOL or mainframes is that it's generally perceived as a "hot" technology. Salary su...

533: Some information on Oracle
Oracle10g set character set Landing in his capacity as sysdba, modify props $ table NLS_CHARACTERSET = ZHS16GBK or the character set they need, and then restart Oracle. ...

534: PHP 5, Oracle, and the Future
by Andi Gutmans Hypertext Preprocessor Version 5) was officially released on July 13, 2004. Not surprising, the release was widely covered by the media due to the leadership role PHP plays in the Web application market. It is true that technologies...

535: In the stored procedure used in ORACLE regular partition table
Oracle database storage of a variety of data, some data tables will be as time goes by, more and more. Friends such as chat logs, Send and receive text messages of the log, the log of production systems, dynamic websites, etc. log system. This info...

536: The use of encryption tools for Oracle Wrap your code
Wrap tools Oracle provides, can be used for encryption, such as your Package. However important to note that after the encryption code can decrypt, you need to keep your source code. create or replace function get_rowid (l_rowid in varchar2) retur...

537: JAVA code to connect Oracle
Up-to-date Oracle has made a code to connect to with a good environment variable: / * * This sample shows how to list all the names from the EMP table * * It uses the JDBC THIN driver. See the same program in the * Oci8 samples directory to see...

538: Reconstruction of the use of Oracle services oradim
Some in the Windows system time, Oracle's database will be successful does not start automatically, but it can be activated manually, and in this case we can try to re-create the Oracle service to see whether the problem can be solved. ...

539: Bank of China on the Oracle database migration / line links the issue of
One, the migration / introduction line link prompt prompt accept table prompt "Enter the table name to check (RETURN for All tables owned by & owner):" prompt prompt set head off serverout on term on feed off veri off echo off !...

540: ORACLE9i the Transparent Gateway to connect SYBASE configuration
ORACLE database connection services to achieve heterogeneous technology called transparent gateway (Transparent Gateway). At present, the use of transparent gateway ORACLE can be achieved and SQL SERVER, SYBASE, DB2 database and other Internet main...


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