Oracle

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

  Oracle Data Dictionary Overview   Data dictionary is an important component of Oracle databases. It is a set of read-only tables used to record database information. The data dictionary contains: Definition of all schema objects in the database

Original article: http://www.cnblogs.com/fjfzhkb/archive/2007/09/03/879807.html Import and Export Oracle Data imp/exp Function: Oracle Data Import/Export imp/exp is equivalent to Oracle data restoration and backup.In most cases, you can use ORACLE

Oracle 10 Gb new feature -- selective compilation Author: Fuyuncat Source: Www.hellodba.com Oracle10g provides a new feature that is very convenient for developers-selective compilation. That is, only part of the code in

The patch file of Oracle 10.2.0.1 has gradually formed a family system. Let's get to know this system now! Major patches released so far include 10.2.0.2, 10.2.0.3, 10.2.0.4, 10.2.0.4.1, 10.2.0.4.2, 10.2.0.4.3, and 10.2.0.5. Previously, stable

Set OperationsSet Operators---- MergeUnion/Union all ---- IntersectionIntersect ----Minus Set Operation Specifications-The select list of the Two Queries must match the number of queries.-The data type of each column in the second query must match

From: http://blog.csdn.net/zhiguo2010/article/details/5737492 In Oracle, the Null String is considered null, and any value compared with null is null. In this way, an exception occurs when comparing two strings. See the following example: DeclareI

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

You can specify the returning statement in the DML Statement of oracle. The use of returning statements can simplify PL/SQL programming in many cases. It is not intended to explain the use of the returning statement (in fact, it is very simple to

Today with PL/SQL to connect to a database old report ora-12541: TNS: No listener error. Solution: Refer to the SQL * Plus User's Guide and reference for more information.[Oracle @ vserever75 ~] $ Sqlplus/nolog SQL * Plus: Release

There are several solutions: the first one. restart the server to fix the listener. log on to the database, sqlplus/As sysdba; SQL> shudownsql> startup # startup start # shutdown to close # LSNRCTL stop to close the service, execute close listener #

Cursor Learning 1. What is a cursor:A cursor is a swimming cursor.Description in the database language: the cursor is the object mapped to the position of a row of data in the result set, with the cursorYou can access any row of data in the result

Choose from csdn http://search.csdn.net/Expert/topic/2280/2280860.xml? Temp = 20179436e-02 comments from jcc0128 in Forum [Delphi + Oracle report solution (1)] Calling the stored procedure of Oracle in Delphi (two types of data with return cursor

Oracle9i introduces the merge command. You can execute the inserts and updates operations on a table in an SQL statement at the same time. the merge command selects rows from one or more data sources to update or inserting to one or more tables. in

Issue: When you create a instance and a database after your install Oracle 10g. You may come into SS following exception in D:/Oracle/product/10.2.0/db_2/bin/sqlnet. Log **************************************** *******************************Fatal

Io OptimizationIn the case of massive data, more than 80% of database performance problems are related to Io, So I/O optimization is an important task throughout the whole process of massive database management.I/O optimization involves a wide range

How to define the cursor typeType ref_type_name is ref cursor [return return_type];Declare cursor variableCursor_name ref_type_name;From the technical bottom layer, the two are the same. Common PLSQL cursor is "static" in definition. While ref

After a long period of learning to create Oracle tablespaces, I would like to share with you that you will certainly have a lot of gains after reading this article. I hope this article will teach you more things. 1. First query free space 1

Recently, considering the usage of temporary tables in the database write stored procedures   It is still unclear how the database is processed, whether it is consistent with the SQL server processing method.   Are there any problems, such as

Write an insert statement today to directly extract the data in a table and insert it into another table. The result syntax is missing. Searching for half a day. It's an idiot. Let's record the found syntax first...Set feedback off;Set pagesize