Information security considerations sometimes require data masking for user names.Fetching Data desensitization for Oracle databaseDesensitization rule:The length is less than 9 characters, only the first 3 characters and the last 3 Chinese
The following is an introduction to rownum.======================================3. Use of rownum and row_number () over ()Rownum is a pseudo column provided by Oracle starting from 8. It numbers the SQL results and starts from 1. It is commonly
1. Oracle binary options description
For more information about oracleoptions, see:
Summary of Oracle component series
Http://blog.csdn.net/tianlesoftware/article/details/7339998
We can view the related information through the V $ option
The following error is prompted when installing ORACLE:
[Oracle @ ora10g database] $./runinstaller
Starting Oracle universal installer...
Checking installer requirements...
Checking operating system version: Must beredhat-3, SuSE-9, redhat-4,
SQL * loader is a tool used to import external data from Oracle databases. it is similar to the load tool of DB2, but has more options. It supports variable loading modes, optional loading and multi-Table loading.
How to use SQL * LoaderWe can use
Connecting to the Oracle database and troubleshooting solutions
This article is a summary of my connection to Oracle, especially suitable for program developers and Oracle cainiao.HowConfigurationTo connect the client to the database: To
Tables are divided into system tables and user tables.Database objects
Tables (basic storage objects, composed of rows and columns), views (logical subset data obtained from one or more tables), sequences (unique serial numbers automatically
Install Oracle 10g in Windows 7. The orcale version used is 10 Gb.
Step 1:
Download from the orcale official website, for: http://download.oracle.com/otn/nt/oracle10g/10203/10203_vista_w2k8_x86_production_db.zip
You can directly copy it to thunder
After installing Oracle, start programming with OCI. Vs2008 as a development platform
First, find files such as OCI. dll OCI. h OCI. Lib in the installation directory. Like OpenGL, *. Lib is put under the installation directory of vs2008, Vc \ Lib *.
The Oracle database software provides the following two scripts to configure automatic database startup and shutdown with the server:[Oracle @ prod bin] $ pwd/U01/APP/Oracle/product/11.2.0/db_1/bin[Oracle @ prod bin] $ LS-l DBS *-Rwxr-x --- 1 Oracle
The syntax of the create statement is the same, and the data types are different.
However, the syntax for creating a table using subqueries is different.
SQL Server statements created using subqueries:Select empno, ename, Sal * 12 annsal, hiredate
2.1.1unlike other database products, Oracle has its own unique system architecture. The Oracle system architecture is the framework of the entire ORACLE Server System and the basis and core for managing and applying ORACLE data servers. The Oracle
The configuration of ASM in Oracle RAC can be implemented in two ways: raw and asmlib. Raw is recommended for actual maintenance.
There are two ways to use raw: Multipath and udev. On the RedHat platform, refer:
RedHat 5.4 + ASM + raw + Oracle 10g
With the development of enterprise business, there are more and more large data warehouses, and their scale is also expanding rapidly, increasing by three times every two years on average. Large Data Warehouses require scanning dozens, hundreds,
1. Workspace Manager Component Description
Before the description, we first use the following SQL statement to check the components in the database:
SQL> Col comp_id for A15
SQL> Col version for A15
SQL> Col comp_name for A30
SQL> select comp_id,
If you want to send an email from Oracle before 10 Gb, you must use the utl_smtp and utl_tcp feature packages of Oracle to package an email sender program and then use it. since 10 Gb, this process will become very simple. because Oracle provides us
PL/SQL single-row functions and group functions
A function is a program with zero or multiple parameters and a return value. Oracle has a series of built-in functions in SQL, which can be called SQL or PL/SQL statements. functions are mainly divided
-- Reprinted in notes of Zhou chaoyong of the project team
Subject:1. Configure table space and various user objects.2. Create a data image from a real-time database to a backup database.
Environment: Sun Solaris UNIX 9Oracle 9i
Condition: 1. Two
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
------------------------------
Today, I learned how to remove spaces from strings in oracle. Here is a summary. Two methods are available: Trim function and Replace function. I will introduce these two methods in detail below. I hope you can add them to your questions.
The Trim
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