Oracle

In the development of data integration, it is often necessary to create views for each other so that they can view some of the necessary data. Create a user in the database and assign permissions to the user to query the viewFirst, SQL

Oracle table structure and table content difference comparisonThere are three sets of operations in Oracle, and they will set the left and right select result sets. Union and set Intersect intersection Minus difference Set

1. Configure Environment variablesVim/etc/profileExport Oracle_sid=orclexport oracle_base=/app/oracleexport oracle_home= $ORACLE _base/product/11.2.0/dbhome_1export Path= "$ORACLE _home\bin:/usr/local/bin: $PATH"Reboot make configuration effective2.

Oracel startup failure resolved due to power outage1 attempt to recover database failed2. Create a control fileSql>alter database backup Controlfile to trace$ls-LRT trace/Find the latest. TRC, and copy Resetlog to create the control fileSql>shutdown

Create userOverview: In Oracle, to create a new user using the Create USER statement, you typically have DBA (database administrator) permissions to use.Create user username identified by password; (Oracle has a problem, the password must start with

Today in the work encountered a query in recent years, the problem of data, Oracle comparative slag slag, learning a bit.As an example:For example, I would like to see the employee entry status of the company, and then make a trend statistics.See

ObjectiveThe date/time of this article is all formatted as "2016-01-01 01:01:01"; monitor_time is the database table field;string and date/time Mutual conversion function OracleDate/Time -to-string function: To_char (t.monitor_time, ' Yyyy-mm-dd hh24

Method one: Offline table space1, offline table space: Alter tablespace tablespace_name offline;2, copy the data file to the new directory;3, rename Modify the table space, and modify the control file;4, online table space;1. Offline table Space

Method one: Offline table space1, offline table space: Alter tablespace tablespace_name offline;2, copy the data file to the new directory;3, rename Modify the table space, and modify the control file;4, online table space;1. Offline table Space

The tool used here is rlwrap.You can learn more about http://utopia.knoware.nl/~hlub/uck/rlwrap/in this linkwget http://utopia.knoware.nl/~hlub/uck/rlwrap/rlwrap-0.42.tar.gzYum install-y ReadLine Readline-devel This is dependent on theTar XF rlwrap-0

Finally, the installation of ASM and RAC was started.Getting ready to work under LinuxVi/etc/selinux/config-------permanently off SELinuxselinux=disabled--------and then restart the serverChkconfig iptables off reboot permanently shut down the

Reprint Address: http://www.cnblogs.com/kerrycode/p/3285936.htmlTemporal table ConceptsA temporary table is a database object that is used to temporarily save temporary data (or intermediate data), which is somewhat similar to a normal table, but is

There is a top keyword in SQL Server that makes it easy to take out the top N records, but there is no use of top in Oracle, and a simple way to implement the first N records is as follows:Method 1: Use the Row_number functionRemove the first 5

64-bit operating systems are commonly used at the PC end, 64-bit operating systems are better than 32-bit performance, but not as compatible as 32 operating systems, Oracle offers 64 and 322 versions, and Plsql tools are only 32 bits. In this

Solution 1 (actual measurement possible):SYS and SYSTEM user's username and password remember? TryIf not, log on locally with Sqlplus on the server%sqlplus/as SYSDBASql>alter user system identified by Oracle;Then use the system user name, password

Select A.user_name,Decode (A.sex, 1, ' Male ', 2, ' female ') as SEX,A.head_portrait,TRUNC (Months_between (sysdate, A.birthday)/12) | | ' Old ' as BIRTHDAY,Z.disease_nameFrom T_patient_info ADescription: Decode numeric match field, write to SQL

Water and Electricity Payment management system data Sheet DesignSQL Build Table Script: 1--Build Table 2--Manage People Table admin 3 CREATE TABLE admin (4 admin_id varchar2 (3) NOT NULL, 5 admin_loginname VARCHAR2 (8) NOT NULL, 6 Admin_password

Five types of constraints in the databaseFive kinds of constraints in   database and their adding methods five constraints 1.--PRIMARY KEY constraint (Primay key coustraint) uniqueness, non-nullability  2.--unique constraint (unique counstraint)

User Rights Management methods for Oracle SQL basic operationsRecently put things about user operations and Rights management, although a lot of blogs have a similar collation, but they found their content is more or less a bit wrong. So, I

1, the MySQL log file system composition2. Slow query log3. Slow Query Log DemoLong_query_time: Set the threshold of the slow query, the SQL that exceeds the sub-set value is logged to the slow query log, the default value is 10sSlow_query_log: