James Z. Qiu - San Ramon CA, US Paul Blokhin - Union City CA, US Jie Liu - Foster City CA, US Masayuki Karahashi - San Mateo CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 17/30
US Classification:
707803, 707E17005
Abstract:
A method of application phased upgrade and phased user migration. In one embodiment, in one embodiment a first version of an application generates a first SQL insert statement, wherein the first SQL insert statement comprises a first table name, a first field name, and a first value. A second version of an application generates a second SQL insert statement, wherein the second SQL insert statement comprises the first table name, the first field name, and a second value. A database system inserts a first record into a first table in response to the database system receiving the first SQL insert statement. The database system inserts a second record into the first table via a view in response to the database system receiving the second SQL insert statement. The first record comprises distinct first and second fields corresponding to the first name and a second field name, respectively. The first field stores the first value. The second record comprises distinct first and second fields corresponding to the first and second field names, respectively. The second field of the second record stores the second value.