Oracle

Select To_char (sysdate, ' yyyy-mm-dd hh24:mi:ss '), To_char (Trunc (sysdate), ' Yyyy-mm-dd Hh24:mi:ss ') from dual T;--sy Sdate and Trunc (sysdate) are not the same sysdate at zero of the day 0 minutes 0 seconds equals trunc (sysdate) Select Trunc (

Unix/linux topic: 1. How to view host CPU, memory, IP and disk space? cat /proc/cpuinfocat /proc/meminfoifconfig –afdisk–l2. What are your common process management and host Performance view commands?Ps–efIostat3. Set up DBA and reorganize user

A transaction is a logical unit of work used to split a database activity, where the transaction has a starting point and an end point;When one of the following events occurs, the transaction begins: Connected to the database and executed

1. Use the top command to see the SPID numbers with the most productive resources first2. Query the current time-consuming session ID, user name, Sqlid, etc.: Select sid,serial#,machine,username,program,sql_hash_value,sql_id, To_char (Logon_time, '

An execution plan is a series of commands that tell Oracle what access method to use for each Table object and what join and join order to join multiple tables together. Each step in the execution plan produces a row source and then joins with

Quoted http://blog.csdn.net/lejuo/article/details/4479065The ID is automatically incremented, just like when you create a table in Ms-sql server, the primary key for the table is set to auto-increment.In Oracle, the following SQL statements are

This case is the coffee sales situation input query systemFirst, the data input system:1. Design the Input Information pageThe code is as follows: Coffee Management System--input system Welcome to Input System Coffee name: Suppliers Id:Product Price:

select sysdate from dual t;--system date Select To_char (sysdate, ' yyyy/mm/dd HH24:MI:SS ') From dual t;--formatted date Select To_date (' 20140630 18:28:20 ', ' yyyy/mm/dd HH24:MI:SS ') from dual t;--formatted date Select

1. Install CRS failure, or perform root.sh error, possible causes:　　(1) Time between nodes is out of sync, workaround: Use NTP service (2) The default firewall is enabled under Linux, resulting in execution of root.sh error: Failure at final check

Reprint: Source http://www.2cto.com/database/201209/154722.htmlTo set the Oracle PL/SQL Time display format Nls_timestamp_format the display format of TIMESTAMP time in Oracle Oracle database Time field We usually use the TIMESTAMP format, before

"Cause/Trigger factor" This is due to the fact that "password_life_time=180 days" is set in the default profile in oracle11g. "Impact and risk" Effect After the password expires, the business process connects to the database exception, affecting

See a lot of examples on the net is basically the same, no too much explanation, for a beginner MySQL is a bit difficult, I transferred part of the following text: http://www.cnblogs.com/buro79xxd/archive/2012/08/29/2662489.htmlTarget: 1. Identify

Prompt for "record locked by another user" workaround when deleting data in Oracle data:1, check the database lock, the source and type of diagnostic lock:Select Object_id,session_id,locked_mode from V$locked_object;or use the following command:

When the data in the table is deleted, it does not actually delete the data, but instead hits a delete tag, which can be restored as long as it has not been overwritten. The experimental process is as follows:[Email protected]>create table bbed_test

This is an Oracle's column change function: Listagg ()Look at the sample code first:With temp as ( select ' China ' Nation, ' Guangzhou ' to dual union ALL Select ' China ' Nation, ' Shanghai ' city F ROM Dual UNION All Select ' China ' Nation, '

The Oracle database, MERGE into statement, often appears ora-30926:unable to get a stable set of rows in the source tables this error, as shown in:After checking, this error is caused by data duplication in the data source table (that is, the table

Parallel query of Oracle uses multiple Server processes at the operating system level to complete an SQL query at the same time. This article describes how to solve an error in parallel query of Oracle databases as follows: 1. Error description

Problem: In the SQL Server database, the attribute of the auto-incrementing column is convenient to use. But Oracle does not have this function. How can this function be implemented? A: Although there is no auto-increment column in Oracle, it can be

1. USEREVN ()   Return the information of the current user environment. The opt can be: ENTRYID, SESSIONID, TERMINAL, ISDBA, LABLE, LANGUAGE, CLIENT_INFO, LANG, VSIZE.   1. Check whether the current user is a DBA. If yes, return true SQL> select

Enter the command: alter system set utl_file_dir = '/home/oracle/logmnr' scope = spfile; Error: Error cause: No spfile file is used to start the database. Solution: Start the database with the spfile file. 1: Enter the $ ORACLE_HOME/dbs path