Oracle

Used to use oracle11g, a Chinese character accounted for 3 bytes, so in the operation of MySQL also has been allocated length.It's been tested today, and we found it wrong.You can see that the length of the first is really 15, but why is the second

Using the Oracle official file (11G) exampleHere is the Oracle Official document interface, to learn about Oracle, the only way to read official documents is to get an overview of official documentation and a more intuitive understanding of official

Procedure1:1 CREATE OR REPLACE PROCEDUREUpdate_ac02_aae140_wyl (pi_aab001inch Number,2Po_fhz outVARCHAR2,3Po_msg outVARCHAR2) is4v_aaz159 Number( -);5 --Description: Take the condition of the old-age insured (that is, AC02), add aae140 = 410,510

Reprinted from: http://blog.sina.com.cn/s/blog_46e9573c01015ik8.htmlThe functions previously described in Oracle are string processing, date functions, mathematical functions, conversion functions, and so on, and a class of functions are general

Oracle 11g Settings Memory Auto-management:ALTER SYSTEM SET memory_target = 1024M scope=spfile;ALTER SYSTEM SET memory_max_target = 1500M scope=spfile;ALTER SYSTEM SET sga_target = 0 scope=spfile;ALTER SYSTEM SET sga_max_size=800m scope=spfile;ALTER

Qingli> Cat ql_mon.shNohup $ORACLE _home/bin/sqlplus-s ql_mon_$1.logDeclareInt_count number (10);N Number (10);N_tmp number (10);N_subsid number (18);N_region number (5);V_biztype VARCHAR2 (5);E_my_exception Exception;E_nobiztype_exception Exception;

EnvironmentOperating system: Win8.1 Enterprise Oracle Development tools: PL/SQL Developer 7.0.1.1066 (MBCS)Steps to download instantclientOracle Instant Client download is available in downloads in http://www.oracle.com/cn/downloads/index.html

Tkprof It is Oracle it comes with a command plug-in tool whose primary function is to convert the original trace file to the type of the text file, for example, the simplest method, using the following:Tkprof LY_ORA_128636.TRC

1. Databases and instancesWhat is a database, in fact, is very simple, the database is a medium for storing data. For example, the commonly used file is one, in oracle10g, the data storage has several kinds. The first is the file format, which is to

1. Create the original table and materialized view logsql> CREATE TABLE t1 (ID int,name varchar2 (30)); Table created. Sql> ALTER TABLE t1 ADD constraint Pk_t1 primary key (ID) using index; Table altered. Sql> create materialized view Log on T1 with

Lock is a mechanism for preventing harmful interactions (deposits, fetching) between transactions when accessing the same resources (including user objects, system objects, memory, shared data structures in Oralce data dictionaries, most commonly,

Today, there is a very strange problem, directly in the eclipse in the SQL copy, and then paste directly copied in the database will be executed very slowly, but after using PLSQL to format the SQL statement, the speed of execution is very fast, and

GrammarDelete from AATRUNCATE TABLE AAdifference 1.delete from the back can write the condition, truncate not.2.delete from records are deleted, each row of records will go into the log, and truncate delete the entire page at once, so the day to the

Get tableSelect table_name from User_tables; The current user's tableSelect table_name from All_tables; All users ' tablesSelect table_name from Dba_tables; including system tablesSelect table_name from dba_tables where owner= ' user name

Original blog: http://blog.itpub.net/519536/viewspace-614893/Today, in the process of deploying a set of 10g Oracle (10.2.0.3 versions), ora-00600:internal error code, arguments: [Keltnfy-ldminit], [46], [1], [], [], [], [ ], [] error.Take this

Oracle EBS reports cannot be copied.A long time ago, my colleague mentioned that EBS reports cannot be copied ..You can set the font size in the upper-right corner ..We can solve the problem that cannot be copied. Click "tool" to copy the file.In

Restoration Methods for deleting online redo logs of Oracle databasesThe online redo log of the Oracle database contains Operation Records of all data in the database. We can use the redo log to perform many operations, such as log mining. Sometimes,

Use a stored procedure to determine whether a person has stayed longer than the specified time in the travel track of a day.The stored procedure is used to determine whether a person has stayed for more than the specified time in the travel track of

Update multi-row data (oracle)Note: The notes summarize several update Methods encountered at work and the applicability of various methods. 1. single Table update solution: use the standard update syntax to perform a stable and efficient update

ORACLE-018: ORACLE tip 001 string processing 1. truncate a string Oracle uses a function substr to intercept a string. The parameter is substr (string, start position, and truncation length ), For example, if the string 123,112 needs to be