Oracle

First case: When multiple database instances of the Oracle Application correspond to one listener, After configuring the listener and the local net service name, follow these steps: 1. Set the environment variable of oracle_sid (Instance name),

  Below I will test the main data access methods of the Oracle database on the. NET platform. The following is a test table:   Create Table customers ( "Customer_id" number not null, "First_name" varchar2 (255 char) not null,

ArticleDirectory   Version: Oracle 9i 9.2.4.0Since oracle is installed on an intranet machine and uses broadband to connect to the Internet, the external database needs to map out the Oracle port for remote connection. It was thought that it

I recently started a project and want to use ORACLE again. In fact, I don't like Oracle very well. Maybe it's something I'm used to in ms. One problem is that we need to insert data into the data table to implement auto-increment numbers like SQL

The problem occurs: The data found from the Oracle database is displayed locally ????, Garbled. Solution Process: after the previous articleArticleAn Oracle client is installed locally, and this error is reported when you connect to the server

1. Install PLSQL developerProgramOr toad for Oracle;2. Decompress oracle_instantclient_10_2.rar, modify the reg. reg file, and change the values of "LD_LIBRARY_PATH" and "tns_admin" to the decompressed path.3. Set the environment variables and

1. Download instantclient2. Create a network \ ADMIN path in it3. Create a tnsnames. ora file with the following content: Orcl =(Description =(Address = (Protocol = TCP) (host = 192.168.1.14) (Port = 1521 ))(CONNECT_DATA =(Server =

Ex1: Rightobject is the collection type of userid, righttypeid, userdutyid, rightid, rightflag Create or replace type "rightobject" as object(Userid number,Righttypeid number,Userdutyid number,Rightid number,Rightflag number) Rightobjectcollection

1. Oracle Installation Please refer to the following link for more information: http://wenku.baidu.com/view/d01ffd43336c1eb91a375d68.html. 2. Use the command line sqlplus to connect to Oracle (1) Check the listening status C: \> LSNRCTL

Data export: 1. Export the database test completely, and the username System Password Manager is exported to D: daochu. dmp. Exp system/manager @ test file = D: daochu. dmp full = y 2. Export the tables of system users and SYS users in the

Oracle solves Chinese Character Display and input Problems When installing on an oracle 8.0/2000 machine, select English as the language (the user's machine selects Simplified Chinese), and then use Regedit to edit the registry, select "software>

When using PLSQL to connect to XP today, the system prompts that the TNS connection failed. After searching online, the problem is finally solved. The method is as follows: I started the firewall that comes with XP on my XP, and opened port 1521 of

I. Use rownum and pseudo Columns As rownum alone cannot sort queries, the following is a simple example: Select username, rownum from dba_usersWhere rownum Username rownum--------------------------------Outln 3Sys 1System 2 In this way, the problem

Operator Optimization The SQL statement written in is easier to write and understand, which is suitable for modern software development. However, SQL statements using in always have low performance. The following differences exist between SQL

Today I want to query all the table names in the Oracle database or all the tables in a user. I haven't thought about it for a long time. I still found the answer online. Select table_name from all_tables; // AllSelect table_name from

1 If... then If condition then Statements 1; Statements 2; .... End if; 2. If... then... elseIf condition thenStatements 1;Statements 2;....ElseStatements 1;Statements 2;....End if; 3. If... then... elsifIf condition1 thenStatement1;Elsif condition2

View and modify the character set on the Oracle server: Method 1: 1) view the server character set: Select * from V $ nls_parameters; Select * From nls_database_parameters; Select * From SYS. Props $; 2) modify the server character set (sys user

A function is a program with zero or multiple parameters and a return value. Oracle has a series of built-in functions in SQL, which can be called SQL or PL/SQL statements. functions are mainly divided into two categories: single-row functions and

Oracle uses regular expressions without these four functions: 1. Regexp_like 2. Regexp_substr 3. Regexp_instr 4. Regexp_replace You can probably see what the function name is.   Regexp_likeIt can only be used for conditional expressions,

Chapter 2 triggers 2.1 create a trigger Create trigger [schema.] trigger_name {Before | after} {update | insert | Delete} on [schema.] table_name [[Referencing correlation_names] for each row [When (condition)] Declare Declaration Begin PL/SQL