The key reason for upgrading a large object (Large object, LOB) storage capability is the increasing demand for data security in Oracle 11g, which focuses on expanding transparent data encryption for LOB and tablespace (transparent data encryption,
Triggers are blocks of code that are executed automatically when a particular event occurs. Similar to stored procedures, but users cannot call them directly. Triggers are a technology provided by many relational database systems. In Oracle systems,
The function of the Oracle To_char function is to convert a numeric or date type to a character type, and here's a detailed description of the use of the Oracle To_char function, which I hope will help you.
The Postgres Format function provides an
One, Oracle trace FileOracle trace files are grouped into three categories:
One is the background alarm log file that records the activity of the background process during startup, shutdown, and running of the database , such as table space
There are two types of cursors in Oracle: an explicit cursor, an implicit cursor. A display cursor is a cursor defined with the cursor...is command that handles multiple records returned by a query statement (SELECT), while an implicit cursor is a
Article Summary:
Oracle is a database platform, and some projects use Oracle's database replication technology, which also encounters some problems, so here I have a personal understanding of Oracle's replication technology, hoping to help the
oracle| Export Data | compression
Mybat.bat
Sqlplus-s A/a@mydb @d:\a\mysql.sql
Mysql.sql
Set time off echo off head--This row setting does not count the Times does not show the SQL statement not every few lines present column name
Set pagesize
Oracle
Recommend some classic Oracle books to everyone:
Http://www.eygle.com/index-book.htm
Oracle8i Internal Services by Steve Adams
The classic of Steve Adams ... An in-depth discussion of Oracle's internal mechanisms and principles is an in-
Installing Oracle under Linux is a daunting thing, much more complicated than installing the Linux operating system itself. If you are able to successfully install Oracle, you can also learn some Linux technologies. This article describes the method
Because of the row link can only increase db_block_size to clear, and db_block_size after the creation of the database can not be changed, so there is no more than the purge of the row link, mainly for the row migration to talk about in the actual
Oracle 12c Backup and recovery strategy (Rman Backup [Open Archive/control file/data File/Archive log]): Backup strategy: * Make a full backup of the database (including all data and read-only tablespace) every six months * once a week level 0
Due to the virtual machine host restart, causing a lot of virtual machine services need to focus on, one of the DG from the Library and another report library has ogg synchronization, so here again after the system Recovery check Ogg state, the
ObjectiveTake over predecessors of the project, no contact, installation, use of Perl and dbd::oracle, there is no relevant documentation, blankly at a loss ~ ~. At the beginning of the problem, thinking about the rapid resolution, directly on
The following issues occurred when using the Oracle database for the first two days, using the DBA user to export table structures in the tool in PL/SQL, when exporting tables:A lot of table "error (EXP-00003) did not find the segment (0,0) storage
1. OverviewMost recently, in an ESB project, the customer's service calls between the various systems were mostly performed in oracle stored procedures, and this article describes the oracle stored procedure invocation Web service . Other mainstream
You can use the Territory Flexfield for recording and customized reporting on your Territory information. Territory Flexfields is also displayed in the Transaction Detail and Customer Detail reports in Receivables. Receivables provides a default
Does Oracle GoldenGate support extracting or replicating data from SAP HANA database to SAP HANA database?From:Does Oracle GoldenGate support Replication to/from Sap-hana Database (document ID 1413202.1)Suitable for:Oracle goldengate-version 10.4.0.1
Idea: You can remotely query the table of an Oracle database by adding a linked server to the SQL Server databaseEnvironment preparation, install the SQL Server database, install the Oracle driver, configure the Oracle connection in the configured
What is Data redactionThe data redaction is a new feature of Oracle Database 12c's Advanced security options, and Oracle China translates it as a "compilation" When it comes to this feature, and in the Chinese interface of em12c R3, this function is
The Blob field in Oracle is special. It has much better performance than the long field and can be used to save binary data such as sample slices.
Writing BLOB fields is very different from writing other types of fields. Because blob itself has a
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