The oracle database stored procedures-CodePudding

 
The open xx for dynamic SQL statements; - how to obtain xx cursor on the number of records?

CodePudding user response:

Take the cursor before select count (*) don't know

CodePudding user response:

reference 1st floor sxq129601 response:

take the cursor before select count (*) it is not to know

SQL is dynamic

CodePudding user response:

This want to loop the, more troublesome.

CodePudding user response:

reference wmxcn2000 reply: 3/f

this to cycle, more troublesome.

How to cycle? Can you give an example,
Dynamic SQL statement field is different also

CodePudding user response:

reference 4 floor ycw20111225 response:

Quote: reference wmxcn2000 reply: 3/f

This want to loop the, more troublesome.

How to cycle? Can you give an example,
Dynamic SQL statement field are not the same as

Why can't the dynamic SQL select count (*)?

The execute immediate 'select count (*) from' | | tablename into v_num;
You try it?