Oracle

Installation tutorials for oracle11g Unzip two zip files simultaneously, generate a database folder, go to the database folder, click Setup Remove the security update option and go directly to the next step

Before you use ODI, you must create a repository. The creation process is as follows:1. Environment variable Setting2. Using RCURCU is a usage program that creates a repository.[email protected]:~$ $ODI_HOME/oracle_common/bin/rcuDefault entry,

1.1. Pl/sql Configuration Tools -> Preferences->oracle-> Connections-> Check the connectionPlsql Configure the method for the four-bit Oracle :http://blog.csdn.net/chen_zw/article/details/9292455/1.2.query statement does not match Chinese

--StartWe all know that numbers can be added, minus, multiply, divide, and so on. So, could the date be? The answer is that the date can only be added, minus operations.Before starting the operation date, let's look at what date data types are

I. BACKGROUNDThe company's business uses the Oracle database, because multiple occurrences of the table space can not be found in time, each time is the business group of Personnel notification processing, so that the DBA side is relatively passive,

I. Installation of the Oracle database (installed in the XP system of the virtual machine)1. Install the virtual machine2. Install the XP system inside the virtual machine, the following steps are made within the virtual machine3. Double-click Setup.

Tossing an afternoon, a few pits, and finally with PL/SQL connected to Oracle, tanning pits experience.First go to the Oracle website 12c, the official website has the login verification, if not registered, first register it. The database

1) ora-01653 error:You can see that inserts with two tables are affected, both in the Users table space. Use the following SQL to view Tablespace usage:SELECTA.tablespace_name "tablespace name", A.bytes/ 1024x768 / 1024x768"Tablespace size (M)",

1: Modify Kernel parameters[Email protected] mnt]# vim/etc/redhat-releaseRed Hat Enterprise Linux Server Release 4 (Tikanga)2: Modify host Name[Email protected] ~]# vim/etc/sysconfig/networkHostname=dba.up.com[Email protected] ~]# vim/etc/hosts192.16

The Count (*) or COUNT (1) or count ([column]) in the database is probably the most commonly used aggregate function. A lot of people actually have a clear distinction between the three. This article will describe the roles, relationships, and

Background:Wave Tissot K1 host. In fact, several categories are divided:k1-950 Intel Itanium CPUk1-930 Intel Itanium CPUk1-910 Intel Itanium CPUk1-800 Intel log strong CPU1th: The first three kinds of models. Because the Itanium CPUis used, if you

PL/SQL single-line functions and group functionsA function is a program that has 0 or more parameters and has a return value. Oracle built a series of functions in SQL that can be called SQL or PLFunctions are divided into two main categories:Single-

The actual project, backup data is an indispensable step, complete the automatic backup of data to reduce the workload of individuals, is our goal. There have been few scripts written before, but these simple operations can be done! Not much to say,

When you create a table. Add a NOT NULL constraint to the column, such as the following:column_name Data_type[constraint constraint_name] NOT NULL, constraint constraint_name indicates the name specified for the constraint.You can also add a NOT

For more information about the use of ORACLE time functions (SYSDATE), oraclesysdate Addition Select sysdate, add_months (sysdate, 12) from dual; -- add 1 year select sysdate, add_months (sysdate, 1) from dual; -- add January select sysdate,

Summary of simple SELECT query statements in SQL, and SQL SELECT query statements -- Scott users cannot use it. Use system to log on-- Modify scott account to unlockAlter user scott account unlock;-- Reset the password identified to be

Plsql Remote Access Database address ora-12541: TNS: the best way to do without listeners, plsqlora-12541 It is strange that the ip address on the local LAN is not fixed. Now all the ip addresses are fixed, and this error is always reported. Baidu

Use the sqlplus command line tool to create users and tablespaces for oracle, sqlplusoracle Creating tablespaces and users and assigning permissions using the Enterprise Manager or PL/SQL graphical method that comes with Oracle10g is relatively

Common oracle knowledge accumulation and oracle knowledge accumulation1. Basic operation 1. Table operation 1.1 copy and create a table Create table test as select * from dept; -- copy data and structure from a known table Create table test as

How can I modify the username and password of the oracle database ?, Oracle Database It is common for students who do not frequently use databases to forget their usernames and passwords. Here we will introduce how to modify the username and