Oracle

I started this question because a friend on MSN asked me today,What is DSI?.This is the first question. DSI isData Server InternalsIt is an internal teaching material used by Oracle to train Oracle aftersales engineers.Such documents are usually

I read ArticleHe talked about how to import data from SQL Server to the SQL Server compact edition database. What I need now is to replace SQL with an Oracle database, and my Oracle Data is a server. I need to remotely download the data to the

DML triggers are the most common types of triggers, which are used by developers. Other types of triggers are mainly used for database management or audit, while DBA is usually used. 1. Introduction to DML triggers: Before trigger This trigger

1. conversion functionsThe biggest relationship with the date operation is the two conversion functions: to_date (), to_char ()To_date () converts the character type to the date type in a certain format:Specific usage: to_date ('1970-11-27 ',

V $ Database: database information, such as the database name and creation time. V $ instance information, such as Instance name and start time. V $ parameter information, select * from V $ parameter where name like '% name' ----> show parameter

1. Do not use Oracle. JDBC. Driver. The extended JDBC of Oracle is placed in the Oracle. JDBC package. The classes and interfaces described in this package are very similar to the methods described in Java. SQL. I think this should be a kind of

Some code is provided below: C # Need to reference Using system. Data. oracleclient;Using system. Data. sqlclient;   Private void button3_click (Object sender, eventargs e) // import data from sqlserver to Oracle{Button3.enabled = false; // prevent

Psychological preparation:1. when I installed oracle on Linux for the first time, I felt a lot of trouble. As a result, I gave up the first time I didn't install it halfway. Because I was used to the next step on the window interface, it was

SCN is the clock that Oracle hangs on the wall. Get up in the morning, say "Get up SCN"; eat breakfast, name "Breakfast SCN"; go to work, called "Go out SCN ". Any of our activities will correspond to an SCN. We can use an internal Oracle package to

I configured data guard when I had never been familiar with Oracle before. Paid download a detailed configuration document for data guard 11g in Windows (requires a mailbox), but many of the parameters must be modified according to their own

Author: skateWhen a performance bottleneck occurs in the system, try to consume as few unnecessary resources as possible. The last step is to balance CPU, memory, Io, network and other resources so that the databaseIt can run stably. Oracle Database

On the evening of March 13, Beijing time, an astonishing message came: Oracle (Oracle) announced the acquisition of sun for $7.4 billion. This transaction caused many people to be surprised. Previously, IBM and Sun had been involved in merger

  Oracle Aggregate functions has been used a lot. The official website is described as follows:   Aggregate functions Http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions003.htm#SQLRF20035   Aggregatefunctions return a single result row

System Environment: 1. Operating System: Windows 2000 Server 2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition/Oracle 9i for NT Enterprise Edition3. installation path: D: \ oracleSteps:1. manually create related

For a long time, I have been using ms SQL Server/Access database, through. Net Access Ms home things almost never encountered any trouble. Recently, I used oracle as a database in my project. I learned some things about. Net accessing Oracle and

1. Configure the Oracle database connection In the previous article, we have learned how to use Oracle's net configuration assistant to configure database connections. In addition, you can modify the configuration file to connect to the database.

Oracle series: PL/SQL tables 1. What is a PL/SQL table?First, PL/SQL tables and records are of the same composite data type. It can be seen as a user-defined data type.A pl/SQL table is a temporary index table object consisting of scalar values of

SQL statement for data duplication between Oracle and MySQL It can be said that this data is repeated, no matter in development, data maintenance and experience interviews, you should encounter common problems! Here, I also paid special attention to

The following answers are reprinted: I often see some questions about ORACLE character sets. I 'd like to introduce them in an iterative way. First iteration: master the basic concepts of character sets.Some may think that this is an option, but in

Part 4 Performance Adjustment[Q] If you set Automatic Tracing[A] log on to the system and run $ ORACLE_HOME/rdbms/admin/utlxplan. run $ ORACLE_HOME/sqlplus/admin/plustrce to create the SQL schedule. SQL creates a plustrace role. If you want to use a