Oracle

In Oracle Database Operations, we sometimes use lock table queries and unlock and kill processes. How do we implement these operations? This article mainly introduces this part. Locked Table queryCodeThere are the following forms: Select count (*)

Query all the elements of a distance from a certain point (that is, the surrounding query) SQL: Select T. objectid, T. comp_type, T. datatype, T. comp_name, T. health_lic, T. shape. sdo_point.x as x, t. shape. sdo_point.y as Y, T. reg_addr, T.

According to foreign media reports, Oracle's acquisition of sun at a price of $7 billion today received EU unconditional approval.This transaction will change the landscape of the technology industry, which means Oracle, the world's second-largest

I. Simple test jobExample of the creation process: 1. Create a job_test table with the field in a date format. SQL> Create Table job_test (a date ); Table created SQL> commit; Commit complete 2. Create a stored procedure. BB inserts data into the

Select substr (memo, (instr (memo, ':',-1,1) + 1) from sfa_order_item where trunc (gmt_modified) = trunc (sysdate) I personally understand some simple subtr usage Substr ('field name', 3) Here it means to extract this field from the third digit

Several well-known result set operation commands have been tested in detail today, and some problems have been found. Suppose we have a table student, which includes the following fields and data: drop table student;create table student(id int

1. Use of DUAL tables Dual is an existing table in Oracle that can be read by any user. It is often used in Select statement blocks without a target table-view the current connected user SQL> select user from dual; USER ------------------------------

Article from [here] // Create a temporary tablespace create temporary tablespace test_temp tempfile 'E:\oracle\product\10.2.0\oradata\testserver\test_temp01.dbf' size 32m autoextend on next 32m maxsize 2048mextent management local; // Create a data

Some problems occurred when using ORACLE in the actual project. The problem is avoided through the work und. I wrote this article to make it easy to use! 1. ORA-01403: no data found-NO DATA FOUND A. Add an exception to handle the exception. Code

Exp nc50/1 inctype = complete file = E: \ data. dmp full = y (export all) Exp nc50/1 file = E: \ data. dmp OWNER = nc50 (export the specified user nc50) Imp nc50/1 @ orcl inctype = complete file = E: \ data. dmp full = Y (import all) Imp nc50/1 @

  In normal project development, the paging stored procedure uses a large number of stored procedures. top is often used in the SQL Server paging stored procedure, and RowNum is often used in Oracle. Now, there is a UserInfo table, where one field

Oracle 9i Server Oracle 9i includes processes, memory structures, files, and other componentsThe Oracle 9i server is composed of an Oracle instance and an Oracle database.An Oracle instance is composed of background processes and memory structures.

Unmount Oracle 9i under XP Keywords: oracle Environment: Windows XP + oracle 9i 1. Stop all Oracle services: Choose Control Panel> Management Tools> services> stop all oracle services.2. Uninstall the program: select the oracle Universal

Reprinted from: http://publish.it168.com/2005/1215/20051215001701.shtml (1) OracleServiceSIDDatabase Service, which automatically starts and stops the database. If a database is installed, its default start type is automatic. The service process is

// Update layer metadataPublic static boolean updateLayerMetadataByID (DataSource ds, String id, String xml) throws SQLException, ClassNotFoundException {Boolean flag = false;Connection con = null;Try {String metadataTableName = DBUtil.

Preface Aside from a few questions, I am a little satisfied with all the series of blog posts. For my own monograph, I will post an Oracle blog every day, and other blog posts will be posted in my spare time. Click Database Configuration

Error: ORA-26041: DATETIME/interval data type conversion error. When a problem occurs, you are running a non-English language environment and loading an Oracle that contains a DATE or DATETIME data type in batches. To avoid this problem, set the

UsingSystem; UsingSystem. Data; UsingSystem. Text; UsingSystem. Windows. Forms; UsingMicrosoft. Office. Interop. Excel; UsingSystem. Data. OleDb; // Reference-com-microsoft excel objects 11.0. NamespaceWindowsApplication5 {

Materialized views are similar to indexes in many aspects: materialized views are used to improve query performance, while materialized views are transparent to applications, adding or deleting materialized views does not affect the correctness and

Calling a stored procedure through a JOB in oracle DB: Create or replace procedure addage Is Begin Insert into test_work_age (work_age_id, work_age_code, work_age_name, created_date) Values (114, '20140901 ',''); End addage; ------------------