batch queries SqlServer vs Oracle

  • Thread starter Thread starter Kris Desmadryl
  • Start date Start date
K

Kris Desmadryl

SqlServer allows multiple sqlstatements in one SqlCommand by using ';'
This can for instance be used for refreshing after an insert statement or
for filling mutiple datatables with one command.

I don't think Oracle can do this, I hope I'm wrong...

Kris.
 
Kris said:
SqlServer allows multiple sqlstatements in one SqlCommand by using ';'
This can for instance be used for refreshing after an insert statement or
for filling mutiple datatables with one command.

I don't think Oracle can do this, I hope I'm wrong...
Click to expand...

Oracle can do this, but Oracle is removing the possibility from the
..NET providers, starting with the 10g provider and the new 9i providers
will have this too if I'm not mistaken.

In other words: don't batch statements.

Frans.

--
 
Or don't use Oracle ;-)

Frans Bouma said:
Oracle can do this, but Oracle is removing the possibility from the
..NET providers, starting with the 10g provider and the new 9i providers
will have this too if I'm not mistaken.

In other words: don't batch statements.

Frans.

--
Click to expand...
 
Back
Top