Oracle

The solution is as follows: 1-from the command prompt, stop ISQLPLUS: C: \> isqlplusctl stop 2-assuming that you install Oracle under C drive, run the following comands: C: \> set ORACLE_HOME = c: \ oracle \ product \ 10.2.0 \ db_1 C: \> set

From: http://hi.baidu.com/andyloolu/blog/item/a64f0ed12cc10738960a165a.html In Oracle, you can define package variables. Many people are not very clear about the use of package variables. First, let's look at the following example: Create or

By default, a PL/SQL external is installed.Program(EXTPROC) Entries in listener. in ora, It is a listener that Oracle calls the default configuration of external programs. Its name is EXTPROC or plsextproc, but it is generally not used and can be

[Problem description] The prompt "Oracle not support parallel transaction" is displayed when you call Dal to execute the stored procedure and write data to the database" [Error cause]1. When a transaction does not end and starts another

1. Understand Oracle External tables External table definition: The structure is stored in the data dictionary, and the table data is stored in the OS file. Purpose: query the OS file data in the database and load the OS file data to the

I. Concepts 1. Database) What is a database? A database is a set of data that is organized according to a certain data model and stored in the second-level memory. This type of data set has the following features: it serves as many applications as

Oracle Streams Advanced Queuing (AQ) is a robust and feature-rich message queuing system integrated with Oracle Database. when an organization has different systems that must communicate with each other, a messaging environment can provide a

How is the Oracle consistent gets calculated? 1. Single Table Scan SQL> execute show_space ('test1', 'wwj '); Unformatted Blocks ...... FS1 Blocks (0-25) ...... FS2 Blocks (25-50) ...... 1 FS3 Blocks (50-75) ...... FS4 Blocks (75-100) ......

DBAs often encounter unlocking Oracle users in their daily work. This article describes how to unlock Oracle users using the command line, you can use several simple unlock statements to complete this task. The specific process is as follows: Scott

I haven't written anything for a long time, because I haven't encountered any problems for a long time. Once and again, I think that Oracle's omnipotent paging is quite refreshing. Today I finally encountered a problem. Oracle can use SQL

There is a project in the company that uses SQL2000 as the transfer station, updates data from the source database server (SQL2000) to the target database server (oracle 10 Gb), uses the link database, and implements it through the storage process.

During the past two weeks, I have been busy with the migration of databases. When I did not do it, I felt it was very easy, but I was dumpfounded when I did it. This tangle, Here we will first talk about the problem:1. Database Table Structure

1. The case when expression has two forms: Copy codeThe Code is as follows: -- simple Case Function CASE sex WHEN '1' THEN 'male' WHEN '2' THEN 'female' ELSE 'others' END -- Case search function CASE WHEN sex = '1' THEN 'male' WHEN sex = '2' THEN

The following error is always reported when you manually configure the EM of Oracle11g: WARNING: ORA-00001: uniqueconstraint (SYSMAN. PARAMETERS_PRIMARY_KEY) violated ORA-06512: at "SYSMAN. EMD_LOADER", line4986 ORA-06512: atline1. No solution was

During the development process, you may often encounter some tests. At this time, you may want to understand the testing process and analyze the code Errors Based on the process. In this case, you need to use custom exceptions. For more information,

If a lock wait occurs, we may want to know who has locked the table and who has waited.The following statement can be used to query who has locked the table: Copy codeThe Code is as follows: SELECT/* + rule */s. username, Decode (l. type, 'TT',

When running the program today, enter the SQL statement in Oracle: select * from USERS AsU, program error Input select * from USERS u to query the result normally. However, in SQL Server 2005, enter ''select * from USERSAsThere is no error in

1. The ORACLE parser processes the table names in the FROM clause in the order FROM right to left. Therefore, the table written in the FROM clause (basic table driving table) will be processed first. When the FROM clause contains multiple tables,

Delete deletes a large table. It is not released between time and space. It is very slow because it occupies a large amount of system resources and supports rollback. The space is also occupied by this table. Truncate table Name (tablespace is

SQL> show all -- View all 68 system variable values SQL> show user -- display the current connected user SQL> show error -- Display error SQL> set heading off -- disable the output column title. The default value is ON. SQL> set feedback off --