Oracle

Last month's date: select last_day (add_months (sysdate,-1) from dual;Last second of the month: select trunc (add_months (sysdate, 1), 'mm')-1/24/60/60 from dualDate of the week: select trunc (sysdate, 'day') + 1 from dual Days from the beginning of

Exec and call usage When exec and call execute a procedure, DeclareS_in varchar2 (30): = 'where col = 13 '';V_ SQL _str varchar2 (200 );BeginV_ SQL _str: = 'select * from t1' | s_in;Execute immediate v_ SQL _str;End; Exec is a sqlplus command and

Oracle uses regular expressions without the following four functions: 1. Regexp_like2. Regexp_substr3. Regexp_limit 4. Regexp_replace you can probably guess what the function name is.Regexp_likeIt can only be used for conditional expressions,

The document details the process of restoring data to a customer. The cause is that the disaster cannot be recovered due to missuperposition. When the customer first asked me for help, I told him that we could recover the data by bringing the hard

This article introduced in detail about oracle ORA-3136, ORA-609 method, there is a need for friends can refer to this article Oh. Fatal NI connect error 12170. Version information:TNS for 64-bit Windows: Version 11.2.0.1.0-ProductionOracle Bequeath

This article briefly introduces how to solve the ORA-27101, ORA-27102 errors in the use of oracle, students who need to learn can refer to the lower. The error message is as follows: ORA-27101Shared memory realm does not exist Cause: Unable to

This article introduces a ORA-27125: unable to create shared memory segment solution for oracle databases in linux. Platform environment: Linux Red Hat Enterprise Linux Server release 6.0 (Santiago) Database Version: Oracle Database 10g Enterprise

In the oracle database, we will use the replace function to replace strings. The following describes how to use replace () in oracle. For more information, see. Usage REPLACE (char, search_string [, replacement_string]) Char: string to be

This article to introduce to you about Oracle Database Error prompt: Ora-01791 is not the Selected expression solution, there is a need to know friends can enter the reference. Today, I encountered an error while investigating the original code,

Content Software Environment This example converts a number into a spelling.  Software Environment Windows Server 2008 R2 Oracle 11g Release 1 (11.1)  This example converts a number into a spelling. decode(sign(&num), -1, , 0, )

The newly installed oracle9i can still be used last time. This time it suddenly won't work. [Oracle @ R39i oracle] $ sqlplus scott/tiger SQL * Plus: Release 9.2.0.4.0-Production on Mon Nov 24 11:06:50 2008 Copyright (c) 1982,200 2, Oracle

Since we will look at ORACLE recursive queries, we should be clear about what recursion means. Here I will not explain it more, but I will just give a brief introduction. The so-called recursive query makes the data structure in the data table

                (1) normal user: SCOTT (password: tiger) (2) General Administrator: SYSTEM (password: manager) (3) Super administrator: SYS (password: change_on_install)   After Oracle is

Use the dbstart and dbshut scripts to automatically start and close the database:1. log on to the user root.2. Edit the oratab file of your platform.Open the/etc/oratab file:The database entries in the file are in the following format:SID:

1. installation environment: Linux: Redhat Enterprise Linux 6.3 64-bit Oracle: Oracle Database 11 GB for Linux x86-64 64-bit 2. Modify core operating system parameters Perform the following steps under the Root user: Modify the user's SHELL

In database management, DBA may encounter insufficient disk space, which is common.-- 1. view the percentage of tablespaces in use. SQL codeSelect. tablespace_name,. bytes/1024/1024 "Sum MB", (. bytes-b.bytes)/1024/1024 "used MB", B. bytes/1024/1024

Change the oracle user name Previously there was a need to organize a schema table, index, and so on into a tablespace, and use expdp/impdp to complete the remap, but the user name remap changed, if the application does not want to modify its

1. Configure the connection pool to enter the Management console through http: // localhost: 7001/consoleIn the left-side menu, choose mydomain (custom Domain Name)> service> JDBC> connection buffer pool.Click "configure a new JDBC Connection Pool ..

Normally, when you create a record in a table, the database system writes the data to the block and provides a ROWID value like this row of records. This value records the location of the record stored on the hard disk. This is also true when

In the article parsing the relationship between v $ tempfile and v $ sort_usage, we noticed that for the absolute file number (AFN) of the temporary file, the Oracle allocation rules are different from those of the conventional data file. In fact,