Oracle

The new technology is too fast, the old machine wants to install an operating system, in the development department is only the Windows 2008 installation disk, installation of Windows 2008 is very fast, and not the personnel settings, but the

A sequence is a database object that can be used to generate a unique integer. You typically use sequences to automatically generate primary key values. 1) Establish sequence command CREATE SEQUENCE [user.] Sequence_name[Increment by n][Start with N]

For more information, see Oracle Official Documentation:Managing the Online Redo LogAdvice: Perform a database full backup prior to the following operations control file backupQuery logfile Related information:Query log file location and statusSql>

When you use an Oracle sequence to generate table primary key values, you may encounter values that modify the corresponding sequence based on the primary key value. The following stored procedures p_modify_sequences accomplish

Original Transmission gate: http://blog.csdn.net/wh62592855/archive/2009/11/06/4776631.aspx Remember before in the forum to see Inthirties used with as the word, at that time did not particularly care. Today in a post and see someone use this, so

Case expressions can implement If-then-else logic in SQL without having to use Pl/sql. Case works like Decode (), but case should be used because it is compatible with ANSI.There are two types of expressions in the case: 1. A simple case expression

Procedure returns the recordset: CREATE OR REPLACE PACKAGE pkg_test As TYPE Myrctype is REF CURSOR; PROCEDURE Get (p_id number, p_rc out myrctype); End Pkg_test; / CREATE OR REPLACE PACKAGE body pkg_test As PROCEDURE Get (p_id number, p_rc out

1, to detect the rollback segment contention Select sum (gets), sum (Waits), sum (Waits)/sum (gets) from V$rollstat; The sum (Waits) value should be less than 1% of the sum (gets) valueThe contention of the rollback segment will degrade the

The time spent preparing new SQL statements is the most important component of the execution time for Oracle SQL statements. But by understanding the mechanism within Oracle to generate execution plans, you can control the amount of time that Oracle

The difference between Oracle like and InStrInStr does not belong to a fuzzy query.From the standpoint of efficiency:Who can use the index, whose query speed will be fast.Like sometimes you can use the index, for example: Name "Lee%"The index is

in Oracle/plsql, the substrFunctions allows to extract a substring from a string. The syntax for the substrfunction is: substr(String, start_position, [length]) Description The string is the source string. Start_position is the position for

C:\>set Oracle_hostname=kingsrv C:\>emca-config Dbcontrol DB EMCA started in 2007-3-19 12:04:13EM Configuration Assistant 10.2.0.1.0 Official editionCopyright (c) 2003,%, Oracle. All rights reserved. Enter the following information:Database

This document contains almost every aspect of the use of Oracle cursors, all of which pass the test Http://www.cnblogs.com/sc-xx/archive/2011/12/03/2275084.html --Declare a cursor; CURSOR cursor_name is select_statement--for cyclic cursor-(1)

1, view the user's proifle is that, is generally default:sql>select username,profile from dba_users; 2. View password expiration settings for the specified profile (such as DEFAULT): Sql>select * from Dba_profiles s WHERE s.profile= ' DEFAULT ' and

1, if the default Value of Oracle 9i,national CharSet is installed, it is al16utf16. If you're going to replace AL16UTF16 with UTF8, According to the previous method Update sys.props$ Set value$ = ' UTF8 ' WHERE name = ' Nls_nchar_characterset ';

Pfile file The Pfile (Parameter file) file is a text-formatted parameter file that contains configuration parameters for the database. Oracle 9i establishes a pfile for each database at installation time, the default name is "init+ routine name. Ora"

(1) Initialization of passwordSYS Change_on_intallSystem ManagerScott Tiger(2) Copy a tableCREATE TABLE new_table as (SELECT * from old_table)(3) Modify the primary key of a tableALTER TABLE tablename DROP constraint a_pk;//Delete original PRIMARY

first, the basis1, Description: Create a databaseCREATE DATABASE Database-name2, Note: Delete the databaseDrop Database dbname3, Description: Backup SQL ServerDevice to create backup data---Use masterEXEC sp_addumpdevice ' disk ', ' testback ', ' C:\

Oracle Temporary table Knowledge In Oracle, temporary tables are divided into sessions, transaction two, and the session-level temporary table data exists throughout the sessions until the end of sessions; Temporary table data at the transaction

First access to Oracle website, link address: https://www.oracle.com/cn/downloads/index.htmlSlide into the interface and click Java in all DownloadsClick to enter and then navigate to the relevant Java download locationThe interface then slides to