Oracle

Oracle Common Functions--trunc,to_date,to_char,to_number, SUBSTR,REPLACE,NVL, Trim,wm_concat,upper, Lower,length,add_months ( sysdate,1)View Oracle Version: SELECT * from V$version First, trunc function1, TRUNC (for dates) The date value that the

Read Catalogue 1.oracle (Regular expression) Brief introduction 2.oracle Regular special characters 3.oracle Regular character clusters 4. Operation priority for various operators 5. Simulation Test examples 6.oracle

First use DBCA to build a database, db_name=primary. 2. Prepare a static listener for two databases. and connecting each other's Tnsname11gdg1-> cat listener.ora tnsnames.ora # listener.ora network  configuration file: /u01/app/oracle/product/11

Snapshot Standby , this feature allows the repository to be "read and write" for content that is not easy to test in the main library of the production environment, such as simulating on-line testing tasks. When the task is completed in the read

Really is too difficult, before the time in Window Server 2003 above a set of Asp+oracle interface system, it cost a great effort, in fact, that will be fascinated gaze stare also do not know how to fix, also lazy tube. OK, from yesterday to today

1. Case Expressions in Oracle(case condition when expression 1 then result 1 when expression 2 then result 2 [else result n]end) as Alias2. Simple loop LoopsLoop to execute the statement;        Exit when/* Condition satisfied, exit Loop statement */

There is a feature in the project that needs to get data from an Oracle database, which was thought to be very simple, and changed the original SqlClient into a OracleClient call.The result is far less simple than you think. There are a lot of needs

This is because debugging automatically evaluates the variables in the Local/watch window (or the mouse cursor), in order to prevent the user from writing a program error (such as a dead loop), the system has a timeout limit, if the get of a

Two Oracle DB instances are installed on the same server, how do you differentiate which DB instance you are working with by using command to start and stop a database? The operation is as follows:1. On the command lineSet Oracle_sid=one_

Command: IMP database user name/password @127.0.0.1:1521/orcl file=d:\txpt20150424.dmp full=y If the above command appears with the following error message IMP-00058: Encountering ORACLE error 12514Ora-12514:tns: Listener currently does not

Note the value of the Last_call_et,Select s.status,s.last_call_et,s.* from v$session s where username= ' DDD ';In this example, a sqlplus is opened and a select * from Big_table is performed on a large table;Can be opened until the results are shown.

SQL Optimization Tips (1): Connection order in the WHERE clause: Oracle parses the WHERE clause in a bottom-up order, and according to this principle, the connection between tables must be written before other where conditions, and those conditions

There are 4 main architectures for Oracle databases: Physical storage structure Logical storage structure Memory structure Process structure I. Physical storage structureThe Oracle database is physically composed of system files

Reference: http://www.jb51.net/article/32214.htm1. Some basic parameters of Oracle[Email protected] ~]$ echo $ORACLE _sidAdela[Email protected] ~]$ echo $ORACLE _home/u01/app/oracle/product/12.1.0/db_1[Email protected] ~]$ echo $ORACLE _base/u01/app/

1.Java development generate UUID or GUID method// 36-bit, with dash // 32-bit, remove the middle dash Java.util.UUID.randomUUID (). toString (). ReplaceAll ("-", "" ");2.Javascript development generate UUID or GUID method/*parameter Middle_line

Under the Linux operating system, the increase in Oracle DB 11g Memory_max_target and Memory_target should be noted:[[email protected] ~]$ sqlplus/as sysdbasql*plus:release 11.1.0.7.0-production on Tue Jul 01:12:24 2015Copyri Ght (c) 1982, D,

Oracle quick export of data files, oracle export of data There are many data file generation methods, but most of them are inefficient. For large data warehouses, efficient file export is an urgent requirement: Here, the shell + java method is used

Summary of QTP connection to oracle Database First of all, because many friends in the Group say that QTP is a little troublesome to connect to oracle, I am doing a complete tutorial on connecting to oracle. If you want to learn it, you can refer to

Retrieve the Table that has been mistakenly dropped/Truncate/Delete on the primary database on the standby Database Prerequisites: - Standby Database Must be in Flashback database mode. - Time at which Drop/Truncate/Delete Table happened should be

Oracle recursive functions and concatenation, oracle recursive concatenation 1 SELECT SUBSTR(SYS_CONNECT_BY_PATH(tb.name,'->'),3) name2 FROM table tb3 START WITH nvl(tb.parentid,0)=04 CONNECT BY PRIOR ID=mt.parentid 5