Oracle

OracleOfBLOB FieldType can be used to save binary data with a long length. However, the Code for reading and writing BLOB field data is usually very wordy, and it is easy to make mistakes without careful coding. I integrate this feature into my OCI

Summary of methods to maintain excellent performance of Oracle databases: I. Partitioning Based on actual experience, the vast majority of data space in a large database is occupied by a small number of tables. To simplify the management of large

How to configure the oracle database in win7: Environment: Windows 7 (64bit), oracle 11g (64bit ). In the course of the experiment, oracle is damaged. You need to uninstall it before installing oracle again. Steps for uninstalling oracle 11g: 1.

Oracle DatabaseOfTuning LawIt is a rule that DBAs must comply with when working. DBAs can complete Oracle Database optimization only when database optimization is restricted. In the past decade, Oracle has become one of the world's most professional

Oracle DatabaseIt is often used in our daily work. This article will bring you an Oracle databaseConstraintsTo help you. The last table has two columns of fields, which either have values or are empty. A simple table definition cannot meet this

The author opensOracle DatabaseWhen preparing for something, suddenly the computer blue screen,System Crash. After the instance is restarted, start the instance and prepare to connect to the Oracle database for continued use, but find that the

This article mainly introducesOracle 10g ConsoleWhen an error message is displayed: I/O exception-Unknown host specified solution. Next we will introduce it. First, let's take a look at the error prompt code. After logging on to localhost: 1158/em,

We know that,WeblogicIs a Java application server used to develop, integrate, deploy, and manage large-scale distributed Web applications, network applications, and database applications. Set Weblogic andOracle Database Connection PoolThe combined

InOracle DatabaseWhen we execute a query, we usually need to sort the query results. SortORDERClause. This article summarizes the sorting of Oracle Database queries. Next we will introduce these. Sort by pinyin (default) Select * from perexl order

HowOracle DatabaseProceedCold backupWhat about it? If yesCold Backup Remote recoveryWhat settings are needed? This article mainly introduces this aspect. Next we will start to introduce it. I. Cold backup Take oracle10g as an example. Coldbak script:

This article mainly introducesOracle DatabaseOfVirtual ColumnAndCompound triggerRelated knowledge, including the creation of virtual columns and composite triggers, and examples of creation are provided. Let's take a look at this process. I. Virtual

OracleIn the databaseStored ProcedureCan be usedJavaJava calls Oracle stored procedures are divided into calling stored procedures without return values and stored procedures with returned values. This article will introduce this part. Next let's

Last time we introduced:Oracle DatabaseMediumAWRIn this article, we will introduce the use of AWR in detail. Next, let's take a look at this part. AWR is automatically generated by ORACLE, but you can also manually create, delete, and modify it

InOracle DatabaseIn the Oracle databaseTNSListenerUnable to start, because my small black memory is only 512 MB, so half of oracle services are set to manual start. Today, we suddenly found that the TNSListener service could not be started,

Oracle DatabaseView and modify the serverCharacter SetThe method is described in this article. Let's take a look at this part. A. oracle server Character Set Query Select userenv ('language') from dual The NLS_CHARACTERSET is the server-side

Last time we introduced:SQL/PLUS Study NotesTo edit the current line of commands in the buffer, this article describes the SQL/PLUS learning notesECHOAndSPOOLNext, let's take a look at this part. ECHO parameter settings: SQL> show echo -- display

Oracle DatabaseMediumCreate SchemaThe process can be implemented using code. This article describes a sample code for creating a Schema for an Oracle database, hoping to help you. First, execute the following code: clear screen;   disconn;  

Oracle 10gListenersListener cannot be startedThere are many reasons for this. In this article, we will summarize the reasons that cause the listener to be disabled. Let's take a look at this part. 1. When the following prompt appears in Oracle: ora-0

Oracle DatabaseMediumCreate an auto-increment FieldThe method is what we will introduce in this article. We know that there is no Oracle Auto-incrementing field function in the Oracle database, but trigger and sequence are used) yes. Assume that the

CRONTAB calls the backup scriptPay attentionEnvironment VariableSettings are the main content we will introduce in this article. We know that EXP backup is one of the common operations of DBA, especially in versions earlier than 10 Gb without EXPDP,