Tutorials to .com

Tutorials to .com » Database » Oracle Tutorial

Oracle Tutorial Articles


1: Oracle10g's SQL Regular Expression Support
Oracle 8 and Oracle 9i lack of flexibility in SQL Regular Expressions in Oracle 10 g finally been resolved. Oracle database is currently built-in line with the standard POSIX regular expressions. Four new functions are: REGEXP_LIKE, REGEXP_INSTR, R...

2: Oracle10g's SQL Regular Expression Support
Oracle 8 and Oracle 9i lack of flexibility in SQL Regular Expressions in Oracle 10 g finally been resolved. Oracle database is currently built-in line with the standard POSIX regular expressions. Four new functions are: REGEXP_LIKE, REGEXP_INSTR, R...

3: Oracle9i physical memory management
In previous versions of Oracle9i, you can only start when the control of Oracle database using UNIX memory. Oracle provides some INIT.ORA parameters to detect the system global area (system global area, SGA) the size of the RAM. Once started the dat...

4: To calculate the time difference in the Oracle9i
Calculate the time difference is the Oracle DATA data type, a common problem. Oracle supports date calculations, you can create, such as "Date 1 - Date 2" This kind of expression to calculate the time difference between the two dates. Onc...

5: Access non-Oracle files to create the external table
Oracle9i can directly obtain data from the operating system files, and let it look like the same as the database's internal tables. Oracle9i has expanded its interface with the operating system, so let any type of flat file to operate as if thi...

6: Access non-Oracle files to create the external table
Oracle9i can directly obtain data from the operating system files, and let it look like the same as the database's internal tables. Oracle9i has expanded its interface with the operating system, so let any type of flat file to operate as if thi...

7: Optimizing Oracle network configuration
Oracle database in a different geographic been widely used, so we must have professional staff know how to network connections, Oracle how the kind of impact database performance. Oracle provides TNS allows distributed communications in each databas...

8: Oracle9i defined in the view of constraints
In the Oracle9i before the appearance, Oracle views are always from their base form (base tables) in the dynamically generated, and the view can not contain constraints. By hiding all internal tables join operations, Oracle views can simplify comple...

9: Oracle10g Flashback Recovery Area Xiangjie
What is Flash Recovery Area Oracle 10g has a new feature called: Automatic Disk-Based Backup and Recovery (Automatic Disk-Based Backup and Recovery). The basis for achieving the functionality described in the article to be flash recovery area (Flas...

10: Oracle 8i/9i plan to resolve the stability
Oralce8.1 started from, Oracle adds a new characteristic of Stored Outlines, or known as the Plan Stability (plan stability). The characteristics of the three benefits bring. First of all, you can optimize the costs of dealing with a lot of statemen...

11: Oracle database access restriction bypass vulnerability
Systems affected: Oracle Database 9.2.0.0 - 10.2.0.3 Description: BUGTRAQ ID: 17426 Oracle is a large commercial database system. Oracle 9.2.0.0 to 10.2.0.3 version of the base table to allow only the users SELECT permissions to view special inser...

12: Ruby on Rails applications on the Oracle
Rails is a framework to use, but like any technology, it needs to be proficient in a certain period of time. You may of Ruby on Rails has been heard, the new application framework is a tendency to heavy rain and strong wind swept the Web development...

13: Oracle was the early results-oriented strategy
Oracle continued to acquire companies in different products, its applications to continue the rapid growth of business. Oracle's acquisition of these products company, and did not use other companies to integrate products and sales, but the adva...

14: The Oracle built-in security features for php
Most Web applications today require at least some basic security policies. For example, to provide a password-protected content using the Web site administrator back-end only with the website, blogs and personal journals, e-commerce website, corpora...

15: Oracle database mandatory Index
When the where clause of a column using the function, unless the use of this simple index of the technology mandatory, otherwise Oracle optimizer can not use the index in the query. Under normal circumstances, if not used in WHERE clause, such as U...

16: Oracle database mandatory Index
When the where clause of a column using the function, unless the use of this simple index of the technology mandatory, otherwise Oracle optimizer can not use the index in the query. Under normal circumstances, if not used in WHERE clause, such as U...

17: Oracle database connectivity through JDBC
Java Database Connectivity (JDBC) API is a series that allows Java programmers to access the database interface, each interface is not exactly the same developer. For many years in the use of Oracle's JDBC, I have accumulated a lot of skills, th...

18: Oracle 9i database on start-up after the closure of abnormal
Oracle shutdown when a sudden power failure, resulting in the use of sql / plus to start when unable to connect to the database, specifically described as: connection can not permitted, shut in progress.dos :c:\> sqlplus /nolog:sql/plus: Real...

19: Oracle to use RMAN to automatically back up
-- ,。-- :-- 、,。-- : :1.rman_db_all.sh : oracle,rman_db.sh,scp_rman_db_files.sh2.rman_db.sh:rman_db_all.sh,rman.:a.rman(rman_arch_cr_g.sh), b.rman(rman_db_backup_g.sh), 3.scp_rman_db_files.sh:rman_db_all.sh,rman,scp4.OS_ba...

20: Oracle Database log files analysis
First, explain how to analyze that LogMiner Judging from the current situation, analysis of Oracle is the only way to log the use of Oracle's LogMiner provides for, Oracle database, all changes are recorded in the log, but the original log mess...


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