Oracle

1 Introduction ORACLE Database is a large relational database that can store terabytes of data. Therefore, it is especially important to ensure the security of such data. We started using the ORACLE database in 1991, over the years, we have

Method for returning an array from an oracle stored procedure: 1. Create a package Create or replace package test is TYPE filename_array is table of varchar2 (1 ); Filename filename_array; End test; 2. Create a stored procedure Create or replace

Oracle DatabaseIt is a database system that is widely used. It is also very important in the database industry. It is necessary for future development to master the operation and use of Oracle databases, this article describes in detail the

Steps for upgrading the ORACLE database: I. Back up ORACLE databases 2. Confirm the installation path of the Home directory of the ORACLE database 3. Shut down the database: SQLPLUS/NOLOG CONN/AS SYSDBA SHUTDOWN IMMEDIATE Stop all ORACLE running

The following is a detailed explanation.Oracle Database field attributesModification method. We hope that the content involved in this article will be helpful to you. Rename the database field: Alter table table_name rename column old_name to

Is DUAL a real table or is the optimizer specially processing DUAL references? Conclusion: It is a real table. See the following analysis. At the same time, according to the database creation script $ ORACLE_HOME/RDBMS/ADMIN/dcore. bsq, the

The operating system is Windows 7 Enterprise X64 and the Oracle 10g X64 client is installed,PLSQL DeveloperConnectionOracle 10g X64. The following error is reported: [Window Title]     (Not logged on)     [Content]    

Oracle DatabaseOfRecursive queryIt is widely used. For recursive queries, we must first define the recursive function, its parameters and return values, and then implement the query. This article introduces this process through an example of code.

In useASPWhen developing an application, the database used isOracle DatabaseAfter writing the connection string code, debug it in the browser, but an error occurs. The error description is as follows: ADODB. Connection error '800a0e7a 'no provider

We know that database connection operations are essential and important for us to operate databases. This article mainly introducesOracle DatabaseOfDBLINK operationThe summary of the command is here to share with you for your reference. Next we will

WhenOracle data tableWhen there are many records, in order to improve the query efficiency, we oftenCreate an indexIn this way, the query speed can be greatly improved during the query. This article introduces the process of creating an index in the

InOracle DatabaseAn error occurred while logging on to the Oracle account.Account locked frequently. What are the causes of this fault? This article introduces this process and finds the cause of the fault through gradual troubleshooting. Next,

OracleThe database has three processes:User Process,Server ProcessAndBackground Process. What are their functions? Next we will introduce them one by one. User Process runs on the client and is not on the database server. Of course, if you run the

InOracle DatabaseIn, sometimes we may encounter such a term:ASHAndAWRHow are they produced? What are their functions? This article introduces this part. Before 1.10g A user's connection will generate a session, and the current session record will be

Oracle DatabaseOfTree QueryIs what we will introduce in this article, including the basic syntax of tree query, the construction environment,Root NodeTraversalSubnodeAnd trace the child nodes to the root node. Let's take a look at this part. Basic

Oracle 10gInLogmnrIn Oracle9i, The Logmnr tool is a good measure for DBAs to retrieve excluded data. Logmnr can be used to complete the following tasks: 1. Identify the database change registration, which may be a change analysis. If some users

Oracle 11g Recycle BinThe use of (recyclebin) is the content we will introduce in this article. We know that Flashback is based on the content in the undo segment. Therefore, restricted by the undo_retenton parameter, flashback features should be

Oracle regexp_likeThe knowledge and examples are the main content we will introduce in this article. First, let's take a look at the Oracle SupportRegular ExpressionMainly include the following four functions: 1. REGEXP_LIKE: similar to LIKE. 2.

AboutEnvironment Variable NLS_DATE_FORMATOne point of definition is what we will introduce in this article.OracleIn database operations, the most frequently used Oracle client tool is PL/SQL Developer. When you use this client to write PL/SQL

OracleHow to Create a databaseDatabase LinkWhat about it? This article mainly introduces this part. There are two ways to create a Database Link in Oracle Database: menu and SQL. Create A dblink named dblink_name, which is connected from database A