Oracle

Instance: Create a userinfo database table: Of course you can write it like this:Drop table userinfoCreate Table userinfo(Englishname varchar (30 ),Chinesename varchar (30 ),Sex varchar (10 ),Age int,Birthplace varchar (100 ),Birthdate date

1. Prerequisites: The Oracle client has been correctly installed. 2. Install sqlplus 3. Find the Oracle/product/10.2.0/db_1/Network/admin/tnsnames. ora file and append it to the file: Connection configuration name =(Description =(Address_list

This articleArticleI saw it in a book, added my understanding, and shared it with everyone... Oracle scans tables in two ways: A. Full table scan. In this way, Oracle scans data from the first record of the table in order. B. rowid is used.

1. If If the Oracle tnslistener service is not started Net start oracleoradb10g_home1tnslistener 2. Shutdown Sqlplus sys/oracle10 @ tstdb as sysdba @ C:/stop.txt 3. startup Sqlplus sys/oracle10 @ tstdb as sysdba @ C:/start.txt The content

Oracle configuration file introduction: Profile file, oratab file, database instance initialization file initsid. ora, Listener Configuration File, sqlnet. ora file, tnsnames. ora File 1.2 introduction to major Oracle configuration

Drop table test; Select count (*) from test;-- Create a test tableCreate Table Test(ID number (9 ),Nick varchar2 (30)); -- Insert Test DataBeginFor I in 1 .. 100000 LoopInsert into test (ID) values (I );End loop;Commit;End; Select * from test; --

First, popularize the basic concepts: PL/SQL is a programming language that combines Procedural language and Structured Query Language (SQL. The PL/SQL block corresponds to a small piece of code. Applicable instructions: 1. Sometimes you may need to

Function Name: wmsys. wm_concat Purpose: Separate the values of the join columns with commas (,). Oracle 10 Gb introduction. Wm_concat can be used directly. The following describes the actual usage conditions. Create a test table and some test data

1. Open "Control Panel", select "add Hardware", and then select "Next ". 2. Select "yes". I have connected the hardware and then select "Next ". 3. Select "Add a new hardware device" from the installed hardware list and select "Next ". 4. Select

Dba_xxx requires the permission to view the reports and views. Otherwise, the reports and views do not exist. 1. query all users (username, tablespace Information) Select * From dba_users; select * From all_users; // select * From user_users; 2.

Http://database.51cto.com/art/200703/41790.htm First, the table below describes the ing relationship with the DB2/400 data types, which is a one-to-many relationship. The specific ing relationship should be analyzed for specific issues. Note: The

In some cases, you need to relocate multiple ORACLE data files and log files or migrate them to new partitions or locations, such as insufficient disk space or special requirements. In this case, you can migrate multiple data files or log files in

Using shell scripts to monitor and manage Oracle databases will greatly simplify DBA workload, such as common instance monitoring, monitoring, and alarm log monitoring, and database backup, AWR report automatic mail, etc. This section describes how

In Oracle RAC, in addition to the TAF Method Based on the client, there is also the TAF Method Based on the server. You can regard the TAF method of the server as an upgraded version of the TAF method of the client. The TAF of the server must be

Migrate database from single instance to Oracle RAC # Preparation before restore# Backup database# Check listener# Check ASM disk group free space is sufficient.# The following steps was completed sucessful on Oracle 10g RAC + SuSE Linux

Today I encountered a problem: Code: select row_no, roleid, roleName from (select roleid, roleName, rank() over(order by sum(decode(roundrs, 1, 40, 2, 20, 3, -10, 0, 20, 0)) + 50 desc, sum(decode(roundrs, 1, 1, 0)) desc,

As we all know, to connect to Oracle using PL/SQL, you need to install the Oracle client software. Have you ever wondered whether to directly connect to Oracle without installing the Oracle client? You only need to download a software named Instant

From: http://blog.csdn.net/pan_tian/article/details/7699599   Another Oracle product was installed in the past two days. After restarting, it was found that the listening listener could not be started. After reinstalling the product, it was normal.

1. Data Definition Language (DDL): these commands are mainly used by database administrators to create and delete database entities. For example: Create, alter, drop, and so on; 2. data manipulation language (DML): data manipulation language inserts

1. Obtain the values of 6th to 10th records in the table.1.1 Method 1: Use the minus statementAssume that the DDL statement is as follows: The following is a reference clip: CREATE TABLE T(ID VARCHAR2(4） PRIMARY KEY， VALUE INT) The first method