Oracle

We can encrypt one or n columns of a table.You can add the encrypt keyword after the data type of the column in the create table command, or add the encrypt keyword after the column name of an existing column.For example, to encrypt the name column

Oracle views do not support parameters There is an alternative method. It is not very good, but it is still a solution. Using package Create or replace package pkg_pv is Procedure set_pv (Pv varchar2 ); Function get_pv return varchar2;

Importing and exporting Oracle Data imp/exp is equivalent to restoring and backing up ORACLE data. The exp command can export data from the remote database server to the local DMP file, and the IMP command can import the DMP file from the local to

This article from: http://www.cnblogs.com/deyga/archive/2009/04/17/1437805.html Oracle SQL built-in functions 1. ASCII returns the decimal number corresponding to the specified character;SQL> select ASCII ('A') A, ASCII ('A') A, ASCII ('0') zero,

Implementation code example:Variable jobno number;BeginDbms_job.submit (: jobno, // set the job number'Procdemo; ', // set the content to be executed. Generally, it is a stored procedure and the write process name is,Note: if it is to call the

After writing so much, I want to say that implicit conversion must be used with caution. This is like a time bomb ..   When I got off work the day before yesterday, I suddenly received a call saying that the online reimbursement system had a

-- Partition by data volume in the table less than is smaller than the maximum value of 3, this partition can only store two data ---- 30000000 ---- 60000000 --Create Table dtf_test(Dtf_id number primary key,Item_id number (8) Not

Select S. Sid session_id,S. username,Decode (lmode,0,'None ',1,'Null ',2,'Row-s (SS )',3,'Row-X (SX )',4,'Share ',5,'S/row-X (ssx )',6,'Exclusion ',To_char (lmode) mode_held,Decode (request,0,'None ',1,'Null ',2,'Row-s (SS )',3,'Row-X (SX

Recently, hint is frequently used because of frequent statistical data requirements. I am sorry to bother DBAs every time, so after talking with DBAs, I sorted out the most common hint usage when writing Oracle SQL statements: In addition, our

Sometimes we need to extract some complex data from the database, but the standard SQL is powerless, or the execution efficiency is very low. For example, we need to extract the following data:Displays the accumulated salary of each department on a

Installing the Oracle database software under liunx is not easy for beginners. This cainiao was successfully installed after a long time of hard work and did not dare to enjoy it during the intermediate process. I will announce it and share it with

How to Create a database link in Oracle Multiple Oracle databases physically stored in the network can be logically considered as a single large database. Users can access the data in the remote database through the network, the collaborative

The following are some of my Oracle pen questions and answers. 1. create a tablespace, and name the data file neudata. DBF, which is stored in the D: \ data directory. The file size is 200 MB, which is set to auto-increment and 5 MB. The maximum

Questions I designed: Oracle interview questions 1. What is a bare device in Oracle?A: A bare device is a storage space that is directly accessible by bypassing the file system. 2. How can I determine from which machine a user logs on to Oracle?A:

Oracle provides Partitioning technology to support vldb (very large database ). The partition table judges the partition columns to store different records in different partitions. Partitions are completely transparent to applications. Oracle

We often use a variety of technical means when optimizing Oracle, among which statspack and explain Plan are the most common. When we use these two common tools for optimization and adjustment, we often see physical reads and logical reads. So the

Oracle is currently one of the best database software. It provides an open, complex, secure, and integrated architecture and service that enables enterprises to store data efficiently and securely. In the production environment, because we are not

What is checkpoint? What can checkpoint do? How does checkpoint run?   This is a problem we need to understand when we understand the checkpoint concept. It is also the three problems that we often cannot understand when understanding the

You need to migrate the project to a MySQL database.I found a small tool for table and data migration. This only supports table and data migration.Does not include view, sequence, SP, function. Package, etc.Ora2mysqcn.exeOra2mysqcn.exe(1.63

Today, we will briefly introduce how to modify the CRS-related resource attributes in Oracle GI 11gr2. In Oracle 11gr2, all resources have some default properties at the end of the installation. Resources include not only CRS resources, such as