Oracle

"The general idea of learning things is: Framework-> details". A teacher once said this, which is also in line with my habits. If you don't talk nonsense, go to the topic. 1. Composition of the Oracle System The architecture of Oracle is divided

During system creation, multiple information is stored in a field separated by commas (,) or other symbols. For example, when one user's one-to-multiple permission is saved, in the permission group field, multiple permission numbers are separated by

Test conditions:Assume that a company is headquartered in Beijing and has a subsidiary in Xinjiang. In this test, the computer in Xinjiang is a local computer, that is, the required IP address is 192.168.1.100. The headquarters in Beijing has a

Add a column: Alter table emp4 add Test varchar2 (10 ); Modify a column: Alter table emp4 modify test varchar2 (20 ); Delete a column: Alter table emp4 drop column test;   Here pay attention to a few places, first, add and modify the column

The In general, it may be mistaken thatDb_file_name_convert: the configuration item is incorrectly configured. modify this configuration item, shutdown immediate, and restart the application log process MRP/LSP. In fact: The corresponding

Oracle analysis function over and Window FunctionI. analysis function overOracle provides analysis functions starting from 8.1.6. analysis functions are used to calculate a group-based aggregate value. What is different from aggregation

Before details, we must make it clear that Oracle does not provide a method to delete data files like tables and views. data files are part of the tablespace, therefore, the tablespace cannot be removed.   I. How to Use offline data

Check database status Check that all INSTANCE statuses and listener statuses are normal. log on to all databases or routines and check the ORACLE background processes: $ Ps-ef | grep ora $ Lsnrctl status SQL> select status from v $ instance; Check

# listener.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME =

1.Database Shutdown Next, let's take a look at how the database performs consistency judgment and recovery Control Based on SCN and Checkpoint. For details about SCN and CheckPoint, refer: Introduction to DBA: Oracle SCN (System Change

Select * from dictionary; -- Data Dictionary A data dictionary is a place where Oracle stores database information. It is used to describe data. For example, the Creator information, creation time information, tablespace information, and user access

In this article, I will introduce how to use oracle trigger to generate autoincrement column in oracle database. I will use an example here to restrict strate. 1. Create a table in oracle database.  View Code Create table USER_INFO ( User_ID integer

In this article, I will introduce how to use oracle procedure to get a cursor type result set. I will represent by registration. 1. Create an example table and add some data:  View Code 1 create table USER_INFO 2 ( 3 User_ID integer primary key, --

  In Oracle databases, undo has three major functions:Provides Consistent Read and RollbackTransaction and Instance Recovery). Consistent read is relative to Dirty read (DirtyRead. Assume that a table T contains 10000 records. It takes 15 minutes to

1. Open PL/SQL Developer If PL/SQL Developer is installed on the machine, open the PL/SQL Developer interface. Enter the user name, password, and host name. This is exactly the same as the configuration in web. config in the program. Click OK. Find

-- Select to_char (add_months (sysdate, 0), 'yyyy-MM-dd') day from dual -- select to_char (add_months (sysdate,-1) of the current date of the previous month ), 'yyyy-MM-dd') day from dual -- select to_char (add_months (sysdate, 1) next month,

Tags: Oracle installation and configuration of original works, can be reproduced, when reprint, please be sure to mark the original source of the article, author information and this statement in the form of hyperlink. Otherwise, legal liability

      Purpose:Measure the test taker's knowledge about how to set parameters in the binary parameter file and understand the meaning of each parameter.Measure the test taker's knowledge about how to use control files and understand the purpose of

ODP. NET is a component created by Oracle for asp.net platform. It is part of ODAC and has a larger function than microsoft's oracleclient platform. The following describes how to use the includeriveparameters method.   1. Public operations of

Alter any cluster: modify the permissions of any cluster Alter any index Alter any role Modify permissions of any role Alter any sequence Alter any snapshot Alter any table Alter any trigger Alter cluster Modify permissions on clusters Alter