Oracle database manipulation skill set

The ORACLE tutorial you are looking at is :Oracle database manipulation tips set. When it comes to databases, the first company that comes to mind is usually Oracle (oracle). Oracle has been leading the way in database 1. Oracle relational database system is a popular relational database management system in the world at present. It has good portability, easy to use and strong functions. It is suitable for all kinds of large, medium, small and microcomputer environments. Oracle9i is the latest database product officially launched by Oracle in June this year. Oracle9i has a strong track record in scalability, reliability, and integrity, and was approved by developers as soon as it was released. It is a high efficiency, reliability and high throughput database solution. This topic brings together many ORACLE skills and examples for the reference of ORACLE fans.


Primary article

I didn't introduce the SQL language in this project, because I think it is the most basic. If you don't know SQL, then this project is of little significance to you. You can read our related articles first.

* Oracle8i vs. Microsoft SQL Server7.0

* faqs and troubleshooting for Oracle database application development

* Oracle 9i product documentation

* three questions for Oracle Index

* the name change of the table foreign key in the Oracle system

* automatically backup the Oracle database

Improve the paper

After a preliminary understanding of the Oracle database, the following articles can help you master the database one step further.

* analysis and resolution of common error codes of ORACLE

* Oracle database management script naming specification

* use and maintenance of Oracle database password files

* Oracle database system experience 6

* why don't databases sometimes use indexes to find data?

* deep understanding of Oracle database startup and shutdown

* Oracle 8i character set problem analysis and its solution

Senior post

Database management and maintenance after the establishment of the database is the main work of the database administrator, so how to manage and maintain the Oracle database is a technology that must be mastered.

* Oracle database space management tips

* rollback segment concept, usage and planning and problem solving

* how do I determine duplicate records in an Oracle database table

* Oracle constraint management script

* Oracle compare and analyze scripts between different databases

* Oracle database security policy

* how to transplant MSSQL7.0, Sysbase, Access to Oracle8i