Link to home
Start Free TrialLog in
Avatar of pvsbandi
pvsbandiFlag for United States of America

asked on

Advantage of cursor

Hi,
 
 I have to insert rows, generated from an SQL statement into a table.
 I thought of Insert into <table_name> select ...
 
But some existing procedures, are using cursor and loop to insert into the tables.
 Why do i need to use a cursor, when i can use an insert into select?
 Please advise.
Avatar of pvsbandi
pvsbandi
Flag of United States of America image

ASKER

Sorry, Java zone got added by mistake. Please remove.
Avatar of CEHJ
You need to get it removed yourself. See the 'Request Attention' link
ASKER CERTIFIED SOLUTION
Avatar of momi_sabag
momi_sabag
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks much for the insight!