1>. NUMBER Type Details:Oracle number datatype Syntax: NUMBER [(precision [, scale])]Short for: precision --> pScale --> s
NUMBER (p, s)Range: 1 Data storage range:-1.0e-130 Saved in the machine range: 1 ~ 22 bytes
Valid: the number of digits from
I. Backup is divided into physical backup and logical backup.
1. Physical backup is a backup of physical files (including data files, control files, and redo log files. Physical backup is further divided into hot backup/online backup and cold
In previous versions, except incomplete restoration, there is usually no good solution. Currently, Oracle10g provides the new flashback drop feature to accelerate the recovery of user error operations.
The flashback drop function allows you to
This article will discuss and share with you some common classic queries of oracle SQL. You are welcome to add them. You can also share some classic queries. In this article, if you think there is any better solution to every problem, you are
Trigger
The code block automatically executed when a specific event occurs. It is similar to a stored procedure, but users cannot directly call them.
Function:1. Allow/restrict table modifications2. automatically generate a derived column, such as
Database Synchronization is often used in the project process. Now, we paste the synchronization process of a project that was previously created for your reference!This document is completed in the following steps:1. Environment configuration
Oracle Bad blocks are divided into Physical Bad blocks and logical Bad blocks, most of which are caused by hardware problems, the cause of logical Bad blocks is generally caused by oracle software bugs or oracle patches not installed.You can use the
Introduction to Data Guard components 1. Introduction to Data Guard components the Data Guard architecture is classified as three main components. Data Guard redo transmission service is used to transmit the redo Data generated by the primary
The _ sort_elimination_cost_ratio parameter of Oracle CBO shows several optimization cases related to the implicit parameter _ sort_elimination_cost_ratio of Oracle optimizer (Refer ). If _ SORT_ELIMINATION_COST_RATIO is used as the keyword to query
Oracle cannot modify the data type of an existing column if there is data in the table. However, you can create a temporary column, copy the data of the column to the temporary column, delete the original column, and modify the name of the temporary
Routine Oracle database check methods and steps 1. Check the partition information 1. check which tables have partitions
Select * from user_tables where partitioned=’YES’;
2. Check and list all secondary partitions in the current table
select *
Oracle analysis table and Index
analyze table tablename compute statistics;analyze index indexname compute statistics;
It is good for using CBO. You can use more reliable table information, so that the execution plan can be more accurate. In 10 Gb,
Create a user after creating a database in oracle
[SQL]/* Step 2: Log On */log on to pl/SQL/* Step 3: create a temporary tablespace */create temporary tablespace user_temp tempfile 'e: \ oracle \ product \ 10.2.0 \ oradata \ wu \ user_temp.dbf
Oracle uses a package to package stored procedures, function stored procedures, or functions. Most developers should have used it. If the number of stored procedures or functions is small, it would be okay, if a large number of maintenance tasks are
"The input value is not long enough in the date format" reported in Oracle for date conversion"
[sql] select (select j.jgmc from t_zzjg j where j.jgdm = t.jgdm) jgmc, t.jgdm, sum(t.jcj) jcj, sum(t.sa) sa, sum(t.la) la,
In oracle, the remainder is obtained using the mod (numer1, number2) function. In oracle, the remainder is obtained using the mod (numer1, number2) function, and the return value is the other values. For example, output 1 ~ All integer values in 13
Oracle-user-managed backup (ii) I. What will happen if the host is shut down abnormally when the tablespace is in backup mode? Open the first session window, Log On As A sys user, and place the tablespace users in backup mode. SQL> alter tablespace
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