Oracle

When multiple stored procedures in Oracle use public constants, we can create a dedicated package to manage all constants. The definition example is roughly as follows: Create or replace package global_constant is/* Numeric constants *//* Ratio

ORA-12500: When the service is started, an error is reported in the background, probably because the corresponding database service is not started. ORA-12154: Service name cannot be processed by TNS: Install only one version of the Client1.

Window: IMP must be a DBA user. Therefore, use sysdba to log on and grant the chnlmgr user DBA permission.Grant connect, resource, DBA to chnlmgr;Import allIMP chnlmgr/chnlmgr @ orcl file = tyqk_catalog_data_2013-03-19.dmp full = y ignore = y

A deadlock usually occurs when a resource has a circular dependency. The deadlock on Oracle usually occurs in the circular dependency of "Row-Level Lock: There are records a, B, transaction T1, T2, now T1, T2 concurrent execution of

I often see this problem with my friends on the forum.   Oracle InstallationWhen you start eclipse again, the system prompts that the JVM version is too low and there is no problem before installing oracle. In addition, the JDK installed on this

--------------------------------------------- Export file for user boss1214 ---- Created by user on, 9:34:30 --------------------------------------------- Spool str_sum_ SQL .log PromptPrompt creating type str_sum_objPrompt =PromptCreate or replace

Utl_file.fopen in the file operation package utl_file provided by racle is responsible for opening a file. Utl_file.fopen (location in varchar2, filename in varchar2, open_mode in varchar2) return file_type;Location is the path parameter,Filename

I. Overview Two data providers accessing ORACLE: lmicrosoft. NET Framework data provider for OracleOracle. NET data providers are provided along with. NET Framework 1.1. If you are using. NET Framework 1.0, you will need to download. Net managed

Yan Bin (write to me)Original blog (http://blog.csdn.net/binbinxyz), reprint please indicate the source! Assume that a five-digit number is obtained from the database as the serial number of the business on the current day (unique on the current

In the past few days, using kettle to capture data involves a lot of processing time. Let's take a look at two figures: Kettle is used to capture data without having to obtain the time. For Oracle databases, there are many time-specific functions.

Basically, the syntax used is as follows:A. Obtain the syntax for creating a single table and an indexSet heading off;Set echo off;Set pages 999;Set long 90000;Spool Dept. SQLSelect dbms_metadata.get_ddl ('table', 'dept', 'Scott ') from dual;Select

The content of this article includes: deleting and modifying tables, deleting and modifying fields, deleting and modifying primary keys, foreign keys, unique, non-empty, and default constraints.View All Your tables: Select * From user_tab_comments;

————————————————      Hello World           —————————————————————— create or replace procedure HelloWorld ASbegin insert into MYPROCEDURE(id,name,city,MANAGER)values(1,'ss','ss','ss');end HelloWorld; Stored procedures are generally divided into

Solve the problem that the OEM cannot be opened Emctl start dbconsole Set oracle_sia = xsgj Emctl start dbconsole Set oracle_hostname = localhost Emctl start dbconsole Change the Oracle-> product-> 11.1.0-db_1> gmx-PC_XSCJ name to

1. Storage StructureThe storage structure of Oracle databases is divided into logical and physical storage structures. Figure 3 2. Logical Structure The logical storage structure mainly describes the internal storage structure of Oracle databases,

60. AVG (distinct | all)All indicates the average value for all values, while distinct only calculates the average value for different values.Sqlwks> Create Table table3 (XM varchar (, Sal number (7,2 ));The statement has been processed.Sqlwks>

  This afternoon, I was depressed. I configured Tomcat 6.OracleThe database's JNDI is not easy to use. Later I consulted my master and finally got it ready. After that, I came back and thought about it. I was so careless, I didn't see anything

Oracle inserts data and obtains the ID of the auto-increment sequence. This article describes how to create the auto-increment sequence and how to obtain the corresponding auto-increment ID after inserting the data, as follows: Create Table atable

Create or replace procedure dongjietotable -- create a stored procedure named donjietotableAs -- Define data ZoneCursor c_qydjsx -- defines a cursorIs select nbxh from aqydjsx;Cursor c_sttzqkIs select tznbxh from asttzqk; V_nbxh varchar2 (40); --

InOracleDatabase,SequenceEquivalentSerial numberThe sequence will automatically increase each time it is obtained, and it will usually act on the location where the sequence number needs to be sorted. 　　1. Create Sequence (Note: you need the create