Oracle

question one: How to reset the Oracle sequenceAfter the Oracle sequence is created, if you want to reset the sequence starting with 0 and gradually increment by 1, you can use the following stored procedure:Create orReplace procedure reset_seq(p_seq_

MSSQL2008R2 Link ORACLE 11:To create a link:exec sp_addlinkedserver ' dblink_oracl ', ' ORACLE ', ' msdaora ', ' ORCL120 'Where ORACL120 is the local installation of the Oracle driver, after Tnsnames.ora configured the link string operation, and to

If there are now three nodes in the RAC cluster C1, C2, C3:If you want to uninstall the C3 node.1. Delete the C3 instance on C1 or C2Run DBCAThen select Oracle Real application Clusters DatabaseSelect Instance ManagementSelect Delete an

In Oracle in the sequence serial number is called, every time, it will take the initiative to increase itself, by the sequence number needed to sort the general use.1. Create SequenceYou must first create sequence or create any sequence

Since the system is a modification of the former batch system, it is necessary to partition the table1, has established the non-partitioned table, cannot make any table partition operation, such as: Add, delete, merge, split can not operate2, the

I've been doing cloud projects with MySQL database for a while, and there was a time when I had no contact with Oracle, and yesterday I had a friend who asked me to help with Oracle's need to process an attendance record, and I spent some time

Basic Concepts of Oracle Database1. PL/SQL (procedural language/sql) is a procedural language extension of Oracle Corporation's standard language SQL for relational databases.PL/SQL possesses features that are not ①: variable definition;② control

Set head offSet Lin 150Set pages 0Set Long 10000Select TEXT from User_source t where T.name = upper (' get_car_status_new ') Order by TYPE, line;=======================Set pages 0Set Longchunksize 3000Set Long 2000000000Set head offSet Linesize

Reprinted from: http://blog.csdn.net/nsj820/article/details/6573525 a >, Oracle database startup mode1 , startup Sql*plus not connected to the databaseSqlplus/nolog2 , connect to Oracle with SYSDBA roleCONNECT Username/password as SYSDBA3 , launch

Set Linesize 120Set PageSize 20Column file_name format A8V$nls_parameters a table in the data dictionaryNote about NULL:1: Empty expression with null result2: Determine whether a value equals null is used is does not equal with IS. Remember

CREATE TABLE "Brand_relation"("ID" number (10,0) is not NULL ENABLE,"CATID" number (10,0) is not NULL ENABLE,"brand_id" number (10,0) is not NULL ENABLE,PRIMARY KEY ("ID"));CREATE SEQUENCE "Br_id_seq" NOCACHE;CREATE INDEX "Br_catid" On

Oracle processes the attendance time, splits the SQL statement of the attendance period, and oraclesql I have been using mysql databases for cloud projects recently, but I haven't been in touch with oracle for some time. Yesterday, a friend asked me

Which linker and compiler are used when relinkOracle software is used? Which linker and compiler are used when relink Oracle software is used? Reference:Required linker and compiler locations (Document ID 1012798.6)Problem Description:===============

Meaning of Port-Specific in mos The meaning of Port-Specific in mos. Today, a buddy said a bug with the bug no. Bug 16884689. The key point is not the bug. The key point is that the bug is described as follows: it affects the platform

Oracle Database startup problems caused by a loss of the registry project in the Windows registry. Oracle Database startup problems caused by a loss of the registry project in the Windows registry. Environment Description:1. windows 2008 operating

Create dblink and scheduled tasks in oracle Recently, we are working on a task, specifically, to regularly insert data to the middle table of another user's database. The first thing we need to do is create an oracle dblink to the other database to

Data cleansing Note: determines whether it is a date function Background] When extracting data from a certain date, it is found that a large amount of non-date data exists, and spam data (non-date data) needs to be cleaned ).   [Solution] Write a

Operations on tables in oracle The basic creation will not be mentioned. Here we will talk about some uncommon methods, which means they are easy to use. Create a table using a subqueryCreate a new book table using a subquery. Step 1: completely

Oracle 11g cannot connect to reporting ORA-12537 + ora-609 resolution, ora-12537ora-609 Operating System: windows2008 Database: oracle11g Problem: an application system that has been running normally for a year suddenly cannot connect to the

Oracle cursor, process, and reference type 0. Common functions Substr (str, start, length); // reverse indexes can be performed. If length is not specified, it ends with to_number (str); // str to numberselect to_char (sysdate, 'yyyy-mm-dd hh24: mi: