Oracle

Add environment variables before installing Oracle 10gVariable name: tns_adminVariable Value: D:\oracleclient\instantclient_11_2This will generate three files under this file after Oracle installation: Listener.ora, Sqlnet.ora, Tnsnames.oraMove

By creating a trigger to log user login, audit the logged-in user, record the login user, host, system users and IP address:1. Create a table in SYS mode that records the details of the client's login to the database

Synonyms:A synonym is an alias to another data object, the synonym is dependent on its target object, and the synonym becomes invalid if the target object is changed or deleted.Synonyms are not a substitute for the privileges of database objects,

Take the training of Oracle recently, and make a study summary here.1, Oracle Database tuning can not only expect to modify a few database parameters to have a clear effect, the problem is more in the application, educating developers to correctly

Oracle Notes (13) Views, synonyms, indexesFirst, the ViewIn all the SQL syntax previously studied, the query operation is the most troublesome, if the program developers will be a lot of energy wasted on the query writing, it will certainly affect

Oracle Notes (eight) complex queries and summariesOne, complex query1. List all department numbers and names of at least one employee and count the average wage, minimum wage and maximum wage of these departments.1. Determine the required data sheet:

Loop loop DeclareP_sum Number:= 0; P_i Number;Beginp_i:= 1; Loop p_sum:=P_sum+p_i; P_i:=P_i+ 1; If(p_i> -) ThenSYS. Dbms_output.put_line (p_sum); Exit; End if; EndLoop;End; While loop DeclareP_sum Number:= 0; P_i Number;Beginp_i:=

Oracle Basic theoryL Mainstream DatabaseMicrosoft Corporation: SQL Server ACCESSIBM Company: DB2 InfomixOracle Company: Oracle MySQL (AB Company) Small databaseACCESSFoxBaseDevelopment capacity: 100 peopleVisits: 10

Today, two tables of data are synchronized, and the table has its own association relationship. The new data has been deleted because no changes have been made to the synchronized table (a new number of data has been added, and there is a

Recently implemented a project to use a domestic dual-machine hot-standby products, but in the database to do two-machine hot standby There are some problems, there is no way. Have to study it! After two days of research finally the problem was

Oracle database Opatch Patch Operation flow1. Confirm Database VersionSql> select * from V$version;2. Query patch Installation InformationSql> select * from Dba_registry_history;Oracle database patches are generally divided into two CPU and PSU

This is a very water blog that introduces building Plsql Developer 8 + Oracle 11g development environment.The installation of Oracle 11g Express on this machine is sufficient for development, and 300MB of download files are much smaller than the

Review MySQL CREATE TABLE statement users (ID integer/name string/birthday date type, default today)Drop table if exists users;CREATE table if not EXISTS users (ID int (5) Auto_increment primary KEY,Name varchar (4) is not NULL,Birthday date default

Ount (1) compared to count (*): If your data table does not have a primary key, then count (1) is faster than COUNT (*) If there is a primary key, then the primary key (the Federated primary key) as the count condition is also faster than

Oracle's cluster management software and databases are very dependent on the private network, and many cluster problems can be attributed to the network level at the end.It is necessary to check the network information when there is a problem with

First, back paragraph introduction In an Oracle database, when something modifies the data, Oracle first saves the original value of the data to a fallback segment. A thing can only save its fallback information to a fallback segment, while multiple

Environment:Os:hp-unixDatabase: 11.2.0.4 Dual-machine RAC(i) PhenomenonWhile cleaning up the ORACLE logs, it was found that there were a lot of clsc*.log under the $oracle_home/log/{instance_id}/client. After observation, it is found that 2 logs are

When 11241_bbed2.txt,11242.txt 201710000112420.bbed's use question 2.txt-- // Bbed is a good tool for exploring oracle data blocks. Sometimes it can directly view the internal structure of oracle internal blocks without dumping.-- // Pay attention

How to change the data file location of a tablespace in Oracle Table space Overview Oracle tablespace is a logical space used to store database objects (such as data files) in Oracle. It is the largest logical unit for storing information in Oracle,

201710000111320.modify the table structure to delete the relevant questions. txt, 20171113.txt 2017100001113133 modify the table structure and delete the related question txt-- // Maintain the table structure to delete fields firstAlter table set