Oracle

Archive mode is very important in the real production environment of Oracle. You can use archive mode for hot backup, and then quickly recover data when a database problem occurs, saving the database. But sometimes the database is built, and it is

How to connect Oracle SQL developer to ms SQL Server 2000: 1. Download the net. SourceForge. JDBC. Driver driver Driver (http://sourceforge.net has download, I downloaded the jtds-1.2.1) 2, extract and copy the jtds-1.2.1.jar to the /lib directory

Oracle select for updateIn most cases, the rows checked by the cursor are modified for the processing completed in the extraction loop. PL/SQL provides a syntax for such processing. This syntax includes two parts: the for update clause in the

The Oracle database provides several different methods for starting and disabling databases. This article describes the differences between these methods and their respective functions.1. For most Oracle DBAs, the most common method to start and

1. dataguard PrincipleOnce standby is created, mongouard will pass the redo of the primary database to the standby database, and then apply redo in standby to synchronize the database. There are two types of standby: Physical standby and logical

OverviewIn the Oracle installation directory $ home/Network/admin, sqlnet is often seen. ora tnsnames. ora listener. ora files except tnsnames. ora, the detailed usage of the other two files is not well understood by many people.Sqlnet. ora is used

Oracle series: Lob large object processing It is mainly used to store database fields with a large amount of data. It can store up to 4 GB of unstructured data.This section describes the storage of character type and binary file type lob data, and

Oracle does not have the date () function. The sysdate function value includes the time, minute, and second. It is really troublesome to insert the default value of the current time. You have to write the stored procedure on your own, and you cannot

Oracle ref cursors Version 10.2: Stronugly Typed Note: A ref cursor that specifies a specific return type. Package Header Create or replace

Oracle's security measures mainly include three aspects: user identification and authentication; authorization and inspection mechanisms; and audit technology (whether to use audit technology can be flexibly selected by users ); in addition, Oracle

Version: 10.1 Sample Database: ORCL mode: hr Understanding of window function:The Window Function specifies the size of the data window used by the analysis function. The size of the data window may change with the change of rows. For example:Order

The term "Myth" refers to the basic situation of Oracle's behaviors that have never been true or have been true, but are not true. The root cause of most Oracle mythology is the result of a technology change. Most people think that many of today's

Let's take a look at the output information of lsnrctl status: Services Summary...Service "PLSExtProc" has 1 instance (s ).Instance "PLSExtProc", status UNKNOWN, has 1 handler (s) for thisService...Service "catadb" has 2 instance (s ).Instance

3. Introduction to lag and lead functions Select area_code, bill_month, local_fare cur_local_fare,Lag (local_fare, 2, 0) over (partition by area_code order by bill_month) pre_local_fare,Lag (local_fare, 1, 0) over (partition by area_code order by

Test environment: OS: XPIn ORACLE 10.1SQLSERVER2000HOSTNAME: home-30b98e1e20Both use the default TCP/IP Port 1. Install the transparent gateway OptionUse Oracle Universal Instraller to choose custom installation on the installed ORACLE_HOME, and

There is an emp table, two fields, employee id and supervisor id. 1, emp_id, 2, manager_idIf you have the following information, an employee can correspond to one or more supervisor IDs, that is, an employee may have several supervisors.Emp_id

Convert to long: Select (FIRSTARRIVALTIME-to_date ('1970-01-01 00:00:00 ', 'yyyy-mm-dd hh24: mi: ss') * 24*60*60 from ats_plat_time_info; Select (sysdate-to_date ('1970-01-01 00:00:00 ', 'yyyy-mm-dd hh24: mi: ss') * 24*60*60 from dual; Convert

The shutdown command has four parameters: NORMAL, TRANSACTIONAL, IMMEDIATE, and ABORT. If no parameter is specified by default, the value is NORMAL. Shutdown normal: do not allow new connections, wait for the session to end, wait for the transaction

Http://blog.csdn.net/rookie_one/archive/2006/11/30/1421781.aspx   When I got off work yesterday, I thought my computer name was too ugly and I changed it to something else. (It was too hasty to install the system. The installer added a lot of messy

-Oracle databases are heavyweight, and their management is very complicated. Sort out the steps for starting and disabling Oracle databases on the linux platform.After installing oracle, you must create an oracle system user,Add several environment