Oracle

Despite complaints from many users, Oracle's idea of shutting down the famous oracle Technical Support Portal Metalink does not seem to change. Metalink carries access and services from IT professionals around the world, it has a high position in

To ensure that the Oracle database works normally in archive mode, perform the following settings:: 1. Set the database to archive If the database archive mode is not enabled, the query displays the following information (non-archive mode ): 1.

Sample script: using the additions API with no invoices The following sample script shows how you can use the additions API to test a manual change, when no invoice information is used:   Set serveroutput onDeclare l_trans_rec syntax;

1. Oracle startup and Shutdown1. In a single-host environmentTo start or shut down the Oracle system, you must first switch to the Oracle user, as shown below:Su-OracleA. Start the Oracle SystemOracle> svrmgrlSvrmgr> connect internalSvrmgr>

1. Oracle 11i EBS Oracle 11i EBS divides the system into five major parts, including:Financial application products: General Ledger GL, AR, AP payable, fixed asset FA, cash management ca, project accounting project account, Property Management,

Problems encountered at work: 1. There is a custom dictionary table: mdl_class_js This table stores the names of many other tables (called resource tables). (In the mdl_class_js table, fields: table_name are used to represent these resource

Show parameter service_names select instance_name from v$instance;   Db_name is a real physical name. SERVICE_NAME carries the domain name, because if the two databases do not have the same domain, they can have the same name. The SID is the

In the dedicated connection mode, the server establishes a connection with the client for every client request to connect to the database server. This connection is used to process all requests of the client, until the user actively disconnects or

The toad for Oracle tool was used in further projects. It was easy to use. Although there were too many things stacked on the interface, it felt a little messy, but it was actually quite helpful. After logging on to the database, you can use the

In the past decade, Oracle has become one of the world's most professional databases. For IT experts, it is to ensure that their company's productivity is improved by leveraging the powerful features of oracle. One of the most effective methods is

DBA's responsibilities and daily work responsibilities: 1. Install and upgrade the database server and application tools to build and configure the network environment. 2. Familiar with the storage structure of the database system to predict future

From: http://forums.oracle.com/forums/thread.jspa? Threadid = 386484 & tstart = 0Http://forums.oracle.com/forums/thread.jspa? Threadid = 911710 & tstart = 29 We have an oracle SP that is being called in C #. Now we try to pass a user defined type

 This article is transferred from the ml blog: Http://www.oracledatabase12g.com/archives/oracle%E6%95%B0%E6%8D% AE %E5%BA%93%E5%8D%87%E7%BA%A7%E5%89%8D%E5%BF%85%E8%A6%81%E7%9A%84%E5%87%86%E5%A4%87%E5%B7%A5%E4%BD%9C.html   Oracle Database Upgrade has

First, let's take a look at the official explanation: Oracle provides four different types of JDBC drivers, for use in different deployment scenarios. the 10.1.0 drivers can access Oracle 8.1.7 and higher. while all oracle JDBC drivers are similar,

Install Oracle 10.1.0.3g for Linux in Fedora Core 7 1. system resource requirements (these are all nonsense. Now all configurations can meet this requirement !! Haha) 1,At least1gPhysical memory,The hard disk space is large enough. (You can skip

PL/SQL single-row functions and group functions A function is a program with zero or multiple parameters and a return value. Oracle has a series of built-in functions in SQL, which can be called SQL or PL/SQL statements. functions are mainly divided

-- Reprinted in notes of Zhou chaoyong of the project team Subject:1. Configure table space and various user objects.2. Create a data image from a real-time database to a backup database. Environment: Sun Solaris UNIX 9Oracle 9i Condition: 1. Two

Exception in Oracle 1. Advantages of exceptions 　　 If no exception exists, check whether each command succeeds or fails in the program, as shown in figure Begin Select... -- Check for 'no data found 'Error Select... -- Check for 'no data found

1. What is the Oracle character set? The Oracle character set is a collection of symbols for the interpretation of byte data. It can be divided into different sizes and have an inclusive relationship. ORACLE supports the national language

Http://cwbboy.cnblogs.com/archive/2006/03/22/356017.html You can access a database on the. net platform in the following ways:1. OleDB database access program,2. ODBC Database Access Program,3. proprietary database access programs. For example,