Oracle

SQL Server Replace Null:isnull (Arg,value) For example: Select IsNull (price,0.0) from orders, if Price is null, replace with 0.0 Compared to null: is not null,is null For example, select * from to orders where price is null and price equals

Open Toad,1, menu bar session->new Connection .... Open the following window:2, after entry, menu Datebaseàsechema brower ... Find Table Space tabAfter opening, the following interface is displayed:Then switch to another tab: Date Feiles ()After a

One, the Oracle log mode is divided into (Logging,force logging,nologging)The default is logging, which is recorded in the Redo log, force logging is forced to log logs, nologging is to minimize the log. Force logging can be set at the database

Swingbench Introduction:The swingbench consists of a load generator, a coordinator, and a cluster overview. The software makes it possible to generate loads and map the transaction/response time of the chart.Swingbench can be used to demonstrate and

Copy links using Thunderbolt can be downloaded. Introduction of 4 kinds of packages:_database_*.zip is the Oracle database Server Software installation package, if you want to create a database, please download this version_client_*.zip is an

Reprint Please specify source: http://blog.csdn.net/dongdong9223/article/details/47448751This article is from "I'm a fish-hook blog." When importing data using the IMPDP data pump in Oracle, it is assumed that the user was created before the

How to find ASM packages at high speed at the Otn site and download*********************************************** Declaration ************************************************original works. From the "Blue Blog" blog, Welcome to reprint, please be

Recycle Bin ConceptStarting with Oracle 10g, a concept called the Recycle Bin (Recycle bin) was introduced. Its full name is called Tablespace Recycle Bin. The Recycle Bin is actually a logical container (logical region), which is somewhat similar

1, first check whether DG Space is sufficientSql> select Name,total_mb,free_mb,usable_file_mb from V$asm_diskgroup;NAME TOTAL_MB FREE_MB USABLE_FILE_MB--------------------------------- ---------- ---------- --------------DATADG 4198790 230531

Reprinted from:The difference between db_name,sid,db_domain,service_name and so on in OracleDb_name: A unique identifier for a database (Oracle db). This representation is sufficient for a single database, but with the popularization of a

In 12c, Oracle introduced the History command, which is much like the history in the Shell, reducing the knock-down of SQL and bringing a lot of convenience.1. View the history HelpSql> HelpHistory-------Stores, lists, executes, edits of the

Oracle Instant Client is a lightweight database client released by Oracle, let's look at the official definition:Instant client allows you to run your applications without installing the standard Oracle client or have an oracle_home. OCI, OCCI,

Ora-00257archiver Error Resolution1. Previous processing of single-machine over Oracle 11.2.0.4 archive log disk space is insufficient, but there is no problem with insufficient archive log disk space for Oracle RACSo there is no expectation that

For the traditional large-scale software products using relational database, the continuous development and maintenance of the background database can produce a large number of script files, how to make versioning more convenient for these script

The Decode function is one of the powerful functions of Oracle PL/SQL. Only Oracle's SQL provides this function at the moment, and the SQL implementations of other database vendors do not yet have this capability.What is the use of decode? Let's

Oracle database Cluster disaster tolerance implementation and maintenance (Rac+dataguard+goldengate) Training TutorialsPackage Description:Wind Brother Oracle Database Cluster disaster Recovery (rac+dataguard+goldengate) Implementation and

Course IntroductionWind Brother Oracle Video tutorial > 10th 10 sets: Oracle Database Job task management. Oracle Database Job description, Dbms_job usage parameters, dbms_job use case explanation, Dbms_job time parameter Summary, Oracle Scheduler

The Oracle environment is frequently used at work, but each time it is set up, it is time-consuming to install the Oracle VM in a virtual machine template, but the environment, such as IP every time, is time intensive, so think of the images that

Yesterday in the processing of a character split function, using the INSRT () function, the accidental discovery actually can replace the fuzzy query like, after several tests can save efficiency more than one times.The code is as follows: select

Use SHELL script to verify Oracle Database RMAN Validity of backup setsauthor : Zhao Full text Network name : Guestart Our production environment oracle database has been made Rman Backup, is a week of rman backup retention policy; In addition to