Oracle

An overview:1. A pipe function is a function that returns a rowset (capable of making a nested table nested table or array varray), and we can query it like a physical table orassigns a value to the collection variable. 2, the pipeline function for

In Oracle 10g, the Flash back family is divided into the following members:Flashback DatabaseFlashback DropFlashback TableFlashback Query (sub Flashback query,flashback Version query,flashback Transaction query)Here's a look at Flashback Drop and

Sqlplus sys/[email protected]: 1521/CMSX as SysdbaSql*plus:release 11.2.0.1.0 Production on Monday July 21 13:33:13 2014Copyright (c) 1982, Oracle. All rights reserved.Connect to:Oracle Database 11g Enterprise Edition Release

The Decode function is one of the most powerful functions of Oracle PL/SQL, and it is currently available only to Oracle companies, and the SQL implementations of other database vendors do not yet have this function. What is the use of decode? Let's

2 character Functions1. Replace (string 1, String 2, String 3)Replace (char, search_string, replace_string)Function: Search for "String 2" in "String 1" and replace it with "string 3".For example, the following command replaces the "A" that appears

A code block for the basic introduction to PL/SQLPL/sql: Process language (Procedure Language) and structured language (structured Query Language) A combined programming language is an extension to SQL that supports a variety of data types such

EBS system passwords are divided into four categories, and changing passwords requires compliance with regulations, specifications, and, in particular, backups. 1. operating system users, such as Root,ora,appl,grid. "Modify Method"use passwd this

ORA-4031 error. ORA-04031 error is because the continuous memory cannot be allocated, it may be that the shared pool memory fragments are serious, or it may be that the memory is indeed insufficient.The cause of this situation is: frequent and more

When learning about Oracle, you may encounter Oracle object privileges. Here we will introduce the solutions to Oracle object privileges. Here we will share with you. The Oracle Object Privilege allows the authorized user to use the schema object

The following article describes how to access SYBASE-related data in an Oracle database and how to configure the transparent gateway for Sybase, I hope this will help you in your future studies. 1. Install Sybase client on the server where Oracle is

Guide: SynonymIt is an alias for database solution objects and is often used to simplify object access and improve object access security. When using synonyms,Oracle DatabaseTranslate it into the name of the corresponding solution object. Similar to

InWindows 7LowerInstall Oracle database lite 10 GBThe following error occurs after setup.exe is run. The error message is as follows: Checking installer requirements...     Checking operating system version: must be 5.0, 5.1, 5.2 or 6.0.    

OracleThe decode function in the database is one of the common functions of Oracle PL/SQL. What is its purpose? Next we will introduce this process and how to use it.SAS macroTo implement the decode function in the Oracle database. First, let's

Oracle Performance Analysis 1: Enabling SQL tracking and obtaining trace files When there is an issue with Oracle query efficiency, we often need to understand the problem so that we can provide a solution to the problem. Oracle provides the trace

Collect statistics from ORACLE Link: http://blog.itpub.net/2317695/viewspace-1226138/Today, I saw an article on Statistics Collection on the Internet, which is not bad. 1. Understand what is statistical information Optimizer statistics are a set of

Windows sqlplus/assysdba report the ultimate solution of ora-12560Windows sqlplus/as sysdba report the ultimate solution of ora-12560Windows, sqlplus/as sysdba often report ORA-12560: TNS: protocol adapter error, solve this error, there are multiple

  1. Oracle tracking File There are three types of Oracle trace files: one is the background alarm log file, which records the activity of background processes during database startup, shutdown, and running, such as creating tablespaces, creating

The OCR and Voting Disk backups in Oracle RAC are described in my blog: common maintenance tools and commands of Oracle RAC. Now I will explain it separately, because OCR and Voting Disk are too important for the RAC system. Oracle RAC commonly used

Rename the column name and table name in oracle directly in pl/SQL and then in oem, however, you may not be able to change the lower-case table name to the upper-case table name. At this time, www.2cto.com can be changed using SQL statements. In

When rebuild index VS. rebuild index online create index and rebuild index are used, the No. 4 lock will be applied to the original table, and the No. 3 lock will be applied to obj $ to prevent DML operations on the original table. Create index