Oracle

The company has two databases in the environment, the version is different, one is 11g R2, the other is 10g R2First, export the database backup file with exp under 11g R2, and find that some of the tables are missing.Originally this part of the

Today in the use of PLSQL query data query a SQL statement, after the execution of what results are not, at first thought that the SQL statement is wrong, because the previous will know to check the table can not have no data, and then went to the

Why is the data generated by Oracle garbled?the installation of the database and the client encoding code inconsistencies will produce garbled, To fix this problem, change the client code to1. select * FROM table;If this is the problem there are

1. What is block corruption:The so-called corrupted data block refers to the block not being used in the recognizable Oracle format, or its contents are internally inconsistent.Typically, corruption is caused by a hardware failure or an operating

Udev is relatively mature compared to Oracle's own asmlib.Article reprinted from: Maclean Liu's personal technology blog [http://www.oracledatabase12g.com/]In we introduced the use of Asmlib as a special design for the Oracle Automatic Storage

The Nls_length_semantics parameter is a byte-and char-two value that is specified for a column that is designed to create char and VARCHAR2 two character types, specifies the length of bytes used, or uses the character length definition, which

Dual is a commonly used table in the development, query this table only returns a row of records, using this feature we can get the system time, in the stored procedure to assign values to variables and so on.Execute Query statement: SELECT * from

2nd. Installation and configuration of Oracle 1.1 knowledge points for learning1. The Oracle database can be successfully installed;2. Understand the role of primary system services in Oracle.2.1 Specific content (emphasis) 2.1.1 IntroductionOracle

-If there is an update, the insertion is implemented with a statement that does not existDROP TABLE t_mg;CREATE TABLE t_mg (Code VARCHAR2 (Ten), NAME VARCHAR2 (10));SELECT * from T_MG;MERGE into T_MG aUSING (SELECT ' The Code ' code, ' the name '

When the Linux system is installed, it will bring its own openjdk1.xx.xx.Uninstalling OPJDKDownload ORACLEJDKInstalling the JDKRun validationSome questionsUninstalling OPJDK Use Java-version if the version is as shown, you need to uninstall

Use of the dual tableDual is an actual table in Oracle that can be read by any user, often in a SELECT statement block without a target table.--View Current connection user select User from dual;--View current date, time select Sysdate from

2.20 y,yyy Returns a comma-separated display of the yearSQLSelect To_char (systimestamp,'y,yyyfrom dual; To_char (Systimestamp,'y,yyy')-----------------------------2,015 2.21 Y/YY/YYY/YYYY Returns the year of the date at the specified

Implementing select Top N in Oracle:Because Oracle does not support the SELECT top statement, it is often used in Oracle with order by and RowNumTo implement the query for select top N.To put it simply, the implementation method is as follows:Select

Interview: Exp/imp logical backup and recovery: Two, storage storage migration: Data files, control files, log files, SPFile to the new machine, and then start the database on the new machine. Third, the use of data Guard migration: four, using Rman

Question Answer:1. Why create a new account using the SYS account.A: Because SYS has DBA authority, and SYS is already in existence after installing Oracle, the password can be entered at random.2. Why not create a user using the SQL language?A: All

Row_number () over (partition by col1 ORDER by col2) indicates that, according to col1 grouping, sorting is based on col2 within the grouping, and the value computed by this function represents the sequential number of each set of internally ordered

First, EXP exportexp itzy/itzy@orcl file=D:\sql-bak\itzy.dmp Log=D:\sql-bak\itzy. Log exp User / password @ instance name file=log= path plus log name Ii. IMP Import1, connect to SYSDBA database Sqlplus "/ asSYSDBA "2, view the currently

Colleague recently in busy data consistency than work, need to different text files in the comparison of data, some files larger, more records, if the ordinary text editor open, it is obvious that will be very card, even can not open.Based on this,

Recently, in the process of learning, found a very interesting function, it can achieve the concatenation of the column values. Let's take a look at its specific usage.Usage:The official documentation for its role is explained below:For a specified

Oracle Stored procedures:Grammar:CREATE [OR REPLACE] PROCEDURE procedure_name(Arg1 [Mode1] datatype1,arg2 [Mode2] datatype2,...)is [as]PL/SQL BLOCK;Mode is used to specify input and output parameters: In for input parameters, out for output