Second, the OMF management of the log file
Log file management parameters: Db_create_online_log_dest_n
Db_create_online_log_dest_n:oracle the default path when you create an online log file and a control file without explicitly specifying a path
-
The company I serve not only has an Oracle database, but also has a SQL Server database, so I often meet people asking me two questions.
The first type is usually "can you teach me to use Oracle?" In the beginning, my polite answer to this is
Introduction
Oracle is the most widely used large-scale database management system, improve the efficiency of Oracle database system, is the premise and guarantee of the efficient operation of the whole computer information system. There are many
Select Format:SELECT [All | DISTINCT] From ,[, ...][WHERE [GROUP BY [having[Order by [ASC | DESC]]
Statement Description:[] square brackets are optional[GROUP BY [havingThe result is grouped by the value of the , which is equal to a set of
An Oracle cursor is divided into a display cursor and an implicit cursor.
Display cursor (Explicit Cursor): A cursor defined in a PL/SQL program, used for querying, is called a display cursor.Implicit cursors (implicit Cursor): A cursor that is
The code is as follows
Copy Code
PROCEDURE Test (p_msg out VARCHAR2) isBegin>For I in 1. Ten loop>for j in 1. 5 loopDbms_output.put_line (' I: ' | | | ' J: ' | | j);EXIT Jloop when j = 3;End Loop Jloop;End Loop Illoop;End
How to use Oracle LOWER () and UPPER () functions
A column returns rows that are case-insensitiveThis is a common practice to make columns case-insensitive to ensure that you want to return all rows.
SELECT *From coursesWHERE LOWER
Oracle Data Import Export IMP/EXP is equivalent to Oracle data restore and backup. The EXP command can export data from a remote database server to a local DMP file, and IMP commands the DMP file to be imported locally into a distant database server.
Oracle Flash-back technology , here are 4 kinds of flash back technology, the Oracle Flash-back technology to do a collation summary.
Overview:
The flash-back technology is part of Oracle's powerful database backup recovery mechanism, which
Recently arrived at the company to work, a general understanding of the company's process, found that the database is very badly needed to make up, the former school in some databases are SQL Server, as well as some increase, delete, change, check
Only know SQL Server support data Bulk INSERT, but Oracle, SQLite and MySQL are also supported, but Oracle needs to use the Orace.dataaccess driver, today put out several database of BULK INSERT solution.
First of all, Iprovider has a plug-in
The Oracle tutorial you are looking at is a common database system that compares Oracle databases.
To bring up the database, the first company to think of, is usually oracle. The company was founded in 1977 and was originally a company specializing
The Java Database Connectivity (JDBC) API is a series of interfaces that enable Java programmers to access the database, and the interfaces of each developer are not exactly the same. After years of JDBC with Oracle, I've accumulated a lot of skills
1. static sqlsql and dynamic SQLOracle compiled PL/SQL program block is divided into two kinds: first, the previous early binding, that is, the SQL statement was established during the program compilation, most of the compilation is this type, and
1. The question
The system has a module that needs to query the data in the Oracle database. It is now implemented by establishing a linked server.
SQL Server access Oracle implementation can refer to this article
This article describes 8 commonly used monitoring data shell scripts. First, we reviewed some of the UNIX commands commonly used by DBAs, and explained how to execute the DBA script regularly with Unix cron. Online also has good
Many similar
Database concurrent access, where two or more users access the same data at the same time, is the biggest problem for the database engine to design and implement a moderate response. A well-designed, performance-capable database engine can easily
Some other maintenance activities are involved when using the recovery directory, such as upgrading the recovery directory during database upgrades or migrations, manually configuring the database counterpart, and synchronizing the recovery
Oracle 12C user creation vs. table space allocationAfter the database installation is complete, the table space ' IMEI ' in the Database Container (CDB) is first created with the System User link Database Container (CDB)
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