Reference: http://wenku.baidu.com/view/ 4f819a24af45b307e87197ea.html
Tag: Oracle
PowerDesigner installation and configuration connection Oracle Database
The installation and configuration of PowerDesigner connect to Oracle database
After unremitting efforts, I finally successfully connected powerdesigner to the database. I also encountered so
PowerDesigner generated Oracle built-in script to remove the quotation number of lowercase objects
This time I used pd to design the database. I didn’t pay attention at first. All table names and field names are in lowercase letters. As a result, all the objects in the generated script were quot
Problem processing using PowerDesigner16 anti-compiling Oracle database
Recently, when using powerdesigner to decompile Oracle, I encountered a failure to connect to Oracle using odbc. After many tests, it was found that the problem was caused by the use of 64-bit odbc, which was replaced with 32-bit, and the problem disappeared.
[Oracle] Rman Duplicate Replication Library
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
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