Oracle

Problem: a project is being developed today. It requires that when the slave block is saved, the field data of the master block changes and is saved to the database. Originally, it was assigned a value from the pre-insert trigger of the block. The

Note: use single-step debugging to identify errorsProgramStatement XXX dynamic link library not registered (The dynamic link library file is not registered or the class library of this method does not exist) the object settings are not referenced

An example of a simple Oracle function returning an array [zz] Create or replace type t_ret_table is table of varchar2 (20 ); Create or replace function f_test (var_num in integer) return t_ret_table isVar_out t_ret_table;BeginVar_out: =

In csdn, it helps others write a simple trigger to update data, which involves several problems.   Create or replace trigger tri_aAfter insertOn test11DeclarePragma autonomous_transaction; ---- after declare) indicates free transaction

It seems that some people still do not understand the true meaning of Schema. Now I have sorted it out again, hoping to help you. Let's take a look at their definition:ASchemaIs a collection of database objects (used by a user .).Schema objectsAre

Oracle has two time types: Date and timestamp. Date, accurate to seconds, and timestamp to milliseconds.   1. Calculate the time difference of the date type   You can set the year, month, day, hour, minute, and second first.Use the to_char

Oracle databases have two backup methods. The first type is physical backup. This method enables complete database recovery, but the database must run in the recovery mode (the business database runs in the non-recovery mode ), this method requires

Optimizer for PL/SQL statement execution in Oracle databases, including cost-based optimizer (CBO) and rule-based optimizer (RBO ). The RBO optimization method depends on a set of strict syntax rules, as long as the statements written according to

-- Varchar, varchar2 Contact:1. varchar/varchar2 is used to store variable-length stringsFor example, if varchar (20) is saved to the string 'abc', this field occupies only 3 bytes in the database, not 20 bytes.2. The maximum value of size is 4000,

The following problems occur during website publishing: Symptom: After a website is published, the system prompts that an oracle higher version of support error is required when logging on to the system. In this case, you need to modify the folder

Sys_connect_by_path Function Since Oracle 9i, you can use the sys_connect_by_path function to display the content from the parent node to the current row in the form of a "path" or a list of hierarchical elements. For example:Column path format

Rmthost ValidExtract Use the rmthost parameterto: ● Identifya remote system to which the local extract process connects ● Specifythe TCP/IP Port number on that system where the manager process is running ● Controlvarious attributes of the TCP/IP

When you install an application that contains thousands of tables and indexes, if each table and index is initially allocated a 10 MB initialExtent. You will soon realize that if each object needs to allocate 10 MB of disk space during creation, it

Due to project requirements, the company needs to migrate the database of some projects to Oracle, and almost all of them use sqlserver. Suddenly, 2 ~ Three years of experience in SQL Server development and use has not actually brought me much

--------------------- The following is the Oracle database ----------------------------- SQL statement Optimization Methods: 30 examples We often use hint in the SQL statement optimization process. Here we summarize the common Oracle hint usage in

1. to speed up sub-startup, after oracle is installed, set oracleservice [Sid] to manual startup (SID is the name of the database instance) under the management tool-service ), in this way, the Oracle service will not be automatically started after

The listener. ora, sqlnet. ora, and tnsnames. ora configuration files are all stored in the $ ORACLE_HOME/Network/Admin directory. 1. sqlnet. ora ----- is similar to the nsswitch. conf file of Linux or other UNIX. It is used to determine how to find

Installing Oracle 9ir2 on RHEL as 3 step-by-step By fenng Installing Oracle 9ir2 on Red Hat Enterprise Linux Advanced Server 3 (RHEL 3) Red Hat, the world's largest Linux vendor, recently released Red Hat Enterprise Linux 3. The version number is

I. Case Study　　 A database has two tables about employee information, salary, and department information of a company. They are EMP and dept tables. The structure of the two tables is as follows: 　　 The requirements are as follows: 　　 1. Create a

1 .. sqlplus operation 1. query all tables in a database -- "selec * From tab;2. Set pagesize 30;3. Set the number of lines displayed in each row to set linesize 300;4. Switch the user's conn user name [sys]/password [as sysdba/sys];5. view the