Oracle

I have posted an article about upgrading Oracle9i to Oracle10g on the Internet. I will share it with you here. A simple version of transport tablespace was upgraded to Oracle10g. Of course there will be more ways to upgrade Oracle10g. The following

Oracle Data Import and Export imp/exp are actually very similar to Oracle data restoration and backup. The exp command can export related data from the remote database server to a local dmp file. The imp command can import the dmp file from the

The following articles mainly introduce how to use Java to access Oracle exceptions through JDBC. We all know that Java accesses Oracle exceptions through JDBC often cause a lot of inconvenience in actual operation, the following article describes

The following articles mainly talk about external identity authentication for Oracle databases, mainly through the use of the operating system on the server for verification, to use the operating system on the server, we need to configure SQLNET.

The following articles mainly introduce the comparison between Oracle databases and Access, SQL Server, and common applications. I made a product in a company, access, SQL Server, and Oracle databases are required. Some general statements should be

The following articles mainly describe the actual operations of the Oracle database on user-related access control. The following articles describe the second volume of introduction to Oracle 9i SQL student guide, after writing, you can find that

Http://database.51cto.com/art/200#/12457.htmthe internal analysis principle of the Oracle database during the execution of Oracle SQL statements, that is, when a user submits an Oracle SQL expression for the first time, Oracle implements Hard parse

We all know that in the actual application system of Oracle databases, if some users want to log on to the Oracle database as privileged users, they can use two authentication methods, use the authentication integrated with the operating system or

The following article mainly introduces the reason why Oracle 10g is fully uninstalled in Windows XP and Oracle 10g is widely used in a short period of time, this is also because of its unique features. The following is a description of the specific

To import the actual application data of Access to the Oracle database, first open the Access database and select the table you want to import, after the table name and column name are rewritten to uppercase letters and imported into the Oracle

The following articles mainly introduce the reason why Oracle users are locked and the actual solution. I saw the reason why Oracle users were locked and the actual solution materials on the relevant website two days ago, let's share it with you. I

It can be said that 3PAR's streamlined configuration technology was born mainly to improve the efficiency of Oracle databases. On September April 19, 3PAR, the world's leading public storage vendor, announced that, for the first time, 3PAR and

The following articles mainly describe the Oracle Security Policy in the MIS system instance, because there are three different methods for Oracle database backup, each of which has different recovery features, therefore, database and file system

Today, we will introduce Oracle data integration solutions and actual intelligence that focuses on real-time business. If you are interested in the actual operations, the following articles will satisfy your curiosity about Oracle data integration

The default date output operations in Oracle struts2 do not match our Chinese daily output habits. the following describes how to correctly format the date output in struts2. We hope you will have a better understanding of the default date output in

The following articles mainly introduce the large recovery of the Oracle database caused by an incorrect operation. I checked dbms_backup_restore.zerodbid (0) in the script for creating a 10 Gb manual database in Oracle two days ago, the main

Using ORACLE functions can implement many of the functions we need. The following describes how to use ORACLE functions to query by the first letter of Chinese characters and pinyin. If you are interested in using ORACLE functions, take a look. List

As one of the Oracle functions, the Oracle decode function plays a very important role in the Oracle database. The following describes the usage of the Oracle decode function for your reference. We all know that the Oracle function library provides

Oracle backup policy customization is related to the running of oracle databases. The correct oracle backup policy not only ensures the 24x7 High Performance of database servers, it also ensures the speed and reliability of backup and

I believe everyone is familiar with the method for connecting to the oracle database using java. The following describes how to connect to the oracle database using the oracle stored procedure without return values for your reference. Oracle stored