Oracle

SAP, Oracle, and Microsoft are the major ERP vendors in the last decade. When you talk about ERP system implementations, they are blue-chip in this industry. They are the top three of the ERP system. In other words, most people are considering and

First, the numerical function1. MoD (m,n) to find the remainder functionNote: if m or n is null, NULL is returned. If n is 0, the value of M is returnedeg2. Round (M[,n]) roundingIf n has no value, the default is 0, which is equivalent to

1. Backing Up the NON-CDB database2. Close the NON-CDB databasesql> shutdown immediate;3. non-cdb to read-only statussql> Startup Open Read Only4. Create an XML file (created in non-cdb)sql> begin Dbms_pdb.describe (pdb_descr_file='/tmp/test.xml')

For security reasons, the SSH port of the server is modified from the default of 22 in order to 22222When installing RAC, Oracle users trust each other, but they cannot connect directly via SSH, and must add-P 22222 toThis results in a failure to

1. Create a folder resource and forms to store the PLL and forms (mainly used in APSTAND.FMB, APPSTAND.FMB, template.fmb) files;2. Modify the Registration FormHkey_local_machine/software/oracleValue Name: Nls_langValue: American_america.

Today comes into contact with a more interesting question, common to extremely easy to ignore, but inadvertently fell out of the pit and not easy to come out.To create a table:CREATE TABLE Temp_decode (Borrow_type char (1), Borrow_type1 char (2),

I. Modifying table space size Solution to the above problem: by increasing the table space can be resolved as follows:SQL code log in with a DBA user Sqlplus/ as SYSDBA;    execute the following command: SQL > ALTER tablespace

1. Basic article (1) Overview (2) Installation and uninstallation of database server (3) Create a database (4) OEM and Sql*plus 2

This article describes Oracle Analytic function usage, first building the library:SQL code CREATE TABLE earnings --working Money table ( Earnmonth VARCHAR2 (6), --Working month Area VARCHAR2 (a), --working areas Sno Varchar2 (Ten),

One, Oracle installationFirst of all, Oracle service, I am using Oracle 11g, direct download version of the official website, downloaded is: Win64_11gr2_database_1of2.zip, Win64_11gr2_database_ 2of2.zip Two unpacking package, note is to setup.exe

One, snapshot too old example:1. Create a small undo table space, and do not automatically expand.Create undo Tablespace Undo_smallDataFile '/u01/app/oracle/oradata/prod/undo_small01.dbf ' size 2mAutoextend off;2. Let the system use the Undo table

Experimental environmentData source side: HOST1 IP 192.168.199.163Data target side: HOST2 IP 192.168.199.104Both machines are installed http://lqding.blog.51cto.com/9123978/1694971 article describes the installation configuration is good

Create a test account under Oracle, and then follow the steps:1. CREATE TABLE: Stock_prices--Create TABLE Stock_prices (RIC VARCHAR (6) PRIMARY KEY, price number (7,2), UPDATED DATE);2. Insert the test data:--Inserting data insert into stock_prices

This article organizes the concepts and operations of partitioned tables from the following aspects:1. Table space and the concept of partitioned Tables 2. Table partitioning's specific role 3. Table partitioning advantages and disadvantages 4.

Navicat visual create a table, but just can't find! Why is this?select * from user;If we add double quotes to the user, we can findSELECT * from "user";Conclusion:　　1. Oracle tables and fields are case-sensitive. Oracle defaults to uppercase, and if

For Oracle10grac constructs em, originally very easy thing, but it takes a long time to record down. MEMO.First, for example, the following error was reported:[[email protected] admin]$ emca-config dbcontrol dbstarted emca at 9:06:47 amem

The execution plan of SQL actually represents the specific execution steps of the target SQL within the Oracle database, and as a tuning, only know if the execution plan chosen by the optimizer is the best execution plan in the current situation,

Common commands for creating, updating, and deleting MongoDb documentsMongodb is written by C ++. Its name comes from the middle part of the word humongous. From its name, we can see that its ambition lies in the processing of massive data. The

Oracle server connection1 Oracle server two types of Connection Methods Oracle database connection can be divided into two categories, one is local connection, and the other is through network connection. Local connection. As the name implies, the

ADO. Net operations on Oracle databasesI. ADO. net introduction there are a lot of Database Access Technologies, common there are several: Open Database Interconnection (ODBC), Data Access Object (DAO), remote data object (RDO) activeX Data Object