Oracle

For simpler tables, the amount of data is not a very much table, you can use a simple SQL statement to back up CREATE TABLE t_fa_cat_20121207 as SELECT * from T_fa_cat Create a new table and save the data INSERT INTO T_fa_cat select * from

One of the surprises in this section is harvesting: the debugging of subroutines. Have not played before, experienced a. --13th Zhang Zi Program and package--13.1 Define subroutine--13.1.1 what is subroutine--code 13.1 Create process Add new

--Scene: --In Oracle 11g environment --the error is as follows: Ora-06502:pl/sql: Numeric or value error: String buffer too small ORA-06512: in "Wmsys." Wm_concat_impl ", Line30--Check the reason: Wmsys. Wm_concat returns a varchar2, so the

The query SELECT statement is used to query data from the database, and when the SELECT statement is used in Pl/sql, it is used with the INTO clause, and the return value of the query is given to the variable in the INTO clause, and the declaration

First go to http://metalink.oracle.com download Oracle Database 10g Release 2 Patch Set 2, FileName: P5337014_10203_winnt.zip, then unzip, run Setup Setup, Note that the database first to stop and do a good backup, run, after the landing Sqlplus run

  There is a user's table to be imported into our system, the original table TM_WWM date is varchar (8) Type, the format is YYYYMMDD. Before importing to my system, we need to see if the date is legal SQL1 Select To_date (saledate, ' YYYYMMDD ')

First, the establishment of service name1, select "Net8 Configuration Assistant", select "Local Network Service name configuration."2, choose "Add".3. Select Oracle 8i database or service.4, enter the service name. This is a customized database

http://www.javaeye.com/topic/133972 These 3 string data types are the most we use, and how we use them in database design. First, let's analyze 3 data types for descriptions: 1.       The length of Char char is fixed, up to 2000 characters long. 2.

I write a sales query function module, but in the test when the bar code/code/warehouse conditions sorted by the time there is no error, as long as the date of the search will have "Ora-01791 is not selected expression" error message, and then view

Date and Time format application To_char (date, formatting parameters) 1, returns any valid delimiter concatenation the month day string 1.1, Select to_char (sysdate, ' Yyyy/mm/dd ') from dual; 2015/04/29 (that is, return a string that is connected

ORACLE DBA face Test setOne: SQL tuning class1 Enumerate several table connection wayssuch as connection, non-equal connection, self connection, outer connection (left, right, full)2 How to view SQL execution plan without the help of a third-party

If you have a string in an SQL statement that is enclosed in a single or double quotation mark, you need to be consistent in the same table, or you will see a "Row not found" error. Use of ALTER statements the use of ALTER statements requires that

The AWR(Automatic workload Repository) Report is an important tool for our daily database performance Assessment and problem SQL discovery. Proficiency in the AWR report, is to do a good job of development, operation and maintenance of the DBA

Oracle compile Failed Object There are many reasons why database objects fail due to database object invalidation, and some common reasons are summarized below: 1: When the structure of the referenced object changes, the dependent object is

Oracle's DB instance is a set of background processes and memory structures, and the memory structure consists of the system global area and the program global Zone.#修改SGA和PGA的配置文件, usually in/. sgz_max_size=64m, sga_target=64m, pga_aggregate_target

Excerpt: https://www.linuxidc.com/Linux/2012-06/62894.htmWhen the case condition then condition is true the value of the else condition is false when the value end--Single query unify the number of times a field equals a valueSelect COUNT

Source: http://www.cnblogs.com/java-class/p/4742740.htmlthe difference between date and timestampThe date type is an Oracle-commonly used datetime variable, and his time interval is seconds. Two date type subtraction is a two-time interval, noting

The previous article introduced the. NET Entity Framework and demonstrated the model first pattern, and this article will continue to discuss the implementation of Code first mode.  I. Summary1. TargetThis document verifies the use of the entity

IP Planning and setting node name IP Configuration Table Node name P Ublicip Vip P rivate IP Scanip 18cdbrac1 128.0.5.101 128.0.5.103 10.10.10.1 128.0.5.105 10.10.10.

Single-line function: For each row of data to be calculated after a row of output results,SQL single-line functions are divided into character functions, numeric functions, date functions, conversion functions, and other general functions based on