Before that, I made an oracle call to WebService. Since I had to leave, the company had no one to take over, so I didn't do the solution to call WebService using Oracle. I switched to Java instead, there is no way to call WebService with Oracle, but
Oracle mix is probably equivalent to a website such as Oracle's msdn. Address is http://mix.oracle.com
Developed by Oracle compaction lab and uses jruby on rails. Read this blog: http://oracle?lab.com/2007/11/12/lets-mix /.
In addition,
Recently, SAP archiving and Database Reorganization have just been completed. After the database reorganization, the temporary tablespace is reduced to make reasonable use of resources. The steps are as follows:
1. Create a new temporary tablespace
During project creation, Oracle database migration may occur, and the sequence may be reset. As a result, when the current value of the sequence is smaller than the maximum value of the field in the table using the sequence, an error occurs,
% Rowtype in Oracle:
% Rowtype: indicates that this type is the row data type. It is stored as a row of data. A row has many columns, which is equivalent to a row of data in the table or a row of data in the cursor.
% Rowtype is used to query
There are a lot of Oracle processes in the top process of the IBM p570 dB host. I don't know why, the memory is all eaten, and the CPU idle is 0,
The swap zone is almost used up.
Who, or which program is so powerful? The two computers can be killed.
About arrays in Oracle: record the same setThe set can be implemented in three ways:1. Use varray to customize a type to obtain an array. However, you can only define the basic type as follows:Create type name as varray of varchar2 (20 );
1. Use
1) set whether the current session will automatically submit the modified data: Set auto [Commit] {on | off | Imm [ediate] | n}SQL> set autocommit off
2) When you use the start command to execute an SQL script, whether to display the SQL statement
// Create a spatial field index for Oracle Spatial table// ================================================Drop index index_sp_v_gbjj;Drop index index_sp_v_xzq;Drop index index_sp_v_ytfq;Drop index index_sp_v_dltb;Drop index
Guidance:1. Create a profile file.SQL>Create profile file name limit Failed_login_attempts: The number of Logon failures of the Locked User Password_lock_time: Number of days the user is locked Password_life_time: Password availability
Oracle Data Import currently uses the following two types:
1. Use SQL * loader to import txt or CSV data to Oracle;
2. Create two dblink Oracle databases to export data to each other;
Data Import problems:
1. Oracle dblink access lob field ORA-2299
I. query tables and fields corresponding to foreign keys
1. Use the following SQL statement to query the table corresponding to the foreign key and the field p represents the primary key R represents the foreign keySelect a. constraint_name, A.
Lock concept Basics
A database is a shared resource used by multiple users. When multiple users access data concurrently, multiple transactions can access the same data simultaneously in the database. If concurrent operations are not controlled,
Nls_characterset = zht16mswin950
Nls_nchar_characterset = al16utf16
Select, insert nchar should use N 'hangzhou'
Select * From factest where fac_uname = n' Liu Ke '"
Insert into factest values ('20140901', '20160901', n'hangzhou ')
9i has a
The Oracle query date can use =, but the data types must be consistent on both sides of the equal sign,
For example, '2014-9-19 'is a string that cannot be directly compared with a date field and must undergo date conversion:
Convert date to
Oracle tips by Burleson Consulting
Oracle SGA concepts
The system global area (SGA) is a group of shared memory areas that are dedicated to an oracle instance? (An instance is your database programs and RAM ).
All Oracle processes use the SGA to
MySQL statement Optimization Principles
1. Use indexes to traverse tables faster.
The index created by default is a non-clustered index, but sometimes it is not optimal. In a non-clustered index, data is physically stored on the data page
I have made performance optimization over the past few days and found some information online.
Sometimes you need to export all the table, view, sequence, trigger and other information of a user. The following SQL statement can select the
1 Introduction
The Oracle stream function is designed to improve the high availability of the database. In Oracle 9i and earlier versions, this function is called Advance replication. Oracle stream uses advanced Queue Technology to parse archived
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service