Oracle

Original Address--http://blog.csdn.net/qq525099302/article/details/47253351 Create or replace function Generate_coupons_code (v_length in number : = +) return varchar2 is V_code varchar2 ();Type T_arr is Varray of VARCHAR2 (1); Char_arr T_arr;

Background: Oracle services are installed on the server and others use PL/SQL remote connections.It is well known that because the Oracle database is too large to be installed on this machine will cause the computer very card, very affect the daily

On the background of optimization of real-time databaseAbout 168 heat exchange station units, each set of nearly 400 points, the overall more than 60,000 points need to be updated in real time. In the database there is a monitoring parameter table

Synonyms in Oracle:Summary: In simple words, the tables of different users in Oracle are generally only available to their own users, and if you do not want to authorize other users to use them in an authorized way, then create the table with the

Create or replace trigger Tri_fc83_insert before INSERT on FC83 for each ROWdeclare PRAGMA autonomous_ TRANSACTION; BEGIN :new'1'; from fc83 where afc001 =:new. afc001 =:newafa031 =: Newafc210; commit; END Tri_fc83_insert;Oracle

LessonaimWhile retrieving data from the database, you may need to restrict the rows of data that is displayed or specify The order in which the rows is displayed.This lesson explains the SQL statements, Youuse to perform these actions.? filter rows

Today is 2014.05.26, parting N continues to use the long-present blog. The deal has been busy. Recently, this article plus the home network has not paid dues, I began to become less secure. Learning is a need to calm emotions, the voice of the heart

select * from T_user where user_name like CONCAT ('% ', #{search_name}, '% ') select * from T_user where user_name like '% ' | | #{search_name}| | ' % ' select * from T_user where user_name like CONCAT ('% ', #{search_name}, '% ') select * from

Original Address--http://blog.csdn.net/qq525099302/article/details/47146537--Create a split type (used in the function) Create or replace type Strsplit_type as table of VARCHAR2 ( 4000);--Create a split function Create or replace function strsplit

Create a sequenceCreate sequence TEST--sequence nameMinValue 1--Defines the minimum value that the sequence generator can produce. Option Nomaxvalue is the default option, which means there is no minimum definition, and for a descending sequence,

See an unexpected error in the execution plan today on the newly installed oracle11g:sp2-0618: Unable to find the session identifier. Enable check plustrace role sp2-0611: Error enabling STATISTICS Report solution: Execute this file in Oracle in

1, default automatically check my Objects by default, plsql developer login, Brower will select all Objects, if you are logged in the user is a DBA, to expand the tables directory, the normal situation will need to wait a few seconds, and choose my

Yesterday I installed Oracle, today try automatic Backup, I installed Linux and Oracle These two days is the purpose of this.In the case of SQL Server, regular backups can be done with SQL Server Management Studio, which is convenient. But to do

4-2 1 Morning See 40:40This statement , can not be used in production environment , because there are only one variable , the company has a lot of people , not enough . Solve with Loopswhere============================================================

Constraint: Used to maintain data integrity and prevent invalid data from entering the database.The 5 constraints provided in the Oracle database are defined as a combination of a column or a column.1. PRIMARY KEY constraint (PRIMARY key): A single

PL/SQL Developer is an integrated development environment that specializes in developing applications for Oracle databases. PL/SQL is also a programming language called the procedural SQL language (procedural language/sql), which is an extension of

How Java passes a list to an Oracle stored procedure, as in the following example:An array of PL/SQL is built on the database side.CREATE OR REPLACE TYPE Tables_array as Varray (+) of VARCHAR2 (+);d ROP table Test purge;create table Test ( name

ORA-16014 and ORA-00312 Scenario: SQL> alter system archive log current;Alter system archive log current*Row 3 has an error:ORA-16014: log 2 sequence #34 Unarchived, no available destinationORA-00312: Online log 2 thread 1: '+ DATA_DG/orcl/onlinelog/

Profile_oracle setting a User Password Never Expires Setting a user password in oracle never expires   Set the password for the ETL_TEST user to never expire. Select * from dba_users where username = 'etl _ test '; View the dba_users dictionary to

The kill table session in the lock_rac environment appears in the killed status (solved)   Killed state processing occurs in the session of the rac production database kill the lock table   Environment: Operating System: CentOS 6.4 64BIT Database: