Oracle

1. Replace,translate--translate character-level substitution--Replace string-level substitutionSelect Replace('abaabbb','AB','C') fromDual--CACBBSelectTranslate'aaabbb','AB','CE') fromDual--ccceee2. Concat string connection, equivalent to | |Select

1. Why use synonyms:Synonyms, as the name implies, are the same as the meaning of two words, can be replaced with each other. What is its role?A one of the most obvious goals is to simplify SQL. If a database object's name is too long, you can

Can Oracle restart be used to make high availability use of Oracle GoldenGate?From:Can Oracle Restart is used with Oracle GoldenGate for high availability? (Document ID 2025185.1)Suitable for:Oracle goldengate-version 11.2.1.0.20 and

Error message:Checking network configuration requirements ... The check is complete. The overall result of this check is: Failure Tip: Configure Microsoft LoopBack Adapter as your system's primary network adapter.Workaround:Control Panel, add

1. The date in Oracle is converted to yyyy mm month DD Day formSelect to_char (sysdate,' "Year" MM "month" DD "Day")from dual;2. Oracle Analytic function syntax2.1 ORDER bySelect E.last_name, e.manager_id, e.salary, avgover as--

Original sql:Select substr (field1, InStr (field1, ' | ', 1, rownum) + 1, InStr (field1, ' | ', 1, rownum + 1)- InStr (field1, ' | ') , 1, RowNum)-1) as Field2 from (select ' | ' | | ' A|bbb|cccc|ddddd|ee|d|a '

Cat/etc/security/limits.conf Grid Soft Nproc 2047Grid hard Nproc 16384Grid Soft Nofile 1024Grid hard Nofile 65536Oracle Soft Nproc 2047Oracle Hard Nproc 16384Oracle Soft Nofile 1024Oracle Hard Nofile 65536Eofecho "Session required/lib64/security/pam_

1.Altertable table name Add system Time field datedefaultsysdate;--newaltertable Table name MODIFY The field to be modified VARCHAR2 (12);--Modify2.The decode () function is one of the most powerful functions of Oracle PL/SQL and is currently

Format: Numtoyminterval (n, Interval_unit); N: Numeric type Interval_unit: ' Year ', ' MONTH ', or other expression that can be converted to one of these two values Numtoyminterval (1, ' Year '): Interval numtoyminterval ( -1, ' month '): One months

It's been all the time. SQL Server suddenly with Oracle egg pain of the even stored procedures to execute a query will not be all kinds of Baidu now record the following syntax problemsOrcale The syntax for creating a stored procedure,Create or

View all user partition tables and partitioning policies (1, Level 2 partition tables are included):SELECT p.table_name as table name, decode (P.partitioning_key_count, 1, ' primary partition ') as partition type,P.partitioning_type as partition

1. See if Oralce is an archive or non-archive modeSql> select Name,log_mode from V$database;NAME Log_mode---------------------------------------- ------------------------------------YOON ARCHIVELOGSql> select Name,log_mode from V$database;NAME

1 　　 Public Static voidMain (string[] args)throwsSQLException {223344 String driver= "Oracle.jdbc.driver.OracleDriver";55 String url= "Jdbc:oracle:thin: @www. Ee.w.www:1521:orcl"; 66 String user= "RRR"; 77 String password= "RRR";8899 Connection

With Oracle 11g for a long time, really feel is a very heavy client, installation will take one hours, recently started to contact this lite version of the database client, tinkering with the half-day, finally success.1. Download the client2.

1. Ways to modify the maximum number of connections for Oraclehttp://my.oschina.net/shootercn/blog/11193A, landing in SYSDBA status of PL/SQL or WorksheetSqlplus SYS as SYSDBAB, query the current number of connectionsShow parameter processes;C,

Do the system management is so, inevitably will mistakenly delete files, one day if an Oracle data file deleted, then how to recover it? (Here the database is open and not closed) Create a test table space Create a test user

There is a new feature in ORACLE 11G that does not allocate segment when the table has no data to save space.Workaround:1) Insert a row, and then rollback will produce segment.The method is to insert data into the empty table and then delete it,

First look at the literal meaning of undo and redo:Undo: Undo, that is, cancel the previous operation.Redo: Redo, perform the previous operation again.What is RedoRedo records transaction logs, divided into online and archived. For the purpose of

Common Oracle and SDE maintenance commands-view tablespaces and so on, oraclesde Previously, I reported a data update problem on the site. I thought it was caused by the full table space (the error was written in the previous blog article).

Transaction Management for Oracle to process DDL and DML statementsMain programming languages of SQL Data Definition Language (DDL), such as create, alter, drop, Data Operation Language DML (Data Munipulation Language) such as insert, update, delete,