Oracle

Database version The code is as follows Copy Code Sql> select * from V$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition release 11.2.0.4.

The following is an example of a trigger: Copy Code code as follows: Create or Replace Trigger Logon_ip_control After logon on database Declare IP STRING (30); User STRING (30); Begin SELECT sys_context (' USERENV ', '

Oracle|sql language []oracle pl/sql Language Foundation Oracle Pl/sql Language Basics Pl/sql is Oracle's extension of the standard database language, Oracle has integrated PL/SQL into Oracle servers and other tools, and more developers and DBAs

This article describes how to use SQL loader to insert data from an Oracle database into an Excel file. Implementation purpose: Insert data from an Excel file into an Oracle database Implementation steps: 1. Open Microsoft Excel 2000 2, file (F)

Today in the development of the test environment to install the development of Oracle database hit patch times wrong:[Email protected] 24006111]$ Opatch applyOracle Interim Patch Installer version 11.2.0.3.12Copyright (c), Oracle Corporation. All

Wed May 23 17:46:14 2018Tt01:standby Redo logfile selected for thread 1 sequence 42251 for destination log_archive_dest_10Wed May 23 17:46:15 2018Error ORA-235 occurred during an un-locked control file transaction. ThisThe error can be ignored. The

Directory Cache Fusion principle What is Cache Fusion? What is high availability The difference between FAILSAFE and RAC RAC and OPS differences Differences between hot standby, RAC, and Data guard for dual machines

Pits Paste, has been using the jmeter2.13 version of the Oracle test, changed today to 3.2 version, found to follow the previous method of testing, the JDBC request results always error: Cannot create Poolableconnectionfactory (ora-00923:δ???????

1. Install the new Check_mk_agent,1.2.5i7 version above and make sure the Mk_oracle script is installedCopy the mk_oracle script from the server side to the target servercp /usr/share/check-mk-agent/plugins/mk_oracle

On the internet for a long time, it is possible that the problem is now when data is taken from dual, the fields of the Clob object are converted to longThe final solution uses the BEGIN and end syntax:1. Use the Begin and end2. Use the INSERT INTO

Original statement with no double quotes on the surface:INSERT into Xm_ftp_lvl_mgr_hr VALUES (' 191 ', ' 457 ', ' Zhang A810 ', ' 080072 ', ' 1 ', ' null ', ' null ', ' null ', ' 1 ', ' null ', ' system administrator ', ' 2018-06-21-11:47:59 ', '

one, mybatis call stored procedure1 Create the following stored procedure in the databaseCreate or Replace procedure Pro_hello (P_user_name in Varchar2,p_result out VARCHAR2) isBeginP_result: = ' Hello, ' | | P_user_name;End2 Writing the SQL mapping

Customer a test environment, the host abnormal power outage, after startup found that undo file corruption, unable to start, in the open stage error as follows:Errors in

Does awr need to be disabled? Such a nice stuff. By default, AWR is available and requires a certain amount of sysaux table space to be consumed. But when it comes to the AWR-related debug package (which requires license) to access the AWR view or

1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start

Oracle Cluster Concepts and principles (ii) Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary

Quickly view information such as output file or log for a request in ORACLE EBS On the project, there are often requests to report yellow and other issues reflected on the technical consultant side, but due to certain restrictions, sometimes even

 1. Oracle 10g1. 1 Description In Oracle 10 Gb, passwords are case-insensitive by default. This is due to the default parameters of the password file.   C: \ Users \ administrator. David Dai> orapwd Usage: orapwd file = entries = force =

As shown in the preceding figure, file 2 cannot be recovered normally (you need to check the log analysis reason). file 3 was offline before and must be archived in a historical manner (not in the archive status, so this should be placed first,

Recently a lot of friends consulted 12.1.0.2 and later versions using oradebug to modify scn failed, here to do a test under normal circumstances can not be modified (oradebug poke reported ORA-32519 or ORA-32521 ), A series of modifications are