Oracle

Oracle RAC backup and recovery OCR Oracle RAC backup and recovery OCRvoting disks Backup Recovery reference: http://www.bkjia.com/database/201303/195593.html 1. OCR supports two backup methods: automatic backup and manual backup. Automatic Backup:

Oracle: SYSDATE (): TO_CHAR (SYSDATE (), 'yy/MM/DD HH24: MI: SS) or TO_DATE (SYSDATE (), 'yy/MM/DD HH24: MI: SS) format the number: TO_NUMBER Note: TO_CHAR converts the date or number to the string TO_CHAR (number, 'format') TO_CHAR (salary, '$99,999

Orcl create user permissions 1. system permissions classification: DBA: All privileges are granted, which are the highest permissions of the system. only DBA can create a database structure. RESOURCE: users with Resource permissions can only create

The syntax format of the oracle Lpad function is as follows: lpad (string, padded_length, [pad_string]) string to be filled; the length of the string after padded_length is filled, that is, the length of the string returned by the function, if the

Case... when... then statementCASE is a keyword used by SQL as a logic such as if-then-else.// Syntax:Select case ("column name ")   WHEN "condition 1" THEN "result 1"   WHEN "condition 2" THEN "result 2"   ...   [ELSE "result N"]  ENDFROM "table

Oracle -- optimizer_mode Oracle uses the Optimizer_mode parameter to control the optimizer preferences. 9i commonly uses several parameters: first_rows, all_rows, first_rows_N, rule, choose, and so on. 10 Gb is less than rule and choose. Oracle has

HANDLECOLLISIONS in Oracle GoldenGate is a replicat process parameter, which is mainly used in initial load. When this parameter is used in the replicat process, even if there is a data integrity problem in the target database environment (for

Oracle statement Exercise 1 switch to the oracle hr user below Exercise 1. query the names and salaries of employees whose salaries are greater than 12000 select first_name, last_name, salary from employees where salary> 12000; 2. query the name and

Oracle 2-single-line function theory and case analysisSQL has two types of functions: single-row and multi-row functions.1. Single Row FunctionsSingle-row functions: operate on Data Objects, accept a parameter to return a result, transform only one

Note the problem of executing marker_setup. SQL hang during ogg ddl replication configuration: this is a record. During the ogg experiment, configuring DDL replication and running the marker_setup. SQL script hang is not a pure technical problem,

Oracle scalar quantum query ORACLE allows a single-row subquery to be included in the select clause. Using scalar quantum query can effectively improve performance. When using external connections or using aggregate functions, we can consider the

How Does oracle check which users are connected to the database? execute the following statement: select username, serial #, sid from v $ session; --- query the user session alter system kill session 'serial #, sid '; --- Delete related user

Write the first few data records for oracle/db2/sqlserver/sybase/mysql databases. ORACLESELECT * FROM TABLE1 where rownum

Error in invoking target 'client _ sharedlib 'of makefile'/u01/app/oracle/product/10.2.0/db_1/network solution yesterday afternoon, when you receive an application, you must set up 10.2.0.1Rac for RHEL5 in an unlimited number of digits and use the

An ERROR occurred while connecting to the database prompting the archive to solve (1) problem [SQL] SQL> conn hr/hr error: ORA-00257: archiver ERROR. connectinternal only, until freed. warning: You are no longer connected toORACLE. (2) After the

Automatically generate the AWR report [plain] create or replace procedure sp_auto_awrreport (reporttime varchar2 default null, rpt_interval number default 2) AS ---- purpose: automatically generate the AWR report ---- Creator: cavlin ---- creation

Summary of Oracle 10g SYS user authentication method OS: Red Hat Enterprise Linux AS release 4 (Nahant Update 2) uname-r: 2.6.9-22. ELDB: Oracle Database 10g Release 10.2.0.1.0 first case: Set the initialization parameter remote_login_passwordfile

A series of common Oracle operations 1. create an Oracle tablespace: Example: create tablespace my_space datefile 'd: \ ruanjian \ app \ Administrator \ oradata \ oracle \ my_space.dbf' size 20 M; 2. delete Oracle tablespace: Example: drop

Procedure and function programming procedure in plsql: Stored procedure eg: create or replace procedure p -- the difference between procedure and plsql is cursor c is select * from emp2 for update; -- v_temp c % rowtype; begin for v_temp in c loop

Oracle Stored Procedure encryption, as the name suggests, is the encryption of the Oracle stored procedure source code, so that others do not see your source code, to achieve the purpose of protection, of course, not everything is needed. Some