Basic environment:
Purpose: to restore from the source database to the test library by means of physical recovery of RMAN.
How to verify, insert a few pieces of data in the source database
Category: Oracle
Oracle Database, also known as Oracle RDBMS, or Oracle for short. It is a relational database management system of Oracle. It is a product that has always been in a leading position in the database field. It can be said that the Oracle database system is a popular relational database management system in the world. The system has good portability, easy use, and strong functions, and is suitable for all kinds of large, medium, small and microcomputer environments. It is a high-efficiency, reliable and high-throughput database solution.
The meaning of% TYPE in the Oracle stored procedure
Transfer:
Example:
CREATE OR REPLACE
procedure getDeptById
(
v_deptno in dept.deptno%type
)
is
v_dname dept.dname%type;
v_loc dept.loc%type;
begin
select dname,loc into v_dname,v_loc fr
Advantages of Oracle Merge Into
Introduction Oracle merge into command, as the name implies, is “update if there is, insert if not”. This is also the core idea of the merge into command. In the actual development process, we
Oracle is queried every day, weekly, monthly, annual query
oracle query statistics data daily, weekly, monthly, quarterly, and annually
//Statistics by day
select count(dataid) as the number of operations per day, sum()
from tablename
group by