Oracle

I. Description of the problemThe following sql:INSERT into TMP (val)VALUES('a&b');View CodeThe following prompts will appear during execution:After clicking "OK", we look at the data in the table:The string after B is not inserted.Two. Reason

The error message that the client gets is usually: Ora-12170:tns: Connection timed outAt this point, we can basically be sure that the server is not open 1521 port (assuming you use the default settings)Workaround:(1) If you are in a LAN environment,

1. Stored Procedure DefinitionsA stored procedure (Stored Procedure), also known as a pre-stored procedure or stored procedure, is a complex program stored in a database.A database object that can be called by an external program as a function or

1. Check the primary and standby environmentDG1 node:sql> archive log list;Database Log Mode Archive modeAutomatic Archival EnabledArchive destination/u01/oradata/tong/archiveOldest online log sequence 59Next log sequence to archive 61Current log

Oracle Java SE arbitrary code Execution Vulnerability hardeningCurrently the vendor has released an upgrade patch to fix this security issue, patch get Link: http://www.oracle.com/technetwork/topics/security/cpujan2014-1972949.htmlDownload jre-8u111-

View the lock table process SQL statement 1:SelectSess.sid, sess.serial#, Lo.oracle_username, Lo.os_user_name, AO.object_name, Lo.locked_mode fromv$locked_object Lo, dba_objects ao, v$session sesswhereAo.object_id =Lo.object_id

When you debug a procedure, function, or package, the company's firewall kills the session connection if there is no action for a long time. This time the database does not actively release the resources of the session, if the procedure, function or

CREATE TABLE TB2 as SELECT * from EMP;ALTER TABLE TB2 modify EMPNO number (4) not null;Turn To Line 20WCreate INDEX Idxtb21 on TB2 (empno);Select Index_name from dba_indexes where table_name= ' TB2 ';--Verify that INDEX is set upSet autotrace

#启动多路径multipathd服务Service MULTIPATHD Restart#设置开机自动启动multipathd服务Chkconfig MULTIPATHD on#查看信息Multipath-llThe mounting method of storing the note size above 2TBPartedParted/dev/mapper/mpath0Mklabel GPTShow printMkpart Primary 0% 100%Show

1. Create a table spaceInstructions for exporting Oracle data:ExpJDs/JDs@192.168.99.199/Orclfile=C:\JDS.DMP owner=JDS Instructions for importing Oracle data: Imp ZCL/Zcl@127.0.0.1:1521/Orclfile=C:\jds.dmp Full=y--1th Step: Create a temporary table

Join on: Multi-Table AssociationInternal connections: Connecting to other tablesFrom table 1 T join table 2 s on t. Field 1 =s. field 2 join table 3 N on N. field 3=t. field 1 or from table 1 A, table 2 B, table 3c where a. field =b. field　　Self-

installation WebLogic Data Source -oracle650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M01/8B/7F/wKioL1hP0H3QS6TEAAHtoDjEMhc656.jpg-wh_500x0-wm_3 -wmp_4-s_2228899324.jpg "style=" Float:none; "title=" 1.JPG "alt=" Wkiol1hp0h3qs6teaahtodjemhc6

======== Pseudo-Column ==========In an Oracle database, a pseudo-column does not exist in the table, but you can query from the table toFor example:SELECT ROWID pseudo-column,tname teacher name from teacher;========= Column number

Non-null constraint: When the column is set, the default can be empty, the setting data cannot be empty after removing the checkmark;Unique constraint: Set in key, UNIQUE constraint name, type unique, column name; After the application is complete,

SYS as[email protected]>startup open;ora-32004:obsolete or deprecated parameter (s) specified for RDBMS instanceORACLE instance started.ORA-32004: does not affect the use of the database. The error message is a parameter expiration. You can see the

1. Character functions:ASCII (x)--Returns the ASCII code of the X characterConcat (x, y)--connect Y to output on XSelect Concat (first_name,last_name) from customers;Initcap (x) capitalize the first letter of each word in XINSTR (' NameName ', ' e ',

The Oracle database character set involves three aspects: Oracle Server-side character set Oracle client-side character set DMP file Character Set The first thing you need to know is that the parameters that affect the database

Oracle performance optimization in my eyesThere are several aspects to the operation of a business system: functionality, stability, efficiency, security. The performance of a system includes network performance, application performance, middleware

Today the Oracle in the package and the cursor learning, no nonsense, some of the online code is wrong, copied to copy, on their own practice under, make a record. Direct, on the codeCreate your own package with Plsql, which is divided into Baotou

Monitoring Alert logsIdea: Follow the alert journal line number to the current last row and the previous scan row compared to the last scanned row from the previous scan line to scan to the final line#!/bin/bashscripthome= ' dirname $0 ' scriptname=