Oracle

Hands-On series: (ii) This article describes in detail the Oracle RAC installation configuration process, and today this article documents the author's detailed installation database based on the previously built Oracle RAC cluster environment. Here'

Main functions: Uppercase and lowercase conversion functions Get substring function (string intercept) Get string length function String Join function Remove substring function Character substitution functions First,

Resolve Oracle Database Ora-00054:resource busy and acquire with NOWAIT specified errorWhen I use the PL/SQL Developer client call stored procedure to find a halfway card machine and then force termination of PL/SQL developer, Oracle has been locked

dbms_utility. Format_error_backtrace : Returns the description of the current exception, which allows you to know where the exception was originally generated.The system sets a stack for the last generated exception and tracks its delivery, which

--Query The department number of the highest average salary departmentSelect Deptno,avg_sal from(select Deptno,avg (SAL) avg_sal from EMP Group by Deptno)-as a table, no table can bewhere avg_sal =(select Max (avg_sal) from (select Deptno,avg (SAL)

For rownum It is the number of the Oracle system order assigned to the rows returned from the query, the first row returned is assigned 1, the second row is 2, and so on, this pseudo field can be used to limit the total number of rows returned by

Http://www.sqlpanda.com/2013/07/learning-note-sql-server-vs.htmlThis is my Learning note base on the "SQL Server Essentials for Oracle DBAs jump Start".DATA Block/extend and

Main documents:http://www.itpub.net/thread-1714191-1-1.htmlOraclehThere are two types of server modesShared modeand theDedicated mode. Dedicated modethe next. Each client sends a connection request. The database is required to create a service

1. TRIM ([{{leading | TRAILING | BOTH}[Trim_character]| Trim_character} from]trim_source) functionReference: Leading assuming that the leading parameter is specified, the Oracle database will remove the opening character regardless of what is equal

Before learning. NET. Previously connected to the database using ODBC, and in Java is usually used in the JDBC Connection database, here is an example of Oracle database for a simple summary of how to use JDBC to connect and manipulate the database.1

This SQL can be used to query a table for a specific location in the record--Query method gets pagination of the statement select *from --Using paging to write stored procedures--1 first to create a package that defines the cursor typeCreate or

Wrote a complex SELECT statement, suddenly Oracle reported: ora-25153 temporary table space is empty, this error, so online check the next. Found an example of the following workaround: Create a new temporary tablespace.First, you have system

In Oracle 11g R1, Oracle introduces some nice enhancements in the form of invisible indexes and virtual fields. Inheriting the former and carrying forward, Oracle 12c introduces the idea of invisible fields. In previous releases, in order to hide

Oracle Database 12CR2 (Project Combat II): Linux system Installation Oracle12.2First, the subject of the course: Wind Brother Oracle Database Tutorial 12CR2 (Project Combat II): Install Oracle12.2 on Linux operating system.Second,

Statement ************************************************************** *********Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise hold the copyright legal responsibility.There are

The main role of spa: The main test is the impact of changes in the system environment including operating system changes, database upgrades, etc. on SQL performance. Minimize the impact of changes in the system environment on the business.Analysis

Timestamp data types in Oracle Many people use very little, so even the simplest query returns the results will not be clear exactly what the time point.For example:2 July-January-08 12.04.35.877000 amWhat time is it? 12:04 noon, that is wrong, in

1, after successful installation into the DOS interface operationYou need to start the Oracle service when you do the following.A, enter the SQL interface: Start-run--cmd: input Sqlplus EnterPrompt to enter the correct user name and passwordB, start

Initial installation of Oracle 12.2 RAC database.Log in to the 1th node in the RAC database$ sqlplus'/as sysdba'SQL> SelectName,open_mode fromv$pdbs;name Open_mode------------------------------ ----------Pdb$seedREAD onlydb12pdb1 mounteddb12pdb2

Tag: Equals line tab SQL statement HTTP return hive SQL developmentOriginal link: http://www.cnblogs.com/juddhu/archive/2012/03/07/2383101.htmlDecode function usage in OracleMeaning explanation:Decode (condition, value 1, return value 1, value 2,