Home > database >  The use of the oracle stored procedure cursor to solve
The use of the oracle stored procedure cursor to solve

Time:02-05

The following diagram, code and output;
How to use oracle cursor kept these output in a variable, such as: SQL=A20 as A20_ administrative divisions, A04 as A04_ (accounts receivable), the aggregate amount of AAB034 as AAB034_ regionalization, AAE002 as AAE002_ statistics monthly, A16 as A16_ five risks accumulated (amount), A15 as A15_ birth insurance (owe), A14 as A14_ (owe), inductrial injury insurance "A13 as A13_ unemployment insurance (owe), A12 as A12_ (owe) of medical treatment insurance, A11 the as A11_ endowment insurance (owe), as A10_ A10 (owe), the aggregate amount of A09 as A09_ birth insurance (accounts receivable), A08 as A08_ (accounts receivable), inductrial injury insurance A07 as A07_ unemployment insurance (accounts receivable), A06 as A06_ medical insurance (accounts receivable), A05 as A05_ endowment insurance (accounts receivable),

One problem very anxious!!!!!!!!!!
Customer want to see the results immediately!!!!!!!!!!!!!!!

CodePudding user response:

A08 as "A08_ (accounts receivable) of inductrial injury insurance"

New column names to add double quotation marks, be careful not to more than 30 characters,
  • Related