Oracle

Table: -- Create TableCreate Table location(Loc nvarchar2 (15) not null,Description nvarchar2 (40 ),Userid nvarchar2 (20 ),Createby varchar2 (30 ),Createtime date,Modifyby varchar2 (30 ),Lastmodifytime date,Storearea_code varchar2 (4 ),Storekeeper

After the client of oracle8 or later is installed, oledb for Oracle of ADO cannot be used. However, the client that used 8 and 8 I has never had this problem. The solution is finally found today. Cause: http://msdn.microsoft.com/en-us/library/ms15251

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

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

In actual work and study, many people need to export and back up the Oracle9i database. In this article, we will introduce a method for automatic execution:Step 1:Open notepad and enter:Exp test/test @ test file = D:/backup/% Date :~ 0, 10%. dmp log

Today, I found a strange problem when I wrote an oracle statement. I had to find the cause for a long time. Ask Daniel for help. The problem is simplified as follows: Select seq, info, topic from system. Help where seq in (select distinct seq from

Some time ago, when I used Oracle 10 Gb for import, a very strange error occurred, and I found no cause or solution for a long time, After the system was re-installed, Oracle10g 2 was re-installed and the data was re-imported. However, this error

Assume that the following vertical table exists. The first column is the ID of a business data, the second column is the type, and the third column is the value corresponding to the type, for example: As shown in the preceding table, there are

The default number of connections in Oracle Xe seems to be 40. If the process exceeds this number, the request for a connection again will be rejected. 1. Log On with the System user: Sqlplus system/password @ XE 2. Run the following command:

SQL> -- 09. query the sales staff ('slesmance') whose salaries are higher than the average (the average salary includes all employees ') SQL> select * from EMP where job = 'slesmance' and Sal> (select AVG (SAL) from EMP); SQL> -- 10. show the

I. Introduction Super Large systems have the following features: 1. Generally, the number of users processed exceeds 1 million, and the number of users processed exceeds 10 million. The data volume of the database generally exceeds 1 TB; 2. The

1) assignedThe primary key is generated by an external program and does not involve hibernate. 2) HiLoThe primary key generation mechanism implemented by the HI/lo algorithm requires additional database tables to store the primary keyKey Generation

Create or replace procedure p_tx_getfaxdata()AsV_errorcode number; -- error codeV_errormsg varchar2 (200); -- error message displayV_currentuser varchar2 (8); -- Current Database UserV_information varchar2 (100); -- error information Begin // Do the

Oracle uses on Delete cascade and on Delete set null to create a foreign key This section describes how to use the default Oracle creation method when creating foreign key constraints. When you delete referenced data, the data cannot be deleted,

--------- Mathematical functions 1. Absolute ValueS: Select ABS (-1) ValueO: Select ABS (-1) value from dual 2. INTEGER (large)S: Select ceiling (-1.001) ValueO: Select Ceil (-1.001) value from dual 3. Round (small)S: Select floor (-1.001) ValueO:

  In database operations, I often encounter the problem of using random numbers. A few days ago, Xiang Ge asked me about SQL Server's batch generation of random numbers. I remember that he also asked me questions about random numbers under oracle,

Common Data Dictionary queries for ORACLE users View the default tablespace of the current user SQL> select username, default_tablespace from user_users; View the role of the current user SQL> select * from user_role_privs; View the system and

Converts the clobe field in oracle to the String type for ease of use.View Code 1/** 2 * convert clob type data to string type. 3 * Author: Mother Yushan 4 * Time: 2012-6-6 5 * @ param clob 6 * @ return 7 * @ throws SQLException 8 * @ throws

The first day of a month    SELECT to_date(to_char(SYSDATE,'yyyy-mm')||'-01','yyyy-mm-dd')FROM dual Sysdate is the current system time of the database server.To_char is a function that converts a date type into a date type.To_date is a function

// Add two references firstUsing System. Data. OracleClient;Using System. Data; String ConnectionString = "Data Source = sky; user = system; password = manager;"; // write the connection stringOracleConnection conn = new OracleConnection