Oracle

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 */

1. Let's start with a fully preparedrman> backup database ; starting backup at 2015/07/09 13:40:47allocated channel: ora_disk_1channel  ora_disk_1: sid=28 device type=diskchannel ora_disk_1: starting full 

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

Wrote a complex SELECT statement, suddenly Oracle reported: ora-25153 temporary table space is empty, this error, and then the online search, found the following workaround: Create a new temporary tablespace.First you have the system permission, log

Network topologyOtdadmin 192.168.3.101Node1 192.168.3.201Node2 192.168.3.202 Virtual IP 192.168.3.200System version;olinux6.4Turn off firewall chkconfig iptables offService Iptables StopTurn off SELinuxVim/etc/selinux/configSelinux=disabledInit

-function functions like a black box (see the inside of the structure), there are parameter return values, you can do a certain function for us.-Single line This function evaluates each row in the result once, each row returns a result, and the

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

Today, after installing Oracle in the CentOS virtual machine, you are ready to connect the instance on the Oracle server (CentOS virtual machine) and display it as an idle instance, start command start failed. The error is as follows: [Email

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/

If you are reinstalling Oracle and the Setup program is running, please close it first.Full Uninstall:1, stop all Oracle Services 2, through the Start menu Oracle installation products, Universal Installer Run the Oracle Uninstall Tool 3, run the

1 Cascade DeleteOracle Delete on foreign keys has no action (similar to restrict), cascade, and set null three behavior.Below the student-class as an example to explain the foreign key deletion under different circumstances, students belong to the

(Related data integration)First, overall, this is a connection string to the Oracle database, indicating the URL of the connection database, which can be understood as three-part-〉 Protocol (JDBC): Sub-Protocol (Oracle:thin): Data source

　　--addition SelectSysdate,add_months (Sysdate, A) fromDual--plus 1 years SelectSysdate,add_months (Sysdate,1) fromDual--Add January SelectSysdate,to_char (sysdate+7,'YYYY-MM-DD HH24:MI:SS') fromDual--plus 1 weeks . SelectSysdate,to_char (sysdate+1,'

Some time ago received a response from the Shenzhen colleague, there is an Oracle cluster load is too high, in order to troubleshoot the problem, the system has restarted, but after the system restarts, 6 of the quorum disk is lost.To find out why,

Turn from:http://blog.csdn.net/lyc_daniel/article/details/44195515VirtualBox inside there is a home button, note that the home key is not necessarily a keyboard home, but set a key, the default right ctrl is said home, sometimes set their own do not

Believe that this error is not unfamiliar to everyone, as long as the installation of the use of Oracle estimates have encountered this problem, generally in the use of PL/SQL connection to the Oracle database occurs.The cause of this error and the

After the Oracle 11g database is installed today, connecting to the database with Plsql is not connected. Also, the Database drop-down box for the Plsql Client login window is empty. See: Oracle services and monitoring are turned

Oracle foreign key cascade deletion and cascade updateCascading Deletion Oracle has three behaviors: no action (similar to RESTRICT), CASCADE, and set null. The following uses the student-class as an example to describe how to delete Foreign keys in

ORACLE: view the objects contained in the data file. oracle: view Data Objects In the previous article on ORACLE tablespace object viewing, I introduced how to query the database objects in a tablespace. Can we check whether a data file contains