Oracle

From: http://soft.zdnet.com.cn/software_zone/2008/0922/1144116.shtml First, we will make a supplement to the stored procedure called sqlserver in the previous article, that is, if there are insert, update, delete and other operations in the stored

1. What is the Oracle character set?The Oracle character set is a collection of symbols for the interpretation of byte data. It can be divided into different sizes and have an inclusive relationship. Oracle supports the national language

Modify the Oracle 10g character set because the database character set we just created is: we8iso8859p1 cannot import data, so we need to modify the character set. Edit Export oracle_sid = ucit (Database Sid) Sqlplus '/As sysdba' Select name,

OracleLoop statementLoopAndWhileUsage A. Loop... end Loop (Execute at least once) Please write a process. You can enter the user name and add 10 Users to Users in the table, the user number is from 1 . Create or replace procedureSp_

The system automatically renames a table deleted from Oracle as the name starting with Bin $.You can run the show recyclebin command to view the details of the deleted table or query the table:Select * From recyclebin;Command for table

In Oracle, You need to query the table where the field name is located based on the field name. This is mainly because, for example, you forget the table name, you only know that there is such a field name, and you want to find the table. In the

Database sorting rules Read the Oracle online document carefully and summarize the ordering rules. The significance of sorting rules is to display meaningful data, orderly, and meaningful. Sorting rules are essentially the requirements of

1. ASM Disk Type Select 1: bare device/dev/raw/, which requires raw service support.Select 2: asmlib management. You need to install the RPM package of asmlib in Linux and create the vol that can be recognized by ASM. 2. ASM disk management

The command is as follows: Oracle server address: 192.168.2.181 port: 1521 Username: jans2002 Password: password123 Service name Sid: dbsvr If you do not need netmgr to create a service name, you can directly write the IP address port and

There are two methods to retrieve the Sys password: 1. Verify with windows (check the oraclebasedir/ora92/Network/admin/sqlnet. ora File Sqlnet. authentication_services = (CNT) this line is not commented), and then typed SQL> connect

After Oracle Developer tool for Visual Studio 1110621 is installed, it is found that the PL/SQL developer 7.0.x TNS list disappears and the OCI DLL cannot be found during forced logon. The solution is as follows: 1. Modify the connection settings

Oracle provides an audit tool for tracking, recording, and counting all aspects of database activities! -- Sqlserver does not seem to have this function yet! Oracle audit functions Initialized parameter control: built-in Database Audit

Format is used to define the path and naming rules of backup files. Path: If it is definedDb_recovery_file_dest, The backup file is generated in this directory! If not defined, % ORACLE_HOME % \ database [DBS] will be generated in the

  Redo redo logs are as important to Oracle as the liver, and are an important part of Oracle's function of detoxifying and restoring health !! Related Basic concepts: 1. SCN 2. Log serial number 3. Log groups and log members, especially

Alter Database Flashbackup {on |Off} -- Mount -- whether to enable the database flash Function {Begin |End} Backup ---- whether to enable the backup mode of the database {Mount | open} -- started and nomount -- Database loading modes:

1. Connect to the database OS: only enters the sqlplus environment and does not connect to the database Sqlplus/nolog OS: Local Connection Method 1: Operating system authentication Logon: The Role After logon cannot be omitted. Set

Dynamic listening: After the Oracle listener runs, the Oracle instance dynamically listens to the listener when it is open.ProgramRegister service_names and instance_name. The default instance_name is:Db_name The default value of service_names is:

Recently, a query statement is required in the project report to count the number of other columns that meet the conditions of a certain column. For example, the following table structure is available:   You need to add a column after

I haven't written anything for a while. I think of a function that I wrote to return the number of days when I used the number of days in a certain month in the Oracle query statement.ArticleNow, we have a little time to take it out for your use,

After a few days of Idle Work, I finally got the job assigned by my superiors and used the crystal report to make several graphical reports. It is not difficult to make a graph. It is very easy to use Crystal Reports. The key is that the query