Oracle

In the development of data integration, it is often necessary to create views for each other so that they can view some of the necessary data. Create a user in the database and assign permissions to the user to query the viewFirst, SQL

After the Accept agreement, right-click F12, download the zip file with thunder. The following links are detailed steps.http://blog.csdn.net/wanghaiping1993/article/details/52287722Installation steps for

1. Check if the primary and standby node archive logs are one to(1). Archive logs for primary nodessql> archive log list;Database Log Mode Archive modeAutomatic Archival EnabledArchive destination/u01/oradata/tong/archiveOldest online log sequence 11

/*merge into detailed introductionThe merge statement is a new syntax for merging the UPDATE and INSERT statements oracle9i.With the merge statement, another table is queried based on the join criteria of one table or subquery,The connection

Oracle has never used anything. Oracle PL/SQL also completes the configuration with the help of others.This time the computer re-installed, self-fix summed up the next how to configure.1. Download the Oracle client.The installed version is

Method one: Offline table space1, offline table space: Alter tablespace tablespace_name offline;2, copy the data file to the new directory;3, rename Modify the table space, and modify the control file;4, online table space;1. Offline table Space

Then the previous one, do the configuration of memory, do a good job of documentation, start the implementation of file planningThe system has 5 disks, due to redo log files, archive files, data files have obvious IO competition. Document Planning

A. PL/SQL Developer tools generally import and export to Oracle in the following 4 ways: 1, Oracle Export Import methodIn this way, export the file format that is imported as. DMP, which is binary, can be cross-platform, can also contain permissions,

1. static sqlsql and dynamic SQLThe Oracle compiled PL/SQL program block is divided into two types: one for the pre-assembly (early binding), that is, the SQL statement is determined during program compilation, most of the compilation is of this

Problems encountered during installation:1. When creating an Oracle user, it is best to specify the home directory, the general is/opt/oracle, the default/home/oracle is also possible.2. In the "Add host name and IP address corresponding" step, be

1. Knowledge of UnionSelect one from Dualunion select one from dualAndSelect one from Dualunion allselect one from dualThe effect of union is to merge query results all to keep duplicate rows2. Knowledge of ORDER BY2.1 Select T.*fromorderby1,2--Sort

Solution 1 (actual measurement possible):SYS and SYSTEM user's username and password remember? TryIf not, log on locally with Sqlplus on the server%sqlplus/as SYSDBASql>alter user system identified by Oracle;Then use the system user name, password

NAVICAT Direct Connect Oracle Database error ORA-12737 Instant Client light:unsupported Server character set ZHS16GBK use Navicat to connect to Oracle database today reported the following error: "ORA-12737 Instant client light:unsupported server

Transfer from http://blog.itpub.net/12272958/viewspace-696834/Have always wanted to summarize Oracle memory tuning knowledge, recently just optimize a database memory parameters, find some data and Google a lot of. Now log it down and make a backup.

(i) in the process of using Oracle, we often encounter a number of Oracle errors, for beginners, these errors may be a little vague, and may not know how to handle the resulting errors, I use the more frequent error code one by one to make analysis,

A: Because the Oracle database it can store bytes or characters, for example char (a byte) char (A. Char), the meaning is different. In general, the default is to store bytes, and you can view the values of the database parameter

RPM-IVH http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-7.noarch.rpmRPM-IVH http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpmRPM--import/etc/pki/rpm-gpg/rpm-gpg-key-epel-6Yum Install RlwrapSu-oracleecho

The original in this pokeRegexp_instr6 parametersThe first one is the string enteredThe second one is the regular expressionThe third is to identify a regular expression match starting from the first few characters. (Default is 1)The fourth one is

Oracle database, data increment, delete, change, check, through SQL statement implementationSQL: Structured Query language;Features: Case-insensitive, string enclosed in single quotation marks, end of statement end with semicolon;Line comment, add "-

Oracle's use of the SUBSTR functionGets the string substr (string, start_position, [length]) that specifies the starting position and length in the stringSuch as:SUBSTR (' This was a test ', 6, 2) would return ' is 'SUBSTR (' This was a test ', 6)