Oracle

What is Oracle archive mode?The Oracle database has an online redo log, which records changes made to the database, such as inserting, deleting, updating data, etc., which are recorded in the online redo log. A generic database must have at least 2

Oracle database like special, binary field data cannot be inserted directly, you need to insert the field into the initial data returned by the Oracle function, and then update the field in the query. The following is an example of a BLOB field type:

a simple understanding of the character set:Character set: The table that corresponds to the encoding of the character. When the software has a character set, it uses its own character set, and if the software does not have a character set, use the

Step 1: Configure MySQLModifying a configuration file My.ini#for goldengateLog-bin = "C:/mysql/logbin/logbin.log"Binlog-format = ROWLog-bin-index = "C:\mysql\logindex"binlog_cache_size=32mmax_binlog_cache_size=512mmax_binlog_size=512mAdd database

*********************************************** Declaration ********************************************* * original works, from the "Deep Blue Blog" blog, Welcome Reprint, please be sure to indicate the source when reproduced , otherwise be held

Baotou:Create or Replace package Produrececursordata isType curtype is REF CURSOR;Type Type_record is record(Deptno Number (2),Dname VARCHAR2 (14),Loc VARCHAR2 (13));PROCEDURE Procedure1 (cur out curtype);End Produrececursordata;InclusionCreate or

Database systemDBS is database system, the Chinese meaning is "data base systems", refers to a computer system with a database and the use of database technology for the management of information.What is a database system?The DBS (Data Base system,

addition: Select Sysdate,add_months (sysdate,12) from dual; --plus 1 years Select Sysdate,add_months (sysdate,1) from dual; --Add January Select Sysdate,to_char (sysdate+7, ' Yyyy-mm-dd HH24:MI:SS ') from dual; --plus 1 weeks Select Sysdate,to_char (

Java Object Serialization Storage Oracle:Import Java.io.bufferedinputstream;import Java.io.bytearrayinputstream;import Java.io.ByteArrayOutputStream; Import Java.io.inputstream;import Java.io.objectinputstream;import

Recently, in the development, write the time encountered some problems, find a long time to find the reason, and is not known before. So write down here and give yourself a memo and reference.one, null valueIn the simplest case, the usual work is

Share the methods of creating views in the Oracle database.Oracle's database objects are divided into five types: tables, views, sequences, indexes, and synonyms.A view is a logical table that is based on a table or multiple tables or views, which

tutorial on how to create and process Oracle database views.Learn how Oracle views are used by sharing the methods for creating views and working with views in Oracle.A view is a logical table that is based on a table or multiple tables or views,

There is a problem with Oracle's Universal Installer Uninstall: Dirty, incomplete, and some registry residues that can affect subsequent installations. Therefore, it is recommended to manually uninstall Oracle. 1. "Win+r", "services.msc", turn off

1. Create a PDBSql> select name from v$datafile;  NAME--------------------------------------------------------------------------------/u01/app/oracle/oradata/

Performance of different Oracle client and Oracle versions **************************************** ******************************** ************** Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate

Measure the test taker's knowledge about DRM in oracle10gRAC.Summary of DRM1. What is DRM?Dynamic Resource Management (DRM) is a new feature of oracle 10 Gb. in oracle rac environment, ORACLE uses GRD (Global Resource Service) to record Resource

Oracle 11 tablespace dbf File migration When the disk space of the oracle data file is insufficient or the dbf file needs to be migrated to another location in other cases, the procedure is as follows: 1. sqlplus sys/sys as sysdba 2. shutdown

SQL queries the nclob field of oracle, sql1_lenclob Use the CONTAINS keyword to query the NCLOB Field   SELECTFORMATTED_MESSAGEFROMFOC. TBL_LOGWHERECONTAINS (FORMATTED_MESSAGE, p_FORMATTED_MESSAGE)> 0; Oracle clob field insertion In oracle, four

Case study of ORACLE Database disconnection When I got off work last night, I was about to shut down the ORACLE database on the local virtual machine, and then I was about to get off work. But because I opened multiple windows in SecureCRT, I

ORA-01810 format code appears twice solution, ora-01810 Solution When you make a query page this morning, you need to query the spans of two time ranges. Use the TO_DATE function and write it at the beginningSQL codeTO_DATE ('2017-08-04 00:00:00 ', '