Oracle

To create a data table with a stored procedure: Note that you must add Authid current_user if you create a table that already exists, the stored procedure continues to execute, but if you do not add this key statement, the stored procedure will

Cursors are divided into implicit cursors and display cursors. One, implicit cursorsThere is an implicit cursor attached to the SELECT * into and DML operations (update, delete, insert). Attributes of an implicit cursor Sql%rowcount integer

EXPDP and IMPDP are the newly added export and import capabilities of Oracle starting from 10g. Name is called data pump. Expdp:data Pump ExportImpdp:data Pump Import The difference between EXPDP, IMPDP and exp, imp EXPDP, IMPDP:1, you can import

12.1.0.2 version[Oracle@localhost ~]$ Sqlplus CHF/XIFENFEI@PDB1Sql*plus:release 12.1.0.2.0 Beta on Thu APR 24 21:39:43 2014Copyright (c) 1982, 2014, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition release 12.1.0.2.0-64

Database Current SCN The code is as follows Copy Code Idle> select checkpoint_change# from V$database;checkpoint_change#------------------271743118idle> Shutdown Abort The ORACLE routine has been closed.SCN in

Date field: SQL Server Date field format in the same character field format, that is, a single quotation mark on it, Oracle Date field format is different, it is very wordy, there are only two ways to deal with: A: Add a single quotation mark to

Sequence is a sequence of numbers that the database system automatically increases according to certain rules. This sequence is generally used as the surrogate primary key (because it does not repeat) and has no other meaning. Sequence is the

The basic approach to Oracle performance optimization includes several steps, including: 1 set a reasonable target for Oracle performance optimization. 2 measure and record the current Oracle performance. 3 Determine the current Oracle

Recently learned Oracle to modify the field type method, leaving the record. There is a table named TB with the field segment named name and data type nchar (20). 1, assuming that the field data is empty, no matter what type of field to change,

Trigger-related concepts and syntax Overview This blog post focuses on the following topics: What is a triggerApplication Scenarios for triggersSyntax for triggersTypes of TriggersCase Data: The concept of triggers and the first trigger A

Both date and timestamp are available for addition and subtraction operations.You can manipulate different time types for the current date Gagnin, month, day, hour, minute, and second, with three ways: 1 using built-in functions numtodsinterval add

Mathematics function 1. Absolute value Copy Code code as follows: S:select ABS ( -1) value O:select ABS ( -1) value from dual 2. Rounding (Large) Copy Code code as follows: S:select Ceiling ( -1.001) value

This article illustrates the method of Oracle to implement row and column conversion. Share to everyone for your reference, specific as follows: 1, the row and column conversion of fixed number Such as: Student subject Grade ---------------

Overview Wait events can be divided into two main categories, namely, Idle (IDLE) Wait events and non idle (non-idle) wait events. 1). Idle Wait Event Oracle is waiting for some kind of work, not paying too much attention to this part of the

Configure Flashbash Database Parameters ALTER system SET db_recovery_file_dest= '/dg/fra ';ALTER system SET db_recovery_file_dest_size=10g;ALTER system SET db_flashback_retention_target=1440;ALTER DATABASE flashback on; Primary library to build

Installing oracle in linux is a daunting task. Its complexity far exceeds that of installing the linux operating system. If oracle is successfully installed, some linux technologies are also mastered. This article describes how to install oracle 10

Scenario: when the users table is in insert, update, delete, the changed id is recorded in the users_log table.Create a MySQL triggerTrigger Time: BEFORE, AFTERTrigger Event: INSERT, UPDATE, DELETENEW and OLD Keywords:| Action | NEW | OLD || --------

If our project is to be migrated from Oracle to Mysql, but the instr function of MySQL can only find whether the child string is in the parent string, it cannot be searched according to the number of occurrences.Here I wrote one for migration. Of

Abstract: This article introduces the basic methods for using and maintaining the LOB data type in ORACLE databases through the DBMS_LOB package.Keywords: ORACLE DBMS_LOB LOB maintenanceGraph classification: TP311. IntroductionWith the development