Oracle

CREATE OR REPLACE FUNCTION checkbankcard (P_bankcard in VARCHAR2)Return VARCHAR2--Returns OK when correct, otherwise returns the correct check codeIsCurval number: = 0;Total number: = 0;Everyother number: = 1;V_end number;BEGINIF (P_bankcard is NULL)

1. Establish sequenceCreate sequence Seq_imgMinValue 1MaxValue 21Start with 1Increment by 1NoCacheNocycleOrder 2. Use Sequence.currval error for the first time after establishing sequenceSql> select Seq_img.currval from dual;Select Seq_img.currval

Gets the exception that occurs when the sequence ID is checked to see if the Oracle database table ID field type is number type. If a long is modified to number. About number type: http://www.blogjava.net/caojianhua/archive/2011/01/24/343461.html

Some Oracle processes have been killed, the state is set to "killed", but the locked resources are not released for a long time, sometimes there is no way to restart the database. Now provides a way to solve this problem, which is not killed in

Do not need to keep so much, according to company requirements only need to retain one weeks.1. What is the way to automatically delete the *.log files that were backed up 7 days ago?2. Too many servers, it is not possible to create one by one

--Write a procedure that asks for an employee number and returns the employee's name.Create or Replace procedure Getnamebyno (no in number, name out VARCHAR2) isBeginSelect ename into name from emp where empno = no;End-Enter the department number

Create or Replace Trigger Delete_sxclgc_triAfter delete on WINF_SV_EX_HYBS_SXCLGCFor each rowDECLAREBeginINSERT INTO Winf_sv_editorial_delete

Original link http://www.cnblogs.com/hyzhou/archive/2012/04/12/2444158.htmlOracle Sequence usage sequence is the serial number in Oracle, which automatically increases each time it is taken. Sequence is not related to tables. 1, create Sequence

Problem: In the development of the system, sometimes we want to be able to limit the front page to the database access behavior, such as in the Oracle database, we use a user-created database table structure, package, view, sequence, so a user has

How to use: Set up the ADDM directory below the e-drive and put three files into it addm.cmd,ADDM. sql,myaddm. sql. The user needs to be given two permissions to connect the premises.Grant Select any dictionary to user,-----user for production

Http://www.infoq.com/cn/news/2013/07/Oracle-Removes-getCallerClassAs Java developers, we often ignore @deprecated annotations and continue to use them, even though we know that Oracle will get this tag at some point, but still fantasize that these

This article focuses on managing permissions and roles in the Oracle database. Oracle permissions are divided into system permissions and object permissions .First, System permissions:System permissions are permissions that execute a specific SQL

1. Description1.1 Host Name:Rac1rac21.2Linux Operating System:Rac1 Enterprise-r5-u5-server-x86_64-dvd ( in a position)1.3 Virtual Disk layout:Virtual Disk virtual device node size (GB) Description E:\VM\RAC1\LOCALDISK.VMDK on the virtual disk client

This time system due to a large number of historical data caused by slow application response, it is necessary to do a large number of historical data migration, originally planned to backup the original table as a new table, the scale of the

A learning side of the oralce operation of the experience, step is the pit AH.Cause: A system that has been running for more than 5 years has been slow for customers recently.Understand the operating environment: windows2003 (16G + 4 Core) + JDK (+)

Preface: After installing the Oracle client, SQL Plus and PL/E could not connect to the remote Oracle database, possibly for the following reasons:Connection not on SQL plus:1 Possible causes: Before the Oracle database client was installed and not

Original: How to export an Oracle database from a server to a local Oracle database1. Import the Oracle database on the server to a localExecute the following command in CMD mode:Exp Username1/[email protected] Server-side database file= local hard

Oralce export script command, regular execution, oralce export script command @ Echo off @ echo ========================================== ================== @ Echo automatic backup script for Oracle databases in windows @ Echo 1. The file is

Hibernate Association ing and hibernate Association ing Relationship between entitiesAssociation, aggregation, dependency, combination, inheritance Link Type:One-to-multipleMany-to-oneOne-to-oneMany-to-many   Student table and grade Table: 1 --

Oracle Database lock Table query and unlock ProcessOracle Database lock Table query and unlock ProcessIn Oracle Database Operations, we sometimes use lock table queries and unlock and kill processes. How do we implement these operations? This