Oracle

 I went home to access the Internet today. I was surprised that sun was acquired by Oracle! It will be mixed with Oracle later! This should be the best outcome for sun and Java. An era is over! It feels heavy. In any case, the Sun and Bea created

ArticleDirectory Use of Oracle oerr tool in Linux/untitled Use of Oracle oerr tool in Linux/untitled Oerr is a tool for Oracle to find ora errors on UNIX, which is extremely convenient.Command Format:Oerr ora error codeFor example, to view the

Q: I have no backup shard oralce and have not exported the database. Now the operating system crashes, but the files in the Oracle directory are complete. How can I fix my table? A: Create an identical database (the disk directory is the same;

The initialization parameter open_cursors in initsid. ora determines the maximum number of cursors per user. Check the parameter specified by executing the following SQL:Select * from V $ ParameterWhere name = 'open _ cursors' / If you want

Oracle 9i contains the XDB feature by default when creating a database. Once the database and listener are started, Oracle XDB includes HTTP and FTP services, listening to TCPPorts 8080 and 2100 conflict with the default ports 8080, such as JBoss

ArticleDirectory A small function for converting time and date formats A small function for converting time and date formats SQL> select to_char (sysdate, 'ssss'), sysdate from dual;To_ch sysdate------------------------62239 17:17:19Sssss:

1. Using dbms_utility.get_time S_date pls_ineteger; Ln_interval pls_integer: = 0;   S_date: = dbms_utility.get_time; -- Do something Ln_interval: = ln_interval + (DBMS_UTILITY.GET_TIME-s_date ); -- Some other things -- Ouput Interval

4.1 compile a debug package (routine) Create or replace package yang_debug Procedure out (p_comments in varchar2, p_varible in varchar2 ); Procedure erase; End yang_debug; Create or replace package body yang_debug Procedure out (p_comments in

Adding the Java engine to Oracle databases is one of the most exciting features of Oracle8i. Therefore: 1) load the Java class and source code into the database; 2) Call Java code in PL/SQL; 3) Call PL/SQL code in Java; 11.1 Oracle Java 1.

Compare SQL Server with Oracle and DB2 Source: Oracle Database Online (www.dbonline.cn)A good database is very important. This article compares three types of databases: SQL Server, Oracle, and DB2. It provides some reference for you to select a

141. How to quickly compile all views? SQL> spool view1. SQL SQL> select 'alter view' | tname |' Compile; 'from tab; SQL> spool off Then run view1. SQL. SQL> @ view1. SQL; 142. Solutions for ORA-01555 snapshot too old Increase the minextents value,

529. dba_ind_subpartitions Describes partition information, storage parameters, and Various partition statistics determined by analyze. 530. dba_indexes Description of all indexes in the database. 531. dba_indextype_comments All user-defined index

Setting Oracle to archive mode and non-archive Mode Create an archive directory manually and adjust the Oracle startup mode.Set Oracle to archive ModeManually create an archive directory on the master

Step 1: Create a new test table as follows: Create Table king(ID number (10 ),Name nvarchar2 (2000)) Step 2: Create a sequenceCreate sequence king_tb_seqMinvalue 1Max value 9999999999Start with 21Increment by 1Cache 20; Step 3: Create a trigger

Oracle trunc () function usage     1. trunc (for dates) The date value intercepted by the trunc function for the specified element.The syntax format is as follows:Trunc (date [, FMT])Where:Date: A date value.FMT date format, which is truncated by

D: \ oracle \ ora92 \ bin> sqlplus/nolog SQL * Plus: Release 9.2.0.1.0-production on Thursday August 16 11:32:22 2007 Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved. SQL> Conn/As sysdbaConnected.SQL> alter user system identified

Document directory Syntax: Example: Output: Use ohters to handle all errors Raise_application_error Function When writing an oracle stored procedure, many things are stored in the stored procedure, such as some judgments. This is much

If the table contains data, Oracle cannot modify its data type. However, you can create a temporary column, copy the data of the column to the temporary column, delete the original column, and modify the name of the temporary column. In this case,

Release date: 2007.11.22 Source: Saidi network-information center Author: Wang Mu According to a report on June November 16, Microsoft officials said that when SQL Server 2008 is released in the future, Microsoft will invest

View code 1, for example, adds a flow field to a table, which is not empty and unique. 2. The table data volume is 3000000. 3. Assume that the table name is test. 4 5 1. Use cursor. 6 declare 7 cursor c_test is select rowid from test; 8 v_test